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
Backend Engineer
•
Coding
•
medium
Write a SQL query to report the nth highest salary from the Employee table. If there is no nth highest salary, the query should report null.
#Database
#Window Functions
#Subqueries
Backend Engineer
•
Coding
•
medium
Write a SQL query to find employees who have the highest salary in each of the departments.
#Database
#Joins
#Group By
Backend Engineer
•
Coding
•
medium
Write a SQL query to find all overlapping date ranges for client project assignments in the Projects table.
#Database
#Self Join
#Date Functions
Backend Engineer
•
Coding
•
easy
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.
#Database
#DELETE
#Self Join
Backend Engineer
•
Coding
•
medium
Write a query to calculate the cumulative sum of revenue per month for a given client over the past year.
#Database
#Window Functions
#Aggregations
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.