Skip to content

Data engineering interview questions

SQL, Spark, pipelines, orchestration and warehousing.

348 questions · 24 topics · 48 free answers

Data Engineer roadmap4 stages from basics to interview-ready. Learn the gaps, then come back and practise.

0 of 348 practised · 0 bookmarked · saved on this device

348 questions

  1. #1What are the types of joins?EasyConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  2. #2What are window functions and how do ROW_NUMBER, RANK and DENSE_RANK differ?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  3. #3How do you find the second highest salary per department?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  4. #4How do you remove duplicate rows from a table?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  5. #5What is a CTE and when is a recursive CTE useful?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  6. #6How do you write an incremental upsert in SQL?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  7. #7How do you calculate a running total and a moving average?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  8. #8What is a slowly changing dimension and what are Types 1, 2 and 3?MediumConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  9. #9A SQL report that ran in 2 minutes now takes 40. What do you check?MediumScenarioSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

  10. #10How do you handle skewed joins and data in distributed SQL engines?HardConceptSQL for data engineers Pro answer

    This answer is part of Pro

    10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.

Hunting for a Data engineering role too? See open Data engineering jobs.