KPMG India Database Analyst Interview Questions 2026

Tell me about yourself and why you want to be a Database Analyst at KPMG India.

Hint: Focus on your data experience, relevant projects, and genuine interest in the company's data challenges.

Write a SQL query to find the top 5 customers by revenue in the last 30 days.

Hint: Use SELECT, JOIN, WHERE with date filter, GROUP BY, ORDER BY DESC, and LIMIT 5.

How would you clean a dataset with 20% missing values in a key column?

Hint: Discuss imputation strategies (mean/median/mode), domain-specific defaults, or dropping rows based on business impact.

Describe a complex data analysis project you completed end-to-end.

Hint: Use the STAR method: Situation, Task, Action, Result. Quantify the business impact.

Explain the difference between a LEFT JOIN and INNER JOIN with an example.

Hint: INNER JOIN returns only matching rows from both tables. LEFT JOIN returns all rows from the left table and matched rows from the right.

How do you identify and handle outliers in a dataset?

Hint: Use IQR (1.5× rule), Z-score, or business context. Decide to remove, cap (winsorize), or flag outliers.

KPMG India has seen a 15% drop in a key metric this week. How do you diagnose the issue?

Hint: Structured approach: Check data quality first, then segment (device, region, channel), compare time periods, correlate with product releases or external events.

Explain the concept of data normalization and when it matters.

Hint: Normalization scales features to a common range, important for distance-based algorithms like KNN or clustering.

How would you build a BI dashboard to track KPMG India's key business metrics?

Hint: Identify KPIs with stakeholders, design the data model, build the transformation layer, create the visualization, and schedule refresh.

Where do you see data analytics heading in the next 3–5 years and how are you preparing?

Hint: Mention AI-augmented analytics, real-time analytics, data mesh, and the growing importance of data literacy across organizations.