Deloitte
Multinational professional services network with offices in over 150 countries.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Coding
•
medium
Write a SQL query to find the top 3 highest-paid employees in each department. If there is a tie, they should have the same rank.
#Window Functions
#DENSE_RANK
#Joins
Data Engineer
•
Coding
•
medium
Write a SQL query to calculate the cumulative sum of revenue per month for the year 2023.
#Window Functions
#Aggregations
Data Engineer
•
Coding
•
medium
You have a table with millions of rows and no primary key. Write a SQL query to delete all duplicate rows, keeping only one instance of each.
#Data Cleansing
#CTEs
#ROW_NUMBER
Data Engineer
•
Coding
•
hard
Write a recursive CTE in SQL to output a company's organizational chart, showing each employee's name, their manager's name, and their depth level in the hierarchy.
#Recursive CTE
#Hierarchical Data
Data Engineer
•
Technical
•
medium
A client complains that a specific reporting query is taking 30 minutes to run. Walk me through your step-by-step approach to optimize this SQL query.
#Performance Tuning
#Query Optimization
Data Engineer
•
Technical
•
easy
Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in SQL. Provide a brief example of when to use each.
#Window Functions
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.