Add office photos
Filter interviews by
KPMG India Data Engineer Interview Questions, Process, and Tips
Updated
5 Nov 2024
Top KPMG India Data Engineer Interview Questions and Answers
- Q1. How do you handle changing schema from source. What are the common issues faced in hadoop and how did you resolve it?
- Q2. Write Pyspark code to read csv file and show top 10 records.
- Q3. What are the optimization techniques applied in pyspark code?
12 KPMG India Data Engineer Interview Experiences
38 questions found
Sort by:
Popular
Anonymous
I applied via Approached by Company and was interviewed in Sep 2022.
5 Interview Rounds
1
Resume Shortlist Round
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
2
Coding Test Round
It was a MCQ test to intepret codes and its outcomes.
3
Technical Round (4 Questions)
- Q1. Given a dictionary, find out the greatest number for same key in Python. View Answers (1)
- Q2. Write Pyspark code to read csv file and show top 10 records. View Answers (2)
- Q3. Write pyspark code to change column name, divide one column by another column. View Answers (1)
- Q4. What are the optimization techniques applied in pyspark code? View Answers (3)
4
Behavioral Round (1 Question)
- Q1. How do you handle changing schema from source. What are the common issues faced in hadoop and how did you resolve it? View Answers (1)
5
HR Round (1 Question)
- Q1. Mostly it was salary negotiation Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident and pratice python, pyspark, sql for big data ppsitiom
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
3 Interview Rounds
1
Coding Test Round
Some multiple choice, 2 sql and 2 python questions were asked
2
Technical Round (2 Questions)
- Q1. Tell me about you project View Answers (1)
- Q2. Optimising technique that you have used View Answers (1)
3
Technical Round (2 Questions)
- Q1. Window partition question was asked Add Answer
- Q2. Project related question Add Answer
Skills evaluated in this interview
Get interview-ready with top interview questions
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Spark optimization techniques View Answers (1)
- Q2. Data warehousing questions Add Answer
2
Technical Round (2 Questions)
- Q1. Project experience View Answers (1)
- Q2. Challenges faced View Answers (1)
Skills evaluated in this interview
What people are saying about KPMG India
View All
a customer success specialist
1w
Salary discussion.
What's the average salary for webcare specialist with 6 years of experience?
Got a question about KPMG India?
Ask anonymously on communities.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jan 2024.
1 Interview Round
1
One-on-one Round (5 Questions)
- Q1. 1. What is columnar storage,parquet,delta? Why it is used View Answers (1)
- Q2. 2.list ,tuple,set in python
3.sql groupby and window function ,union Add Answer
- Q3. 3. Explain detail project architecture View Answers (1)
- Q4. 4. How to connect SQL server to databricks View Answers (1)
- Q5. Optimisation techniques used View Answers (1)
Interview Preparation Tips
Topics to prepare for KPMG India Data Engineer interview:
- Spark,
- SQL
- Python
Skills evaluated in this interview
KPMG India interview questions for designations
Interview experience
Good
Difficulty level
-
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in May 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Question related to project Add Answer
- Q2. Sql medium level question Add Answer
Dark Prince
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Pyspark question were asked Add Answer
- Q2. Sql questions were asked Add Answer
Data Engineer Jobs at KPMG India
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Approached by Company and was interviewed in May 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. SCD type 2, snowflake pipe Add Answer
Interview experience
Bad
Difficulty level
-
Duration
2-4 weeks
Result
-
I applied via Approached by Company and was interviewed in May 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Technical Round (2 Questions)
- Q1. It's question on collect list - it should be a straight question instead it was asked like comma separated and in a vague way. Add Answer
- Q2. Few questions on triggers, integration runtime Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Don't waste your time by attending this.
Few questions asked itself is wrong. Interviewer asking in her way of understanding.
Wishi Kaur is the interviewer and she is so rude and didn't know the way to ask questions and no respect over candidates.
She is thinking she knows everything.
It's a humble request to avoid these kind of interviewers.
Few questions asked itself is wrong. Interviewer asking in her way of understanding.
Wishi Kaur is the interviewer and she is so rude and didn't know the way to ask questions and no respect over candidates.
She is thinking she knows everything.
It's a humble request to avoid these kind of interviewers.
Interview experience
Excellent
Difficulty level
Moderate
Duration
-
Result
-
I applied via Approached by Company and was interviewed in Mar 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
One-on-one Round (4 Questions)
- Q1. Python Dictionary operations Add Answer
- Q2. Write function to check if number is an Armstrong Number View Answers (1)
- Q3. How to initiate Sparkcontext View Answers (1)
- Q4. RDDs vs DataFrames. Which is better and why View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Be well versed with Pyspark concepts. Do not fake answers. You can accept not knowing somethings.
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed before Aug 2023.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. What is integration run time in adf View Answers (1)
- Q2. How do you copy data from on-premise to azure cloud View Answers (1)
2
HR Round (2 Questions)
- Q1. How many members do you have in your family View Answers (1)
- Q2. Are ready to relocate View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - prepare everything
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed before May 2023.
3 Interview Rounds
1
Coding Test Round
Asked questions on Datastructure manipulation
2
Technical Round (1 Question)
- Q1. Asked questions on Python,Spark and AWS Add Answer
3
HR Round (1 Question)
- Q1. Salary negotiation Add Answer
KPMG India Interview FAQs
How many rounds are there in KPMG India Data Engineer interview?
KPMG India interview process usually has 2-3 rounds. The most common rounds in the KPMG India interview process are Technical, Resume Shortlist and Coding Test.
How to prepare for KPMG India Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at KPMG India. The most common topics and skills that interviewers at KPMG India expect are SQL, Python, Azure, Data Integration and ETL.
What are the top questions asked in KPMG India Data Engineer interview?
Some of the top questions asked at the KPMG India Data Engineer interview -
How long is the KPMG India Data Engineer interview process?
The duration of KPMG India Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
KPMG India Interviews By Designations
- KPMG India Consultant Interview Questions
- KPMG India Analyst Interview Questions
- KPMG India Associate Consultant Interview Questions
- KPMG India Assistant Manager Interview Questions
- KPMG India Associate Interview Questions
- KPMG India Senior Consultant Interview Questions
- KPMG India Audit Associate Interview Questions
- KPMG India Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Interview Process at KPMG India Data Engineer
based on 8 interviews in last 1 year
2 Interview rounds
- Technical Round 1
- Technical Round 2
View more
People are getting interviews through
based on 11 KPMG India interviews
Job Portal
Recruitment Consultant
45%
9%
46% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
58%
more
than the average Data Engineer Salary in India
View more details
KPMG India Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Consultant
7.5k
salaries
|  ₹6.8 L/yr - ₹27 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹10.5 L/yr - ₹32 L/yr |
|
Associate Consultant
4.5k
salaries
| ₹4.4 L/yr - ₹15.5 L/yr |
|
Analyst
3.4k
salaries
| ₹1 L/yr - ₹10 L/yr |
|
Manager
2.8k
salaries
| ₹12 L/yr - ₹48 L/yr |
Explore more salaries
Compare KPMG India with
Cognizant
Compare
PwC
Compare
Capgemini
Compare
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Data Engineer Interview Questions
Share an Interview