Add office photos
Filter interviews by
KPMG India Azure Data Engineer Interview Questions, Process, and Tips
Top KPMG India Azure Data Engineer Interview Questions and Answers
- Q1. Difference between RDD, Dataframe and Dataset. How and what you have used in you databricks for data anlysis
- Q2. What are key components in ADF? What all you have used in your pipeline?
- Q3. Do you create any encryprion key in Databricks? Cluster size in Databricks.
KPMG India Azure Data Engineer Interview Experiences
5 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
(3 Questions)
- Q1. What is Medallion Architecture
- Ans.
Medallion Architecture is a data processing architecture that involves breaking down data into smaller pieces for easier processing.
Medallion Architecture involves breaking down data into smaller pieces for easier processing
It allows for parallel processing of data to improve performance
Commonly used in big data processing systems like Hadoop and Spark
- Q2. What is Spark Architecture
- Ans.
Spark Architecture is a distributed computing framework that provides an efficient way to process large datasets.
Spark Architecture consists of a driver program, cluster manager, and worker nodes.
It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.
Spark supports various programming languages like Scala, Java, Python, and SQL.
It includes components like Spark Core, Spark SQL, Spa...
- Q3. Find the second highest salary in employee table
- Ans.
Use SQL query to find the second highest salary in employee table
Use SQL query with ORDER BY and LIMIT to get the second highest salary
Example: SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT 1, 1
(2 Questions)
- Q1. How do you perform Partitioning
- Ans.
Partitioning in Azure Data Engineer involves dividing data into smaller chunks for better performance and manageability.
Partitioning can be done based on a specific column or key in the dataset
It helps in distributing data across multiple nodes for parallel processing
Partitioning can improve query performance by reducing the amount of data that needs to be scanned
In Azure Synapse Analytics, you can use ROUND_ROBIN or H
- Q2. What are your current responsibilities as Azure Data Engineer
- Ans.
As an Azure Data Engineer, my current responsibilities include designing and implementing data solutions on Azure, optimizing data storage and processing, and ensuring data security and compliance.
Designing and implementing data solutions on Azure
Optimizing data storage and processing for performance and cost efficiency
Ensuring data security and compliance with regulations
Collaborating with data scientists and analysts
Skills evaluated in this interview
(2 Questions)
- Q1. Day to day activities
- Q2. Challenging problem
- Ans.
Designing a data pipeline to process and analyze large volumes of real-time data from multiple sources.
Identify the sources of data and their formats
Design a scalable data ingestion process
Implement data transformation and cleansing steps
Utilize Azure Data Factory, Azure Databricks, and Azure Synapse Analytics for processing and analysis
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
What people are saying about KPMG India
SACHIN KAUSHIK
(2 Questions)
- Q1. What steps are involved in fetching data from an on-premises Unix server?
- Q2. Types of triggers in azure data factory
KPMG India interview questions for designations
Hackveda Limited
Get interview-ready with Top KPMG India Interview Questions
Interview questions from similar companies
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Python code for prime numbers
- Q2. Data bricks pyspark code for first 10 employees with salary
sagnik sil
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. What is polybase?
- Ans.
Polybase is a feature in Azure SQL Data Warehouse that allows users to query data stored in Hadoop or Azure Blob Storage.
Polybase enables users to access and query external data sources without moving the data into the database.
It provides a virtualization layer that allows SQL queries to seamlessly integrate with data stored in Hadoop or Azure Blob Storage.
Polybase can significantly improve query performance by levera...
- Q2. Explain your current project architecture.
(3 Questions)
- Q1. Previous project
- Q2. What is partion key?
- Ans.
Partition key is a field used to distribute data across multiple partitions in a database for scalability and performance.
Partition key determines the partition in which a row will be stored in a database.
It helps in distributing data evenly across multiple partitions to improve query performance.
Choosing the right partition key is crucial for efficient data storage and retrieval.
For example, in Azure Cosmos DB, partit...
- Q3. Explai data bricks,how its different from adf
- Ans.
Data bricks is a unified analytics platform for big data and machine learning, while ADF (Azure Data Factory) is a cloud-based data integration service.
Data bricks is a unified analytics platform that provides a collaborative environment for big data and machine learning projects.
ADF is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
Data bricks supports multiple pr...
Interview Preparation Tips
- Adf
- data bricks
- SQL
- pyspark
- basic quereis on sql,pyspark
Skills evaluated in this interview
I applied via Job Portal and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. What are the difference b/w data lake gen1 and gen2
- Ans.
Data Lake Gen1 is based on Hadoop Distributed File System (HDFS) while Gen2 is built on Azure Blob Storage.
Data Lake Gen1 uses HDFS for storing data while Gen2 uses Azure Blob Storage.
Gen1 has a hierarchical file system while Gen2 has a flat file system.
Gen2 provides better performance, scalability, and security compared to Gen1.
Gen2 supports Azure Data Lake Storage features like tiering, lifecycle management, and acce...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Feb 2023. There were 4 interview rounds.
(5 Questions)
- Q1. How do we do delta load using adf?
- Ans.
Delta load in ADF is achieved by comparing source and target data and only loading the changed data.
Use a Lookup activity to retrieve the latest watermark or timestamp from the target table
Use a Source activity to extract data from the source system based on the watermark or timestamp
Use a Join activity to compare the source and target data and identify the changed records
Use a Sink activity to load only the changed re
- Q2. Sql:- fourth highest salry of an employee from an employee table.
- Q3. What is the difference between Blob and adls
- Ans.
Blob is a storage service for unstructured data, while ADLS is optimized for big data analytics workloads.
Blob is a general-purpose object storage service for unstructured data, while ADLS is optimized for big data analytics workloads.
ADLS offers features like file system semantics, file-level security, and scalability for big data analytics, while Blob storage is simpler and more cost-effective for general storage nee...
- Q4. What are the types of triggers available in adf?
- Ans.
There are three types of triggers available in Azure Data Factory: Schedule, Tumbling Window, and Event.
Schedule trigger: Runs pipelines on a specified schedule.
Tumbling Window trigger: Runs pipelines at specified time intervals.
Event trigger: Runs pipelines in response to events like a file being added to a storage account.
- Q5. What is your team size?
(4 Questions)
- Q1. Why do you want to change the company?
- Q2. What you will do if you got an offer from Deloitte?
- Q3. What are your roles and responsibilities?
- Q4. What is expected salary?
(2 Questions)
- Q1. What is your expected salary?
- Q2. Is there any other salary figure in your mind?
Skills evaluated in this interview
KPMG India Interview FAQs
Some of the top questions asked at the KPMG India Azure Data Engineer interview -
Tell us how to improve this page.
KPMG India Interviews By Designations
- KPMG India Analyst Interview Questions
- KPMG India Consultant 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
KPMG India Azure Data Engineer Interview Process
based on 3 interviews in last 1 year
Interview experience
People are getting interviews through
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.5k
salaries
|  ₹6.9 L/yr - ₹26.2 L/yr |
|
Assistant Manager
6.9k
salaries
| ₹10.6 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 - ₹8 L/yr |
|
Manager
2.8k
salaries
| ₹12 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini
Calculate your in-hand salary
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Azure Data Engineer Interview Questions
