KPMG India Data Engineer Interview Questions and Answers for Experienced

Round duration - 60 minutes
Round difficulty - Easy

This was an online aptitude round on the Talview platform which we can give from our Home. To attempt this test, we have been given a window of 12-24 hours. It was a proctored online test. The round consisted of 60 aptitude questions in 60 minutes of time without any negative marking. The aptitude test consisted of various questions of Logical Reasoning, Mental Ability, Data Interpretation Questions, Numerical Reasoning.

Q1. 
Matrix Transpose Problem Statement
Given a matrix MAT, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specificall...read more
Ans. 
Transpose a given matrix by switching rows and columns.
• Iterate through the matrix and swap elements at [i][j] with [j][i].

• Create a new matrix to store the transposed values.

• Ensure the dimensions of the transposed matrix are reversed from the original matrix.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

This was a video interview round taken immediately after the Aptitude test, it was a proctored round on Talview platform. This round consisted of 8 questions, we have to answer each question in the span of 3 mins and 10 secs were given for reading the question, our audio and video was being recorded while answering those questions. Our soft skills were being judged in this round. The questions basically consisted of HR questions and Guesstimates

Round duration - 120 minutes
Round difficulty - Hard

This round was the case study round, in this round, we were provided a case study which we had to solve in 1 hour using pen and paper and had to share the answers of the case study questions in a PDF format to the HR, the questions were related to market share, advertisement strategies, and can be easily solved using basic mathematics. After this, there was be a one-to-one interview on Zoom Platform in which the interviewer will ask you to describe your approach for every question you have solved in the case study, they will not ask for the exact answer, all they ask is about your approach that you have used to solve a particular problem and the way you explain it. They may or may not ask some guesstimates or puzzles as well in this round. The interviewer was very friendly and he gave me hints as well if I was stuck somewhere.

Round duration - 60 minutes
Round difficulty - Hard

The next round was the Behavioral interview round, in this round, the interviewer asked me about my projects and some guesstimates or puzzles. This round was for 1 hour. The interviewer was very friendly and helpful, she helped me if I was stuck somewhere, she kept me calm during the interview process.

Q1. How many people do you estimate watched Ramayana/Mahabharat during the first month of the Covid lockdown in 2020?
Add your answer

Round duration - 40 minutes
Round difficulty - Hard

The fit round was my final interview round, in this, you will meet the manager/Principal from the company. They will basically check whether you are fit for the organization. They ask about the projects I have done in college/internships. Some basic questions like what are your strengths and weaknesses, why do you want to join the company and some guesstimates or puzzles as well.
On-campus, the behavioral and fit interview rounds were combined into one.
This round was of 40 minutes and the interview was taken on Zoom, the interviewer was helpful and sweet.

Q1. How many pizzas are sold in one day in Pune?
Ans. 
The number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.
• The number of pizzas sold in Pune can range from hundreds to thousands in a day.

• Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.

• Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.

• Data f...read more
Answered by AI
Add your answer

Q1. Project related discussions
Add your answer
Q2. Meduim level SQl and DSA
Add your answer

Q1. This was data modelling round
Add your answer
Q2. Design a uber data model
Ans. 
Uber data model design for efficient storage and retrieval of ride-related information.
• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance
Answered by AI
Add your answer

A test designed to a determination a person ability in particular skill of field knowledge

Coding and decoding

Devolpment of a particular person group or situation over a period of time

Q1. Relating to a particular Subject art or carft or its techNical Terms
Add your answer

Is a situation faced when individuals collectively make a choice from alternative before them

A task or piEce of work allocated to someone a part of a job or course of study a home work assignment

Q1. InvolVoing or concerned with applied and industrial science
Add your answer

Coding interview test candidate technical knowledge coding ability creativity typically on a white board

Q1. Managing an organisation employees
Add your answer

Q1. Each player from one team is matched a single player from other team
Add your answer

The from are checked and returned to the census officer for coding

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Add your answer
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
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Excel, Numpy, Pandas, basic ML

Case study talking about how to optimise the supply chain using data analytics