Applied online and started with a recruiter screen, covering background, past projects, and culture fit.

Next was a Technical Phone Screen with a Data Engineer, split into two parts:

• SQL: Wrote queries using joins, aggregations, subqueries, and handled NULL values.
• Python: Involved simple data manipulation tasks like working with lists, dictionaries, and condition checks.

The final onsite round had four back-to-back interviews.

• The first was SQL/ETL, focusing on optimizing queries, transforming raw data, and designing ETL pipelines.
• The second was Data Modeling, where I designed a relational database for an app, defined schema, and discussed trade-offs.
• The third was Product Sense, evaluating how data impacts decision-making and defining key metrics for business scenarios (e.g., retention analysis for a gaming app).
• Last was Behavioral/Ownership, covering standard "tell me about a time" questions related to collaboration, problem-solving, and stakeholder management.

Prepped with LeetCode, SQL practice (Mode, StrataScratch), and mocks on Prepfully with ex-Data Engineers. Got the offer :)

Design model for a gaming company, such as Epic Games.