Deloitte Data Engineer candidates often describe two technical rounds plus a managerial or HR conversation. The rounds mix SQL, Python or PySpark, cloud pipeline scenarios and project deep-dives.
$108K
Avg. Base Comp
$137K
Avg. Total Comp
2-3 rounds
Typical Rounds
Not reported
Process Length
The Deloitte Data Engineer interview comes across as practical and tied to a specific stack rather than algorithm-heavy. Several candidates describe three rounds, typically two technical interviews followed by a managerial, behavioral or HR conversation. Others mention only their technical rounds or simply describe multiple rounds.
SQL turns up in many accounts. The second-highest salary problem is mentioned more than once, along with window functions, rank versus dense_rank, duplicate detection, CASE WHEN logic, joins, MERGE and slowly changing dimension Type 2. Python questions include removing duplicates from a list of dictionaries, reversing a string and merging lists.
The heavier technical discussion often moves to PySpark and cloud pipelines. Candidates mention Spark optimization, diagnosing a slow Spark job, the small-file problem, joining large tables, incremental loads and dimensional modeling. The cloud stack differs by team: candidates report Azure and AWS, GCP with Airflow, or Databricks and Delta tables.
Project depth is the common thread. Interviewers walk through resume projects and ask why you made each design choice, so rehearse a start-to-finish pipeline walkthrough covering sources, transformations, testing, monitoring and failure handling. The last stage is usually managerial or behavioral, covering motivation, background and fit. One candidate also describes irregular updates and having to follow up for status.
Synthesized from 19 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Deloitte process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Deloitte
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Merge Sorted Lists | |
| Maximum Profit | |
| Size of Joins | |
| Real-Time Transaction Streaming | |
| Normalize Grades | |
| Cyclic Detection | |
| Skyscanner Partner ETL | |
| Missing Housing Data | |
| Find Duplicate Numbers in a List | |
| Hurdles In Data Projects | |
| Portfolio Platform Architecture | |
| Duplicate Rows | |
| Using R Squared | |
| Classification and Regression | |
| Slow SQL Query | |
| Swap Variables | |
| Data Pipelines and Aggregation | |
| User Event Data Pipeline | |
| Bias vs. Variance Tradeoff | |
| Data Preparation for Imbalanced Data | |
| Assumptions of Linear Regression | |
| Seller Type Modeling | |
| String Palindromes | |
| Open Source Reporting Pipeline | |
| Digital Classroom System Design | |
| Impossibly Iterative Fibonacci | |
| Blob Indexing | |
| Yelp-like System | |
| Text Editor With OOP |
Synthesized from candidate reports. Individual experiences may vary.
Several candidates describe easy-to-medium Python and SQL, such as CASE WHEN logic, removing duplicates from a list of dictionaries, second-highest salary and window functions. Some also mention PySpark and scenario-based ETL questions. Interviewers seem to care most about how clearly you explain your approach.
A deeper round on past projects, architecture, ETL tools and testing is common. Depending on the team, it can also cover Spark performance tuning, Azure, AWS or GCP services, Airflow, dimensional modeling and incremental loads. Be ready to defend your design decisions and say what you would change.
The final stage is described as a behavioral conversation with senior managers, a managerial round on background and projects, or an HR round. Reported topics include motivation, previous experience and general fit. Bring concrete examples and clear reasons for wanting the role.
