Add office photos
Filter interviews by
KPMG India Data Engineer Interview Questions, Process, and Tips for Experienced
Updated
7 Oct 2024
Top KPMG India Data Engineer Interview Questions and Answers for Experienced
- 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?
3 KPMG India Data Engineer Interview Experiences for Experienced
12 questions found
Sort by:
Popular
Anonymous
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
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
Get interview-ready with top interview questions
I applied via Recruitment Consultant and was interviewed in Mar 2021.
4 Interview Rounds
Interview Questions
- Q1. Questions were around my old project, what was my responsibility. Technical questions were objective questions on Python and SQL. There were three technical rou...read more
Add Answer
- Q2. All technical questions were around how to process data using SQL and Python. What are triggers, functions and Store procedures and differences between them. Wh...read more
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - They needed someone with strong data structure knowledge and ability to wrote complex queries fast in my experience. Also tested me on best practices of a development project. If one wants a Data Engineer job role at any company SQL should be very strong as that is the building block of this profile. As I cracked interviews of other companies as well and their questions were also similar.
What people are saying about KPMG India
View All
a customer success specialist
3d
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.
Data Engineer Jobs at KPMG India
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Brief Explain about SCD Type II Add Answer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
4 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Basic Python, SQL & Spark coding questions. Add Answer
- Q2. Nth highest salary, word count in pyspark View Answers (1)
2
Technical Round (1 Question)
- Q1. Questions on SQL & PySpark. Add Answer
3
Behavioral Round (1 Question)
- Q1. Questions about previous projects & optimization techniques etc. Also behavioural Add Answer
4
HR Round (1 Question)
- Q1. Salary negotiation part. Add Answer
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed in Sep 2024.
2 Interview Rounds
1
Coding Test Round
Spark and SQL question can expect
2
Case Study Round
Focusing on the past project
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared on basic understanding and practice the coding questions.
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Referral and was interviewed in Aug 2023.
4 Interview Rounds
1
Technical Round (1 Question)
- Q1. Python sql pyspark situation questions, and all of the azure DE stack prepare easy python and medium level sql questions debrief about my past experience and pr...read more Add Answer
2
Coding Test Round
Hacker rank test MCQ based test mostly focused on azure and big data concepts
3
One-on-one Round (1 Question)
- Q1. Partner technical discussion, lot of SQL questions and some basic python questions relating to string and lists very indepth ask on big data concepts and azure ...read more Add Answer
4
HR Round (1 Question)
- Q1. General fitment round, but mostly got selected in the round 3 itself so was carried out like a typical HR dialogue round Add Answer
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Company Website and was interviewed in Dec 2023.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Difference between list and tuple? View Answers (1)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Referral and was interviewed before Mar 2023.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. SQl, different types of joins, puzzle, guestimates Add Answer
2
One-on-one Round (1 Question)
- Q1. Talk about your strength and weekness Add Answer
Interview Preparation Tips
Topics to prepare for ZS Data Engineer interview:
- SQL
- Python
- AWS
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Sql question of rank sumover and partion by kinda question Add Answer
- Q2. Roles n responsibility Add Answer
KPMG India Interview FAQs
How many rounds are there in KPMG India Data Engineer interview for experienced candidates?
KPMG India interview process for experienced candidates usually has 3-4 rounds. The most common rounds in the KPMG India interview process for experienced candidates are Technical, Resume Shortlist and Coding Test.
How to prepare for KPMG India Data Engineer interview for experienced candidates?
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 for experienced candidates?
Some of the top questions asked at the KPMG India Data Engineer interview for experienced candidates -
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
People are getting interviews through
based on 3 KPMG India interviews
Job Portal
Recruitment Consultant
33%
33%
34% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
39%
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.9 L/yr - ₹27 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹10.4 L/yr - ₹32 L/yr |
|
Associate Consultant
4.4k
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 - ₹46.6 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 for Experienced
Share an Interview