Upload Button Icon Add office photos

Filter interviews by

Clear (1)

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 Company Website and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. I was asked by all WFM related question
  • Q2. I have answered all the question

Interview Preparation Tips

Interview preparation tips for other job seekers - I did my interview well, interviewer said me we will get back to u with an update...

None has reached back and no response even when I call them..


This is making very very frustrating and wasting our time.


People who does night shift will be very affected without sleep....

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.

Interview Questionnaire 

3 Questions

  • Q1. How to manage data
  • Ans. 

    Data management involves organizing, storing, protecting, and maintaining data to ensure its accuracy and accessibility.

    • Identify the type of data and its source

    • Establish a data governance framework

    • Implement data security measures

    • Use data management tools and software

    • Regularly backup and archive data

    • Ensure compliance with data regulations

    • Monitor data quality and integrity

    • Provide access to authorized users only

  • Answered by AI
  • Q2. What is data analytics
  • Ans. 

    Data analytics is the process of examining data sets to draw conclusions about the information they contain.

    • It involves collecting, cleaning, and transforming data

    • Applying statistical and mathematical models to analyze the data

    • Visualizing and presenting the results in a meaningful way

    • Examples include predicting customer behavior, identifying trends, and optimizing business processes

  • Answered by AI
  • Q3. Why we use analytics
  • Ans. 

    Analytics helps us make data-driven decisions and improve business outcomes.

    • Analytics provides insights into customer behavior and preferences.

    • It helps identify trends and patterns in data that can be used to optimize business processes.

    • Analytics can also be used to measure the effectiveness of marketing campaigns and other initiatives.

    • It enables businesses to make data-driven decisions that lead to improved outcomes a...

  • Answered by AI

Skills evaluated in this interview

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.

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How to do questions in google company interview

Interview Preparation Tips

Interview preparation tips for other job seekers - What type of questions are asked in interview

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - be what you are. be technically strong.

I applied via Referral and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1.  All types of Join from SQL ?
  • Ans. 

    SQL has four types of joins: Inner Join, Left Join, Right Join, and Full Outer Join.

    • Inner Join returns only the matching rows from both tables.

    • Left Join returns all the rows from the left table and matching rows from the right table.

    • Right Join returns all the rows from the right table and matching rows from the left table.

    • Full Outer Join returns all the rows from both tables, with NULL values in the columns where there...

  • Answered by AI
  • Q2. What is Index in SQL ?
  • Ans. 

    Index in SQL is a database object that improves the speed of data retrieval operations.

    • Index is created on one or more columns of a table.

    • It stores a copy of the data in the indexed columns in a separate structure.

    • This allows for faster search and retrieval of data.

    • Examples of index types include clustered, non-clustered, and unique indexes.

  • Answered by AI
  • Q3. Difference b/w char and varchar ?
  • Ans. 

    Char is fixed length while varchar is variable length.

    • Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.

    • Char is faster for fixed length data, while varchar is more flexible for variable length data.

    • Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.

    • Example: char is commonly used for stori...

  • Answered by AI
  • Q4. What is substring ?
  • Ans. 

    Substring is a part of a string that is smaller in length and extracted from the original string.

    • Substring is a sequence of characters within a string.

    • It can be extracted using string slicing or substring functions.

    • For example, 'hello world'[0:5] will return 'hello'.

  • Answered by AI
  • Q5. What is normalization ?
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a database into smaller, more manageable tables

    • Each table should have a primary key that uniquely identifies each record

    • Data is then organized into related tables to minimize redundancy

    • Normalization helps to prevent data inconsistencies and anomalies

    • There are different level...

  • Answered by AI
  • Q6. Some questions from accounting

Interview Preparation Tips

Interview preparation tips for other job seekers - After CV shortlisted, you are expected to get a call. Prepare for SQL , some Accounting terms , Communication skills

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

JOBS

Axis Max Life Insurance

No Jobs

SALARIES

Axis Max Life Insurance

No Salaries

JOBS

Axis Max Life Insurance

No Jobs

JOBS

Axis Max Life Insurance

No Jobs

JOBS

Axis Max Life Insurance

No Jobs

REVIEWS

Axis Max Life Insurance

No Reviews

JOBS

Axis Max Life Insurance

No Jobs

JOBS

Axis Max Life Insurance

No Jobs

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