Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by KPMG India Team. If you also belong to the team, you can get access from here

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 Walk-in and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Cut Cake in 3 cut to maximum pieces
  • Q2. Basic SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident even you don’t have experience in the relevant skill set.

You can be absorbed to much related profile of your interests.

They only check how better you represent yourself and your problem solving approach.

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.

What people are saying about KPMG India

View All
toomuchcaffeine
Verified Icon
22h
works at
Infosys
KPMG Interview is scheduled for Cloud Ops engineer.
KPMG Interview is scheduled for Cloud Ops engineer. Kindly please help me with below: 1. What's the Package for that if have almost 6 years of Experience. (L1 Interview is Scheduled) 2. If anyone have set of questions for Cloud Ops Engineer profile. 3. Interview Experience. Thank you!
Got a question about KPMG India?
Ask anonymously on communities.

Interview Questionnaire 

1 Question

  • Q1. SQL, Power Bi, Python, Azure

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the Job Description properly. Clear you basics and prepare according to the JD
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

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
Are these interview questions helpful?
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

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

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - 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
Round 2 - Technical 

(2 Questions)

  • Q1. A little about Alteryx.
  • Ans. SQL queries writing -join , like, limit, group by . Alteryx: basic join , transpose, Alteryx scheduler.
  • Answered Anonymously
  • Q2. Sql related queries.
  • Ans. Sql queries writing join like group by
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and learn basics of excel, SQL Alteryx or powerBI.

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.3
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
ZS Interview Questions
3.3
 • 476 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 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.8k salaries
unlock blur

₹11.3 L/yr - ₹20 L/yr

Assistant Manager
7.9k salaries
unlock blur

₹16 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 - ₹41 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