Interview questions

Data Engineer interviews: what they ask, and test.

The 5 questions candidates report most in Data Engineer interviews, and what 2,429 Data Engineer job ads in the United States and Canada test for, led by ETL/ELT (83%), SQL (77%) and Python (77%).

From 2,429 Data Engineer job ads in the United States and Canada, May 19, 2026 to November 15, 2026. Updated November 15, 2026. How we count. Free to reuse with credit: CC BY 4.0

The questions asked most

  1. How would you find or remove duplicate rows in a table?

    Why it's asked: Tests practical SQL skill, especially window functions like ROW_NUMBER() for cleaning data.

    Technical

  2. Solve a window-function problem, such as second-highest salary, top-N per group, LAG/LEAD comparisons or running totals.

    Why it's asked: Checks whether you can use window functions fluently for common analytical SQL patterns.

    Technical

  3. How would you speed up a slow query?

    Why it's asked: Tests whether you can diagnose performance problems, including indexing (e.g. clustered vs non-clustered).

    Technical

  4. Design a data warehouse model: star vs snowflake schema, facts and dimensions, and slowly changing dimensions (e.g. SCD Type 2).

    Why it's asked: Tests data modelling, which sources say often decides the onsite, especially at senior level.

    System design

  5. Design a data pipeline or platform (e.g. near-real-time clickstream aggregation or a usage-analytics platform for a SaaS company).

    Why it's asked: Tests whether you can turn a vague prompt into a sensible design and reason about batch vs streaming and ETL vs ELT.

    System design

From Mettlespark's interview research. 15 more Data Engineer questions, each with how to answer it, are in Mettlespark.

Preparing for one job?

Paste its link. Mettlespark reads the job ad and your CV, and prepares you for that interview: the questions its employer asks, and how to answer them from your own experience.

What the job ads test for

What Data Engineer job ads ask for
SkillRequired when named
ETL/ELT96%
SQL95%
Python90%
Data Quality92%
Data Modeling94%
AWS71%
Data Warehousing87%
Data Governance82%
CI/CD80%
Machine Learning79%

2,429 Data Engineer job ads, May 19 to November 15, 2026

Where you stand

What Data Engineer job ads ask for

2,429 job ads from 1,183 employers, last 180 days. Tick what you have.

0%

of what Data Engineer job ads ask for. Tick what you have.

See where you standFree in early access. Your ticks and the role come with you.

How to prepare

On this page

  • The 5 questions Data Engineer candidates report most, and why each is asked
  • What its job ads test for, skill by skill
  • How to prepare, from those figures

Only in Mettlespark

  • All 20 Data Engineer questions in Mettlespark's interview research, each with how to answer it
  • Preparation for one job ad: the questions its employer asks, matched to your CV
  • Your fit for Data Engineer roles: the skills your CV shows, and the ones to close first
  • A learning plan for the gaps, sized to your week, with projects to show employers
  • Every application tracked, from awaiting a reply to an offer
Prepare in Mettlespark

Quick answers

What do Data Engineer interviews test?

The skills its job ads ask for most: ETL/ELT (83% of ads), SQL (77% of ads), Python (77% of ads) and Data Quality (61% of ads).

What questions are asked in a Data Engineer interview?

The ones candidates report most: “How would you find or remove duplicate rows in a table?” “Solve a window-function problem, such as second-highest salary, top-N per group, LAG/LEAD comparisons or running totals.” “How would you speed up a slow query?”

How many years of experience do Data Engineer job ads ask for?

The median Data Engineer job ad asks for 5 years.

More on Data Engineer