AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Deloitte
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Deloitte Azure Data Engineer Interview Questions and Answers
Deloitte Azure Data Engineer Interview Experiences
6 interviews found
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.
SREYA KANDUKURU
Coding round will consists of SQL and pyspark questions, it's a medium level
Anonymous
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
What people are saying about Deloitte
I appeared for an interview in Apr 2023.
(3 Questions)
- Q1. ADF scenario based questions.
- Q2. PySpark coding question to calculate rolling sum
- Q3. SQL query and difference between rank,dense rank and row number
- Ans.
Rank, dense rank, and row number are SQL functions used to assign a unique sequential number to rows in a result set.
Rank function assigns a unique number to each row based on the ordering specified in the query.
Dense rank function also assigns a unique number to each row, but it does not leave gaps in the ranking sequence.
Row number function simply assigns a sequential number to each row in the result set, without any
(1 Question)
- Q1. Complex SQL query
Skills evaluated in this interview
Deloitte interview questions for designations
I applied via Approached by Company and was interviewed in Jun 2022. There were 2 interview rounds.
It was a 1 hour technical assessment which includes azure questions
(2 Questions)
- Q1. Explain about copy activity in ADF Slowly changing dimensions Data warehousing
- Ans.
Copy activity in ADF is used to move data from source to destination.
Copy activity supports various sources and destinations such as Azure Blob Storage, Azure SQL Database, etc.
It can be used for both one-time and scheduled data movement.
It supports mapping data between source and destination using mapping data flows.
Slowly changing dimensions can be handled using copy activity in ADF.
Copy activity is commonly used in
- Q2. Azure Databricks cluster types Pipeline triggers types
Interview Preparation Tips
- Azure Data Factory
- Databricks
I went to attend the interview with multiple offers and never interested to get selected but learnt much after that interview
Skills evaluated in this interview
(2 Questions)
- Q1. Difference between olap and oltp
- Ans.
OLAP is for analytics and reporting while OLTP is for transaction processing.
OLAP stands for Online Analytical Processing
OLTP stands for Online Transaction Processing
OLAP is used for complex queries and data analysis
OLTP is used for real-time transaction processing
OLAP databases are read-intensive while OLTP databases are write-intensive
Examples of OLAP databases include data warehouses and data marts
Examples of OLTP d...
- Q2. Difference between dataframe and rdd
- Ans.
Dataframe is a distributed collection of data organized into named columns while RDD is a distributed collection of data organized into partitions.
Dataframe is immutable while RDD is mutable
Dataframe has a schema while RDD does not
Dataframe is optimized for structured and semi-structured data while RDD is optimized for unstructured data
Dataframe has better performance than RDD due to its optimized execution engine
Dataf
Interview Preparation Tips
Skills evaluated in this interview
Azure Data Engineer Jobs at Deloitte
Interview questions from similar companies
Darshan Gade
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 interview rounds.
(1 Question)
- Q1. Starting from OOPS, then .NET Core, Then Angular and MS-SQL. For the .NET Developer
(1 Question)
- Q1. Second round will be little bit deeper with core concepts.
Interview Preparation Tips
I applied via Campus Placement
Easy njsfds asjdfjsda iasdfjk kffojal;ks
(2 Questions)
- Q1. About projects and internship
- Q2. About my experience leading a team
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 2 interview rounds.
Cofing round on hackerearth
Case study with algo and db design
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Reverse a LL, Git use cases
Interview Preparation Tips
Deloitte Interview FAQs
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Data Analyst 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
Deloitte Azure Data Engineer Interview Process
based on 4 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Deloitte Azure Data Engineer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Consultant
34.1k
salaries
|  ₹6.4 L/yr - ₹23.5 L/yr |
|
Senior Consultant
21.7k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14.7k
salaries
| ₹3.9 L/yr - ₹12.8 L/yr |
|
Assistant Manager
10.2k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
|
Manager
7.2k
salaries
| ₹16 L/yr - ₹53 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Azure Data Engineer Interview Questions
