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 Data Engineer Interview Questions, Process, and Tips
Top Deloitte Data Engineer Interview Questions and Answers
- Q1. What is difference between Cloud Run and Cloud Functions
- Q2. What is Data WareHouse..?
- Q3. What is the Underlying Architecture of bigquery
Deloitte Data Engineer Interview Experiences
21 interviews found
Anonymous
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Sql constrainsts, star schema, dml dcl commands
- Q2. About cureent project and responsibilities
(2 Questions)
- Q1. Current projects and resposibilities
- Q2. Where vs having, reason for job change
Interview Preparation Tips
2. Technical with senior manager- about project ,where vs having , reason of job change
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Round 1 was online Test where one basic coding question was there and few aptitiude , verbal ability and python based question.
(2 Questions)
- Q1. What is Data WareHouse..?
- Ans.
A Data Warehouse is a centralized repository that stores integrated data from multiple sources for analysis and reporting.
Data Warehouses are designed for query and analysis rather than transaction processing.
They often contain historical data and are used for decision-making purposes.
Data Warehouses typically use a dimensional model with facts and dimensions.
Examples of Data Warehouse tools include Amazon Redshift, Sn
- Q2. Nested Queries in Bigquery..?
- Ans.
Nested queries in BigQuery allow for querying data from within another query, enabling complex data analysis.
Nested queries are queries that are embedded within another query
They can be used to perform subqueries to filter, aggregate, or manipulate data
Nested queries can be used in SELECT, FROM, WHERE, and HAVING clauses
Interview Preparation Tips
- Python
- SQL
- Cloud
I appeared for an interview in Feb 2025.
(2 Questions)
- Q1. Python, sql window functions, inner join vs left join.
- Q2. Pyspark related qn
What people are saying about Deloitte
(2 Questions)
- Q1. Basic Python, SQL & Spark coding questions.
- Q2. Nth highest salary, word count in pyspark
- Ans.
To find the nth highest salary in pyspark, use the window function with row_number and filter on the desired rank.
Use window function with row_number to assign a rank to each salary
Filter the result to get the row with the desired rank
Example: df.withColumn('rank', F.row_number().over(Window.orderBy(F.col('salary').desc()))).filter(F.col('rank') == n).select('salary')
(1 Question)
- Q1. Questions on SQL & PySpark.
(1 Question)
- Q1. Questions about previous projects & optimization techniques etc. Also behavioural
(1 Question)
- Q1. Salary negotiation part.
Skills evaluated in this interview
Deloitte interview questions for designations
Selected
Inbuilt platform where asked gcp releated mcqs
(2 Questions)
- Q1. Python question on list
- Q2. Sql window function question
Get interview-ready with Top Deloitte Interview Questions
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about Azure data bricks
- Ans.
Azure Databricks is a unified analytics platform that provides collaborative environment for big data and machine learning.
Azure Databricks is built on Apache Spark and provides a collaborative workspace for data engineers, data scientists, and machine learning engineers.
It offers integrated notebooks for interactive data exploration and visualization.
Azure Databricks allows for seamless integration with other Azure se...
- Q2. What are spark optimization techniques
- Ans.
Spark optimization techniques improve performance and efficiency of Spark jobs.
Partitioning data correctly to avoid data shuffling
Caching intermediate results to avoid recomputation
Using appropriate data formats like Parquet for efficient storage and retrieval
Tuning memory settings for optimal performance
Avoiding unnecessary data transformations
Interview Preparation Tips
Skills evaluated in this interview
Ruby Bansal
(3 Questions)
- Q1. Asked for record cound in different types of joins
- Q2. Lambda function related coding question
- Q3. Window function related queries
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
(1 Question)
- Q1. What is your qualifications?
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Basic Python and sql questions
(2 Questions)
- Q1. Why you want to change your Job
- Ans.
Seeking new challenges and growth opportunities in a more dynamic environment.
Looking for new challenges and opportunities for growth
Interested in working in a more dynamic environment
Seeking to expand my skills and knowledge in data engineering
Want to work with cutting-edge technologies and tools
- Q2. Why Deloitte and what is your expected CTC
- Ans.
I chose Deloitte for its reputation in the industry and the opportunities for growth. My expected CTC is based on market standards and my experience.
Chose Deloitte for its strong reputation in the industry
Opportunities for growth and development
Expected CTC based on market standards and experience
I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. What is the Underlying Architecture of bigquery
- Ans.
BigQuery is a fully-managed, serverless data warehouse that uses a distributed architecture to process and analyze large datasets.
BigQuery uses a distributed architecture to store and process data, allowing for scalability and high performance.
It separates storage and compute, enabling users to scale each independently based on their needs.
BigQuery leverages Google's infrastructure to automatically handle tasks like re...
- Q2. What is difference between Cloud Run and Cloud Functions
- Ans.
Cloud Run is a fully managed compute platform that automatically scales your stateless containers, while Cloud Functions is a serverless execution environment for building and connecting cloud services.
Cloud Run is designed for running containerized applications, while Cloud Functions is designed for running single-purpose functions.
Cloud Run allows you to run any stateless container, while Cloud Functions only support...
Skills evaluated in this interview
Deloitte Interview FAQs
The duration of Deloitte Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
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
Deloitte Data Engineer Interview Process
based on 19 interviews
3 Interview rounds
- Technical Round - 1
- Technical Round - 2
- HR Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Deloitte Data Engineer Reviews and Ratings
based on 45 reviews
Rating in categories
|
Consultant
34k
salaries
|  ₹6.4 L/yr - ₹23.5 L/yr |
|
Senior Consultant
21.6k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14.6k
salaries
| ₹3.9 L/yr - ₹12.9 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 Data Engineer Interview Questions
