Google L4 | Application Engineer ( Data) | Hyderabad

Company: Google
Level: L4
Position: Application Engineer, Data

Round 1:

Sql question on find managers who are not in same location as their employees ( self join )
https://leetcode.com/problems/longest-consecutive-sequence/description/
https://leetcode.com/problems/longest-substring-with-at-most-two-distinct-characters/description/
https://leetcode.com/problems/two-sum/description/

Round 2:

https://leetcode.com/problems/best-time-to-buy-and-sell-stock/description/
https://leetcode.com/problems/best-time-to-buy-and-sell-stock-ii/
Given a employee table employeeid and managerid , employee name. Find hierarchy for an employeeid upto highest level. - Recursive CTEs concept

Round 3:

SQL question using Recursive CTE and a simple python implementation of the same.

Round 4:

Behavioural questions / General Googlyness questions

Round 5 ( System Integration ):

Integrate on-hand inventory data from our global network of warehouses, each managed by different systems, to a central ERP.

Discussed Data pipeleine designing for different sources and their integration into data warehouse , Data Reconcillation , Authentication with different systems involved , Trade-offs between choosing different ingestion mechanisms for different usecases.

Round 6 ( Application Design ):

Design a car rental reservation system.System Should allow user to book a car for a given time, cars can have multiple tier, discounts etc.The system should support multiple tenants.

Discussed Business, Techincal requirements , Data modelling ( LLD ) and general application design of the same.

Verdict: Rejected as my Application Design is not upto the mark. Even though the role is for data engineer , you are expected to know general application design.