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 Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 highest-paid employees in each department. Assume a table 'employees' with columns 'id', 'name', 'salary', and 'department_id'.
#Window Functions
#Data Aggregation
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the rolling 7-day average of daily transaction volumes from a 'transactions' table.
#Window Functions
#Time Series
#Data Aggregation
Data Scientist
•
Coding
•
hard
Given a 'user_logins' table, write a SQL query to find the month-over-month retention rate of users.
#Cohort Analysis
#Self Joins
#Date Functions
Data Scientist
•
Technical
•
hard
How do you optimize a slow-running SQL query that joins multiple large tables (over 100 million rows each)?
#Query Optimization
#Database Performance
#Indexing
Data Scientist
•
Technical
•
easy
What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in SQL? Provide an example of when to use each.
#Window Functions
#SQL Theory
Data Scientist
•
Technical
•
medium
How would you handle duplicate records in a massive SQL database without using the DISTINCT keyword?
#Data Cleaning
#GROUP BY
#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.