DE Mock Interview: SQL, PySpark & Databricks with Abhishek Maurya

Practise a realistic data engineering interview, modelled on the rounds top product companies run, before the real one.

Format (45 min):

• SQL: window functions, joins, aggregations, query optimisation

• PySpark / Spark: transformations, partitioning, data skew, performance tuning

• Data modelling and pipeline design: batch vs streaming, Delta Lake, SCD, idempotent pipelines

• Production scenarios: "This job suddenly takes 3 hours instead of 20 minutes. What do you check?"

You get:

• Honest feedback on where you'd gain and lose points

• A focused list of topics to revise before your interview

When booking, share your experience level and the company/role you're targeting so I can tailor the questions.

About me: Data Engineer at GHD.