Dataford
Top 25
Prep plan
Updated weekly · Last refresh Sep 9

KPMG Business Analyst Interview Questions

The questions to prepare for a KPMG Business Analyst interview. Questions from real interview reports rank first. Updated daily.

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Data Analysis and Core ConceptsMedium

Evaluates analytical thinking and foundational technical knowledge.

Data Analysistechnical skillsKPMG
Python Frameworks and SQLMedium

Evaluates practical integration of Python and SQL for data work.

sqlpythonKPMG
Lookups in Data QueriesMedium

Tests understanding of lookup concepts in data querying and transformation.

KPMG
Truncate vs DeleteMedium
Practice
Practice drill

Explain how TRUNCATE and DELETE differ in row removal, transaction behavior, and identity handling.

database managementData Manipulationdata managementGEPGoogleCelebal Technologies
Top Longest-Running Assays by DepartmentMedium
Practice
Practice drill

Find the three longest assay-duration ranks within each department, including ties, using PostgreSQL dense ranking.

Data ManipulationData AnalysissqlSt. Jude Children's Research Hospital
SQL and Python Data WorkMedium
Practice
Practice drill

Use a CTE, join, and conditional aggregation to summarize valid monthly user activity.

JoinsData ManipulationsqlAdobe
More SQL & Data Manipulation questions with a free account
2
Execution3 questions · ~24 min
User Experience Redesign Project PlanHard

Tests execution planning, scope management, and delivery under time pressure.

user experienceProject ManagementKPMG
Extracting From Legacy SystemsMedium
Recently asked

Tests execution planning for messy data sources and stakeholder-ready delivery.

legacy systemsdata extractionKPMG
Ensuring Migration Data IntegrityMedium
Recently asked

Tests controls, validation, and risk management during data migrations.

data migrationdata integrityKPMG
3
Behavioral & Leadership14 questions · ~112 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Where You See YourselfEasy

Tests your career planning and whether your trajectory aligns with the AE path.

Go-to-MarketGrowth StrategyProduct VisionKPMG
Process Implementation SuccessMedium
Recently asked

Tests metrics design and practical evaluation of consulting outcomes.

KPMG

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.