Upload Button Icon Add office photos

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 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
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • 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 .

Interview Preparation Tips

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

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. What is Data
  • Ans. 

    Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.

    • Data can be structured or unstructured

    • Data can be qualitative or quantitative

    • Examples of data include customer demographics, sales figures, and website traffic

    • Data can be analyzed using various tools and techniques to extract meaningful insights

  • Answered by AI
  • Q2. Data types

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About SAP BODS

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong and concentrate on basics.

I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why do you make the Candidate for months to process the interview

Interview Preparation Tips

Interview preparation tips for other job seekers - The first round was went well. Got a positive feedback on the same day. But they ask for almost all the documents you have. and don't schedule the client round and will get calls weekly or 2 weeks once about the next round but won't get any action.

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

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.

Interview Questionnaire 

3 Questions

  • Q1. About my self and my experience.
  • Q2. What's the reason for leaving previous job?
  • Q3. Technical question depends on process.

I was interviewed before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prior experience,questions related to data analysis tools.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process is fast,mine got done in a day but if you are selected and your salary negotiation is finished, it will take almost a month to get offer letter,so need not worry till that time you will surely get it.
The reason behind the offer letter delay is they have to get approvals from multiple teams which creates a delay on the process.

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.

KPMG India Senior Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
KPMG India Senior Data Analyst Salary
based on 19 salaries
₹5 L/yr - ₹17.5 L/yr
11% 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.8/5

Rating in categories

3.8

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.8

Company culture

3.8

Promotions

3.8

Work satisfaction

Explore 2 Reviews and Ratings
Consultant
7.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
6.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
4.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
3.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
2.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare KPMG India with

Cognizant

3.7
Compare

PwC

3.4
Compare

Capgemini

3.7
Compare

Google

4.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview