DE Interview Pack: 44 FAANG-Style Q&A with Abhishek Maurya

Preparing for data engineering interviews at top product companies? This 25-page PDF gives you 44 interview questions in the style of FAANG/MAANG data engineering rounds, each with a complete solution, the reasoning interviewers look for, and the follow-up questions they ask next.

What's inside:

• 12 SQL questions: ranking and ties, gaps-and-islands streaks, sessionisation, D1/D7 retention cohorts, median without MEDIAN, friend recommendations at scale, the NOT IN NULL trap

• 10 PySpark / Spark questions: data skew and salting, broadcast joins, SCD Type 2 with Delta Lake MERGE, stages and shuffles, streaming watermarks, UDF performance

• 6 data modelling questions: ride-hailing model, SCD types, event modelling, fact table types, partition strategy

• 6 pipeline design questions: real-time clickstream architecture, idempotent backfills, exactly-once, CDC, data quality, cost at 1B events/day

• 6 production scenarios: job went from 20 min to 3 hours, slow MERGE on 2B rows, duplicates after rerun, executor OOM, small files, schema drift at 2 AM

• 4 behavioural questions for data engineers + a 30-day preparation plan

Want to see the quality first? Download the free 5-question sample on my page.

Note: all questions are original, written to match topics commonly reported for data engineering interviews at large product companies. They are not leaked or confidential questions from any company.

About me: Data Engineer at GHD.