Data Engineer at GHD
Get 5 data engineering interview questions in the style of FAANG/MAANG rounds, free, with complete solutions and the follow-ups interviewers ask next:
• SQL: users who logged in 3+ days in a row (gaps and islands)
• SQL: sessionise clickstream events with a 30-minute inactivity rule
• PySpark: one task takes 40 minutes while 199 finish in 1 (data skew, AQE, salting)
• Design: make a daily pipeline idempotent and safe to backfill
• Production: a Spark job went from 20 minutes to 3 hours with no code change
These 5 come from my full 44-question Data Engineering Interview Pack.
About me: Data Engineer at GHD.
