Upload Button Icon Add office photos

KPMG India

Compare button icon Compare button icon Compare

Filter interviews by

KPMG India Senior Data Analyst Interview Questions and Answers

Updated 13 Jan 2025

KPMG India Senior Data Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Big data , Optimization , Python basic , SQL intermediate
  • Q2. Find max and min number without sorting Joins related Big data handling Optimization question
Round 2 - Technical 

(2 Questions)

  • Q1. Schema , python , sql
  • Q2. Case study sql and python based
Round 3 - Case Study 

Sales data from a leading manufacturer

Interview questions from similar companies

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:
  • Procurement
  • Marketing
  • Career goal
Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good

Senior Data Analyst Interview Questions Asked at Other Companies

Q1. What is the difference between the Least Squares Method and Maxim ... read more
asked in Proftware
Q2. Imagine you are presented with a complex dataset from a multinati ... read more
Q3. How do you improve the performance of Linear Regression?
asked in Chubb
Q4. Given a table 'matches' with columns 'team1', 'team2', and 'winne ... read more
asked in NielsenIQ
Q5. Have you used Power BI ? and various types of visualization in Po ... read more

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .
  • Ans. 

    Query to generate state-wise sales summary report with ranking using multiple table joins.

    • Use SQL JOINs to combine sales, states, and products tables.

    • Aggregate sales data using SUM() function grouped by state.

    • Use RANK() or DENSE_RANK() to rank states based on total sales.

    • Example SQL: SELECT state, SUM(sales) AS total_sales, RANK() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM sales_data JOIN states ON sales_data.s...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

I applied via Company Website and was interviewed in Dec 2021. There were 11 interview rounds.

Round 1 - Aptitude Test 

A test designed to a determination a person ability in particular skill of field knowledge

Round 2 - Coding Test 

Coding and decoding

Round 3 - Case Study 

Devolpment of a particular person group or situation over a period of time

Round 4 - Technical 

(1 Question)

  • Q1. Relating to a particular Subject art or carft or its techNical Terms
Round 5 - Group Discussion 

Is a situation faced when individuals collectively make a choice from alternative before them

Round 6 - Assignment 

A task or piEce of work allocated to someone a part of a job or course of study a home work assignment

Round 7 - Technical 

(1 Question)

  • Q1. InvolVoing or concerned with applied and industrial science
Round 8 - Coding Test 

Coding interview test candidate technical knowledge coding ability creativity typically on a white board

Round 9 - HR 

(1 Question)

  • Q1. Managing an organisation employees
Round 10 - One-on-one 

(1 Question)

  • Q1. Each player from one team is matched a single player from other team
Round 11 - Coding Test 

The from are checked and returned to the census officer for coding

Interview Preparation Tips

Interview preparation tips for other job seekers - Straight From the job Seekers themselves

What people are saying about KPMG India

View All
trendylion
Verified Icon
2w
student at
Chandigarh University
Data Science dream job: Need resume advice & referrals!
Hey pros, what should I add to my resume to boost my chances of landing my first Data Science role? Guidance needed! Also, if you're hiring or know openings at: TCS | Infosys | Wipro | Cognizant | Genpact | Accenture | LTIMindtree | Fractal Analytics | Mu Sigma | Quantiphi | Tiger Analytics | EXL | ZS Associates | Deloitte | KPMG | EY | Capgemini | Publicis Sapient, a referral would be amazing! 📎 I’m attaching my resume. Feedback, suggestions, or leads would mean a lot! Thanks for your support! Let’s connect & grow in #DataScience. #DataScience #MachineLearning #DeepLearning #OpenToWork #FresherJobs #DataScienceJobs #Referral #CareerAdvice #ResumeTips #JobSearch #Hiring #AmbitionBox #LinkedInJobs
FeedCard Image
Got a question about KPMG India?
Ask anonymously on communities.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • Q3. How to add date table in power bi
  • Ans. 

    To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.

    • Create a new table in Power BI with a list of dates

    • Add columns for day, month, year, etc. for additional analysis

    • Establish relationships between the date table and other tables in the data model

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Round 2 - Coding Test 

Excel, Numpy, Pandas, basic ML

Round 3 - Case Study 

Case study talking about how to optimise the supply chain using data analytics

I applied via Campus Placement and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on SQL, C++

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL, Python and ETL well along with great communication skills.
Are these interview questions helpful?

I appeared for an interview before Jan 2021.

Round 1 - Coding Test 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

This was an online aptitude round on the Talview platform which we can give from our Home. To attempt this test, we have been given a window of 12-24 hours. It was a proctored online test. The round consisted of 60 aptitude questions in 60 minutes of time without any negative marking. The aptitude test consisted of various questions of Logical Reasoning, Mental Ability, Data Interpretation Questions, Numerical Reasoning.

  • Q1. 

    Matrix Transpose Problem Statement

    Given a matrix MAT, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specificall...

  • Ans. 

    Transpose a given matrix by switching rows and columns.

    • Iterate through the matrix and swap elements at [i][j] with [j][i].

    • Create a new matrix to store the transposed values.

    • Ensure the dimensions of the transposed matrix are reversed from the original matrix.

  • Answered by AI
Round 2 - Video Call 

Round duration - 30 minutes
Round difficulty - Medium

This was a video interview round taken immediately after the Aptitude test, it was a proctored round on Talview platform. This round consisted of 8 questions, we have to answer each question in the span of 3 mins and 10 secs were given for reading the question, our audio and video was being recorded while answering those questions. Our soft skills were being judged in this round. The questions basically consisted of HR questions and Guesstimates

Round 3 - Video Call 

Round duration - 120 minutes
Round difficulty - Hard

This round was the case study round, in this round, we were provided a case study which we had to solve in 1 hour using pen and paper and had to share the answers of the case study questions in a PDF format to the HR, the questions were related to market share, advertisement strategies, and can be easily solved using basic mathematics. After this, there was be a one-to-one interview on Zoom Platform in which the interviewer will ask you to describe your approach for every question you have solved in the case study, they will not ask for the exact answer, all they ask is about your approach that you have used to solve a particular problem and the way you explain it. They may or may not ask some guesstimates or puzzles as well in this round. The interviewer was very friendly and he gave me hints as well if I was stuck somewhere.

Round 4 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Hard

The next round was the Behavioral interview round, in this round, the interviewer asked me about my projects and some guesstimates or puzzles. This round was for 1 hour. The interviewer was very friendly and helpful, she helped me if I was stuck somewhere, she kept me calm during the interview process.

  • Q1. How many people do you estimate watched Ramayana/Mahabharat during the first month of the Covid lockdown in 2020?
Round 5 - Video Call 

(1 Question)

Round duration - 40 minutes
Round difficulty - Hard

The fit round was my final interview round, in this, you will meet the manager/Principal from the company. They will basically check whether you are fit for the organization. They ask about the projects I have done in college/internships. Some basic questions like what are your strengths and weaknesses, why do you want to join the company and some guesstimates or puzzles as well.
On-campus, the behavioral and fit interview rounds were combined into one.
This round was of 40 minutes and the interview was taken on Zoom, the interviewer was helpful and sweet.

  • Q1. How many pizzas are sold in one day in Pune?
  • Ans. 

    The number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.

    • The number of pizzas sold in Pune can range from hundreds to thousands in a day.

    • Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.

    • Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.

    • Data f...

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in GurgaonEligibility criteriaAbove 6.5 CGPA in B. TechZS Associates interview preparation:Topics to prepare for the interview - Aptitude, Guesstimates, Puzzles, HR questions, Resume Related QuestionsTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Prepare well for guesstimates and puzzles.
Tip 2 : Practice Data Interpretation Questions.
Tip 3 : Be well versed with your projects.

Application resume tips for other job seekers

Tip 1 : The resume should be very precise and concise
Tip 2 : Do not add such skills in your resume in which you're not comfortable.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Nice Topics and easy questions

Round 2 - Group Discussion 

1 hour and nice experience

Round 3 - Case Study 

How is world evolving

Interview Preparation Tips

Interview preparation tips for other job seekers - Do well
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

4 rounds of coding ml questions

KPMG India Interview FAQs

How many rounds are there in KPMG India Senior Data Analyst interview?
KPMG India interview process usually has 3 rounds. The most common rounds in the KPMG India interview process are Technical and Case Study.
What are the top questions asked in KPMG India Senior Data Analyst interview?

Some of the top questions asked at the KPMG India Senior Data Analyst interview -

  1. Find max and min number without sorting Joins related Big data handling Optimi...read more
  2. Big data , Optimization , Python basic , SQL intermedi...read more
  3. Case study sql and python ba...read more

Tell us how to improve this page.

Overall Interview Experience Rating

5/5

based on 1 interview experience

Difficulty level

Moderate 100%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

Deloitte Interview Questions
3.7
 • 3k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
ZS Interview Questions
3.3
 • 474 Interviews
BCG Interview Questions
3.7
 • 203 Interviews
Bain & Company Interview Questions
3.9
 • 111 Interviews
WSP Interview Questions
4.2
 • 99 Interviews
View all
KPMG India Senior Data Analyst Salary
based on 26 salaries
₹8.5 L/yr - ₹15.5 L/yr
8% less than the average Senior Data Analyst Salary in India
View more details

KPMG India Senior Data Analyst Reviews and Ratings

based on 2 reviews

3.9/5

Rating in categories

3.9

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.9

Company culture

3.9

Promotions

3.9

Work satisfaction

Explore 2 Reviews and Ratings
Consultant
8.7k salaries
unlock blur

₹11.2 L/yr - ₹20 L/yr

Assistant Manager
7.8k salaries
unlock blur

₹15.9 L/yr - ₹27 L/yr

Associate Consultant
5.1k salaries
unlock blur

₹7.7 L/yr - ₹13 L/yr

Analyst
3.8k salaries
unlock blur

₹2.5 L/yr - ₹8 L/yr

Manager
3.5k salaries
unlock blur

₹22 L/yr - ₹38 L/yr

Explore more salaries
Compare KPMG India with

Cognizant

3.7
Compare

PwC

3.3
Compare

Capgemini

3.7
Compare

Google

4.4
Compare
write
Share an Interview