Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Deloitte Data Engineer Interview Questions

The questions to prepare for a Deloitte Data Engineer interview. Questions from real interview reports rank first. Updated daily.

50questions
~9htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 13 questions · ~140 min
Per-Customer Cumulative SalesMedium
Practice

Calculate cumulative sales for each customer using a partitioned running total ordered by product.

Data Manipulationdatabase queryingAggregationsDeloitte
Highest and Lowest SalaryMedium
Practice
Recently asked

Find the highest and lowest non-null salary values once each, excluding duplicate and unrecognized salary records.

data cleaningData ManipulationAggregationsDeloitte
More SQL & Data Manipulation questions with a free account
2
Coding6 questions · ~65 min
Read JSON into BigQueryMedium
Practice
Recently asked

Validate JSON records and prepare a deterministic BigQuery load payload using Python's standard library.

api integrationCodingdata persistenceDeloitte
Second Highest Salary with Dense_RankEasy
Practice
Recently asked

Return the second distinct highest salary by applying dense-rank semantics in a single array scan.

aggregationArraysAlgorithmsDeloitte
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
System Design14 questions · ~151 min
Airflow IdempotencyHard
Recently asked

Design an idempotent Airflow data pipeline that prevents duplicate writes when DAGs are retried or manually retriggered.

distributed systemsdata ingestionfailure modesDeloitte
Resource Exhaustion AnalysisHard
Recently asked

Analyze a resource-exhausting query by isolating the bottleneck, validating evidence, and preventing recurrence.

database accessanomaly detectioncomputational costDeloitte
More System Design questions with a free account
4
Pipelines13 questions · ~140 min
Implement CDC in Data IngestionHard
Recently asked

Design a reliable CDC ingestion process covering capture, ordering, schema evolution, replay, deduplication, monitoring, and backfills.

data integrationdata pipelineETLDeloitte
More Pipelines questions with a free account
5
Behavioral & Leadership3 questions · ~32 min
More Behavioral & Leadership questions with a free account
6
More topics1 question · ~11 min
Handle Major Architecture ChangeHard
Recently asked

Evaluates how you manage scope, risk, and execution when data platform architecture must change.

Stakeholder ManagementDealing With AmbiguityPrioritizationDeloitte
The finish line: interview-readyComplete all 50 questions to finish this plan.