KPMG

KPMG

Multinational professional services network, and one of the Big Four accounting organizations.

4 Rounds ~21 Days Medium
Start Mock Interview

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 find the top 3 highest-paid employees in each department.

#SQL #Window Functions
Practice
Backend Engineer • Technical • easy

What is the difference between an Inner Join and a Left Join? How do they impact performance on large financial datasets?

#SQL #Database Optimization #Joins
Practice
Backend Engineer • Technical • medium

What are the common ways to optimize a slow-running SQL query in SQL Server or PostgreSQL?

#Query Optimization #Indexing #Execution Plans
Practice
Data Engineer • Coding • medium

Write a SQL query to find the top 3 highest-paid employees in each department, handling ties appropriately.

#Window Functions #DENSE_RANK #Aggregations
Practice
Data Engineer • Coding • medium

Write a SQL query to identify gaps in sequential invoice numbers for an audit client.

#Audit Data #Sequential Gaps #LEAD/LAG
Practice
Data Engineer • Coding • medium

Calculate a rolling 7-day average of daily transactions for a financial client using SQL.

#Window Functions #Time Series #Financial Data
Practice
Data Engineer • Coding • hard

Write a SQL query to identify overlapping date ranges in a client's software subscription dataset.

#Self Joins #Date Functions #Complex Logic
Practice
Data Engineer • Technical • easy

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER(). Give a specific use case for each in an audit context.

#Window Functions #Data Ranking
Practice
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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
Full Stack Engineer • Coding • hard

Write a SQL query to calculate the rolling 7-day average of daily deposits for each client account.

#Window Functions #Time Series #Aggregations
Practice
Full Stack Engineer • Coding • medium

Write a SQL query to find the second highest transaction amount for each regional department in the 'transactions' table.

#Window Functions #Subqueries #Grouping
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query using window functions to calculate the cumulative sum of revenue per department, ordered by transaction date.

#Window Functions #Cumulative Sum #Data Aggregation
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to identify the top 3 highest-value suspicious transactions for each corporate client over the past 30 days.

#Window Functions #Aggregations #Time-series
Practice
Product Manager • Coding • hard

Write a SQL query to calculate the month-over-month retention rate of users on a new compliance platform.

#Retention #Advanced SQL #Window Functions
Practice
Product Manager • Coding • easy

Write a SQL query to find the top 5 clients by revenue in the last quarter, given 'transactions' and 'clients' tables.

#Data Analysis #SQL #Joins
Practice
Software Engineer • Coding • easy

Write a SQL query to find all employees who earn more than their direct managers.

#Database #Joins
Practice
Software Engineer • Coding • medium

Write a SQL query to find the nth highest salary from an Employee table. If there is no nth highest salary, return null.

#Database #Queries #Window Functions
Practice
Software Engineer • Coding • hard

Write a SQL query to find the top 3 departments with the highest average salary, including the average salary amount.

#CTEs #Window Functions #Aggregation
Practice
Software Engineer • Coding • medium

Write a SQL query to calculate the cumulative sum of revenue per month for the year 2023.

#Window Functions #Analytics #Aggregation
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now