AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
KPMG India Azure Data Engineer Interview Questions, Process, and Tips for Experienced
KPMG India Azure Data Engineer Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Naukri.com and was interviewed before Jun 2020. There were 4 interview rounds.
Interview Questionnaire
5 Questions
- Q1. What are key components in ADF? What all you have used in your pipeline?
- Ans.
ADF key components include pipelines, activities, datasets, triggers, and linked services.
Pipelines - logical grouping of activities
Activities - individual tasks within a pipeline
Datasets - data sources and destinations
Triggers - event-based or time-based execution of pipelines
Linked Services - connections to external data sources
Examples: Copy Data activity, Lookup activity, Blob Storage dataset
- Q2. Do you create any encryprion key in Databricks? Cluster size in Databricks.
- Ans.
Yes, encryption keys can be created in Databricks. Cluster size can be adjusted based on workload.
Encryption keys can be created using Azure Key Vault or Databricks secrets
Cluster size can be adjusted manually or using autoscaling based on workload
Encryption at rest can also be enabled for data stored in Databricks
- Q3. Difference between ADLS gen 1 and gen 2?
- Ans.
ADLS gen 2 is an upgrade to gen 1 with improved performance, scalability, and security features.
ADLS gen 2 is built on top of Azure Blob Storage, while gen 1 is a standalone service.
ADLS gen 2 supports hierarchical namespace, which allows for better organization and management of data.
ADLS gen 2 has better performance for large-scale analytics workloads, with faster read and write speeds.
ADLS gen 2 has improved securit...
- Q4. What is Semantic layer?
- Ans.
Semantic layer is a virtual layer that provides a simplified view of complex data.
It acts as a bridge between the physical data and the end-user.
It provides a common business language for users to access data.
It simplifies data access by hiding the complexity of the underlying data sources.
Examples include OLAP cubes, data marts, and virtual tables.
- Q5. Difference between RDD, Dataframe and Dataset. How and what you have used in you databricks for data anlysis
- Ans.
RDD, Dataframe and Dataset are data structures in Spark. RDD is a low-level structure, Dataframe is tabular and Dataset is a combination of both.
RDD stands for Resilient Distributed Datasets and is a low-level structure in Spark that is immutable and fault-tolerant.
Dataframe is a tabular structure with named columns and is similar to a table in a relational database.
Dataset is a combination of RDD and Dataframe and pro...
Interview Preparation Tips
Skills evaluated in this interview
Azure Data Engineer Jobs at KPMG India
Interview questions from similar companies
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
Maxium sub string and reverse a string
Selected
I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Past Exp and Resume
Take home coding test with 3 SQL and 3 Python questions. Asked to solve only SQL questions but I solved them all.
(1 Question)
- Q1. 3 in-person interviews with general discussions about resume and past projects
Interview Preparation Tips
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Project related discussions
- Q2. Meduim level SQl and DSA
(2 Questions)
- Q1. This was data modelling round
- 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
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview before Feb 2024.
It was section wise, MCQ, then coding questions
(2 Questions)
- Q1. Questions related to tableau
- Q2. Can you describe your project experience?
- Ans.
I have experience working on projects involving data pipeline development, ETL processes, and data analysis.
Developed data pipelines using tools like Apache Spark and Airflow
Implemented ETL processes to extract, transform, and load data from various sources
Performed data analysis to derive insights and support decision-making
Worked on optimizing data storage and retrieval for improved performance
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Present yourself
- Q2. Asks about level of experience in each tachnology in the CV
(1 Question)
- Q1. The interiew was around for 1 hr asked python, sql airflow and data warehouse quetion
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Difference between list and tuple?
- Ans.
List is mutable, tuple is immutable in Python.
List can be modified after creation, tuple cannot.
List is defined using square brackets [], tuple using parentheses ().
Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Skills evaluated in this interview
(1 Question)
- Q1. Data warehouse concepts
I appeared for an interview in Sep 2023.
(1 Question)
- Q1. When the interview get started, interviewer directly jump into python coding questions based on the dict, arrays and lists. And then asked about some question data ware houses on SCD, Data Modeling,...etc....
KPMG India Interview FAQs
Some of the top questions asked at the KPMG India Azure Data Engineer interview for experienced candidates -
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
- Azure DevOps Engineer Interview Questions
- Azure Administrator Interview Questions
- Azure Developer Interview Questions
- Azure Cloud Engineer Interview Questions
- Azure Cloud Administrator Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
KPMG India Azure Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
7.9k
salaries
|  ₹7 L/yr - ₹24 L/yr |
|
Assistant Manager
7.2k
salaries
| ₹10.5 L/yr - ₹31.5 L/yr |
|
Associate Consultant
4.8k
salaries
| ₹4.5 L/yr - ₹16 L/yr |
|
Analyst
3.6k
salaries
| ₹1 L/yr - ₹9.7 L/yr |
|
Manager
2.9k
salaries
| ₹15.5 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Azure Data Engineer Interview Questions for Experienced
