--- title: "Data engineer interview questions and what to expect | Orbit" description: "What data engineer interviews usually test, the usual stages, and 17 practice questions with what a good answer covers. Practise free in the warm-up." canonical: https://orbitanswer.com/roles/data-engineer last_reviewed: 2026-10-18 --- [Companies](https://orbitanswer.com/companies) [Roles](https://orbitanswer.com/roles) [Free warm-up](https://orbitanswer.com/warmup) - [Home](https://orbitanswer.com/) - [Roles](https://orbitanswer.com/roles) - Data engineer Role interview guide # Data engineer interview questions and what to expect Data engineer interviews usually focus on SQL, data modelling and building reliable pipelines that move and transform data at scale. Candidates commonly report hands-on SQL and Python or Scala questions, a discussion of tools such as Spark, Airflow, Kafka and cloud warehouses, and for experienced roles, a design round on building a pipeline or warehouse end to end. What candidates commonly report; it varies by employer, level and country. Last reviewed 18 October 2026. [Practise a data engineer mock interview](https://orbitanswer.com/register) [Warm up free on these questions](https://orbitanswer.com/warmup?track=role%3Adata-engineer) ## The usual stages - 1 Recruiter or HR screen - 2 SQL and coding screen: often advanced SQL plus Python - 3 Data modelling and pipeline design: schemas, batch and streaming - 4 Tools discussion: Spark, orchestration, warehouses and the cloud platform you've used - 5 Project deep dive with the hiring manager - 6 HR round ## What interviewers check - Strong SQL, including window functions and query performance - Data modelling: facts, dimensions, and when to denormalise - Pipelines that can be rerun safely, are monitored, and recover cleanly - Data quality checks and clear ownership of data - How distributed processing and partitioning work - Awareness of what cloud data work costs ## Behavioral questions ### Tell me about a pipeline that failed in production. How did you find and fix the problem? A good answer covers - How it failed, and who noticed first - How you traced the cause: logs, data checks, changes upstream - The fix, the backfill, and the monitoring you added ### Describe a time people using your data found a problem in it before you did. A good answer covers - What was wrong and how it affected them - How you corrected the data and kept them informed - The check you added so you'd catch it first next time ### Tell me about a time you made a pipeline much faster or cheaper to run. A good answer covers - The starting runtime or cost - What you changed: partitioning, file formats, incremental loads, rewriting queries - The result in numbers ### Tell me about a time different teams defined the same metric differently. How did you sort it out? A good answer covers - The metric and each team's version of it - How you reached one definition and documented it - How the change was rolled out to reports and users ## Questions about the job ### Explain the difference between ETL and ELT, and why many teams now load data first and transform it later. A good answer covers - Transforming before loading versus transforming inside the warehouse - How scalable cloud warehouses changed the trade-off - When ETL still makes sense: sensitive data, heavy cleaning before storage ### How would you design a star schema for an online shop's sales reporting? A good answer covers - A sales fact table at a clear grain, such as one row per order line - Dimensions for product, customer, date and channel - What happens when a dimension changes, such as a customer moving city ### What are slowly changing dimensions? Explain type 1 and type 2. A good answer covers - Type 1 overwrites the old value; type 2 keeps history by adding new rows - Effective dates and a current-row flag - When the business actually needs the history ### What does it mean for a pipeline to be idempotent, and how do you make a daily job safe to rerun? A good answer covers - The same result no matter how many times it runs - Overwriting partitions or merging on keys instead of blindly appending - Handling late-arriving data and backfills ### Batch or streaming: how would you decide for a new data feed? A good answer covers - How fresh the data needs to be, and what it's used for - The extra cost and complexity of streaming tools such as Kafka and stream processors - Late, out-of-order and duplicate events ### A Spark job that used to take ten minutes now takes two hours. How would you investigate? A good answer covers - Checking data volume and recent code or configuration changes - Using the Spark UI to look for skewed partitions, large shuffles and spills to disk - Fixes: repartitioning, broadcast joins, filtering early, sensible file sizes ### Explain partitioning, and why columnar file formats such as Parquet matter for analytics. A good answer covers - Partitions let queries skip data they don't need - Columnar formats read only the needed columns and compress well - The problem of too many small files ### Talk me through building a pipeline that pulls data from a third-party API every hour. A good answer covers - Scheduling with an orchestrator such as Airflow, with retries - Rate limits, pagination and pulling only what's new - Landing raw data first, then validating and transforming, with alerts on failure ### What data quality checks would you put on an important table? A good answer covers - Row counts, nulls, uniqueness, valid ranges and freshness - Comparing totals between source and target - What happens when a check fails: stop the pipeline, alert, or set the bad rows aside ### Talk me through a SQL approach to remove duplicate records and keep only the latest one for each customer. A good answer covers - ROW_NUMBER partitioned by customer and ordered by update time, newest first - Keeping only row number one - How ties and missing timestamps are handled ### How would you handle personal data such as email addresses and phone numbers on a data platform? A good answer covers - Role-based access, and masking or hashing sensitive columns - Keeping only what's needed, and only for as long as needed - Supporting deletion requests and logging who accessed what ## Motivation and fit ### Why data engineering rather than analytics or data science? A good answer covers - Enjoying building the foundations other people rely on - An example project that shows it - What you want to learn next: streaming, cloud platforms, modelling ### What would you want to understand about our data platform in your first month? A good answer covers - The main sources, pipelines and who uses the data - Known pain points: cost, reliability, data quality - How data work is prioritised between teams ## Tips - Practise SQL until window functions, CTEs and joins feel routine; most loops test them early. - Be able to draw one of your pipelines from source to dashboard, with its data volumes, schedule and failure handling. - Mention reruns, backfills and monitoring in any design answer; they separate working pipelines from demos. - Know why you chose each tool on your resume, and one weakness of each. - Talk about cost: cloud data work is often judged on what it costs to run as well as how fast it is. ## Practise it out loud A mock interview asks what data engineer interviews usually test, follows up on your answers and gives you a report. The warm-up is free, needs no account and checks five of these questions as you answer. [Practise a data engineer mock interview](https://orbitanswer.com/register) [Warm up free on these questions](https://orbitanswer.com/warmup?track=role%3Adata-engineer) ## About this guide Written by Orbit from what candidates and interviewers commonly describe for this kind of job. The questions are Orbit's own practice questions, not questions taken from any employer's interviews. Processes change, so check the job post and what your recruiter tells you. ## Company guides to read with this one - [Adobe Adobe's careers site describes a call with a Talent Partner, an interview with the hiring manager, then skills assessments and team interviews: coding… 14 practice questions](https://orbitanswer.com/companies/adobe) - [American Express American Express interviews usually combine behavioural questions on its Blue Box Values, such as 'We Back Our Customers' and 'We Do What's Right', with… 13 practice questions](https://orbitanswer.com/companies/american-express) - [Airbnb Airbnb's interviews are known for pairing technical or craft rounds with interviews about its core values, which it publishes: Champion the Mission, Be a… 13 practice questions](https://orbitanswer.com/companies/airbnb) - [Barclays Barclays' interviews usually explore why you want the role and how your past examples show its five published Values: Respect, Integrity, Service, Excellence… 14 practice questions](https://orbitanswer.com/companies/barclays) ## More guides: data and ai - [Data scientist Data scientist interviews usually test statistics, machine learning, SQL and Python, then how you'd use them on a business problem: choosing a metric,… 17 practice questions](https://orbitanswer.com/roles/data-scientist) - [Machine learning engineer Machine learning engineer interviews usually combine software engineering (coding and system design) with machine learning: how models are trained, evaluated,… 17 practice questions](https://orbitanswer.com/roles/machine-learning-engineer) - [Data analyst Data analyst interviews usually test three things: whether you can get the right numbers out of data (SQL and spreadsheets), whether you can reason about what… 14 practice questions](https://orbitanswer.com/roles/data-analyst) [All 32 role guides](https://orbitanswer.com/roles) [Guides by company](https://orbitanswer.com/companies)