Applied Online

1. Two-and-a-half-hour OA focusing on SQL and Python (mostly SQL with pretty difficult questions).

2. Invited to a first-round interview with a senior data engineer. This focused on a few LPs like Customer Obsession and involved coding in SQL and Python, with questions increasing in difficulty gradually. Data modeling was also covered.

3. Final interview loop (total of 5 hours with 4 interviews). Three interviews focused on designing data applications and data engineering terminology (e.g., OLAP vs. OLTP, when to use each). System design questions were also asked, such as: "Design a system that processes a lot of user orders each day." Follow-up questions included: "The current system is performing slowly. How would you test and improve the database?"

OLAP vs. OLTP, when to use each. System Design: such as designing a system that processes a lot of user orders each day. Follow-up questions such as: The current system is performing slowly. How would you test and improve the database?