Interview questions
Preparing for a data engineering interview at KPMG? This page contains 21 real interview questions sourced from verified KPMG interview experiences. Questions are sorted by frequency — the ones asked most often appear first.
KPMG data engineering interviews typically focus on Spark/Big Data, General/Other, and SQL. The interview bar skews toward harder problems (10 hard vs. 7 easy), suggesting emphasis on depth and system-level thinking.
Use the difficulty filters above to focus your preparation. For each question, attempt your own answer first, then compare with our expert solution. You can also practice these questions in our AI Mock Interview Coach for real-time feedback.
Demonstrate the difference between DENSE_RANK() and RANK()
Explain the differences between Data Warehouse, Data Lake, and Delta Lake
Joins and window functions - INNER, LEFT, RIGHT, FULL OUTER, ROW_NUMBER(), RANK(), DENSE_RANK()
Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.