KPMG
Multinational professional services network, and one of the Big Four accounting organizations.
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 calculate the 7-day rolling average of daily transactions for a client's retail dataset.
#Window Functions
#Time Series
#Aggregation
Data Scientist
•
Coding
•
medium
Write a SQL query using window functions to find the top 3 highest-paid employees in each department.
#Window Functions
#Ranking
#CTEs
Data Scientist
•
Coding
•
hard
Write a SQL query to find all clients who have made a purchase in every single month of the year 2023.
#Aggregation
#Filtering
#Date Functions
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the cumulative sum of revenue per client, ordered by the transaction date.
#Window Functions
#Cumulative Sum
Data Scientist
•
Technical
•
easy
In SQL, explain the difference between a LEFT JOIN and an INNER JOIN, and provide a scenario where you would strictly use a LEFT JOIN.
#Joins
#Relational Databases
#Data Manipulation
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.