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.