Mid-Level Data Engineer Interview
~1 hour 8 Topics
Companies: Flipkart, Swiggy, Razorpay, Zerodha
What You'll Learn
Before You Read This
You are 2-5 years into data engineering. You have built pipelines, written a lot of SQL, and probably broken production at least once.
Scenario 1: The Join That Returned 400x Too Many Rows
The Prompt "A query that used to return 10,000 rows now returns 4 million rows after someone added a JOIN. Nothing else changed.
Scenario 2: The Warehouse Bill That Tripled
The Prompt "Your team's monthly warehouse bill tripled this month with no change in data volume.
Scenario 3: The Schema Change Nobody Announced
The Prompt "A source team renamed a column from cust_id to customer_id without telling anyone.
Scenario 4: The Incremental Model That Stopped Being Incremental
The Prompt "A dbt incremental model has run fine for six months. This week dbt run for it started taking 45 minutes instead of 3. Nothing errored.
Scenario 5: The Backfill That Took Down the Dashboard
The Prompt "You need to backfill three months of history into a table a live dashboard reads from.
Scenario 6: The Metric Two Teams Can't Agree On
The Prompt "Two analysts compute 'monthly active users' for the same month and get numbers that differ by 8%. Both queries look correct.
Salary Reference
These numbers assume you can talk through all six scenarios fluently with real commands and reasoning, not just definitions.
Skills You'll Master
Curriculum Index8 topics
Before You Read This
You are 2-5 years into data engineering. You have built pipelines, written a lot of SQL, and probably broken production...
Scenario 1: The Join That Returned 400x Too Many Rows
The Prompt "A query that used to return 10,000 rows now returns 4 million rows after someone added a JOIN.
Scenario 2: The Warehouse Bill That Tripled
The Prompt "Your team's monthly warehouse bill tripled this month with no change in data volume. How do you investigate?
Scenario 3: The Schema Change Nobody Announced
The Prompt "A source team renamed a column from cust_id to customer_id without telling anyone.
Scenario 4: The Incremental Model That Stopped Being Incremental
The Prompt "A dbt incremental model has run fine for six months.
Scenario 5: The Backfill That Took Down the Dashboard
The Prompt "You need to backfill three months of history into a table a live dashboard reads from.
Scenario 6: The Metric Two Teams Can't Agree On
The Prompt "Two analysts compute 'monthly active users' for the same month and get numbers that differ by 8%.
Salary Reference
These numbers assume you can talk through all six scenarios fluently with real commands and reasoning, not just...
Career Impact
Roles this pack prepares you to interview for.
- High Demand
Platform Engineer
Rs 22L - Rs 45L a year
Next Modules
Practice on the Coding Sheet
Not a software engineer sheet. Every problem comes from real DevOps, SRE, Platform and Cloud interviews, from your first script to a system you build yourself.
Open the Coding Sheet