Add office photos
Premium Employer
i
This company page is being actively managed by
Deloitte Team. If you also belong to the team, you
can get access from
here
Deloitte
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Deloitte Snowflake Data Engineer Interview Questions, Process, and Tips
Updated
4 Mar 2024
1 Deloitte Snowflake Data Engineer Interview Experience
10 questions found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Hard
Duration
2-4 weeks
Result
Not Selected
I applied via Referral and was interviewed in Sep 2023.
2 Interview Rounds
1
Technical Round (4 Questions)
- Q1. Explain the architecture & unique characteristics of Snowflake View Answers (1)
- Q2. Define Time Travel and how it helps . View Answers (1)
- Q3. How to set data retention time as 0 . View Answers (1)
- Q4. Explain Stages and stored procedure. View Answers (1)
2
Technical Round (6 Questions)
- Q1. Why snowflake is better than other cloud datawarehouse? View Answers (1)
- Q2. Migration in Snowflake and the process View Answers (1)
- Q3. Ingestion Part in Snowflake View Answers (1)
- Q4. What are the connectors in Snowflake. View Answers (1)
- Q5. What are the types of security in Snowflake? View Answers (1)
- Q6. Tough SQL Questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepare with SQL , Understanding to be good in Snowflake area.
Skills evaluated in this interview
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Sep 2024.
2 Interview Rounds
1
Technical Round (5 Questions)
- Q1. Spark architecture Add Answer
- Q2. Difference between coalesce and reparation View Answers (1)
- Q3. SQL question using Lag window function Add Answer
- Q4. Same question in Pyspark Add Answer
- Q5. Project and day to day activities Add Answer
2
Behavioral Round (2 Questions)
- Q1. Scenario based questions Add Answer
- Q2. Gave details about work Add Answer
Interview Preparation Tips
Topics to prepare for PwC Data Engineer interview:
- Spark
- SQL
- Pyspark
- Project
- Soft Skills
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
3 Interview Rounds
1
Coding Test Round
Some multiple choice, 2 sql and 2 python questions were asked
2
Technical Round (2 Questions)
- Q1. Tell me about you project View Answers (1)
- Q2. Optimising technique that you have used View Answers (1)
3
Technical Round (2 Questions)
- Q1. Window partition question was asked Add Answer
- Q2. Project related question Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
4-6 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Aug 2024.
2 Interview Rounds
1
One-on-one Round (2 Questions)
- Q1. Project related discussions Add Answer
- Q2. Meduim level SQl and DSA Add Answer
2
One-on-one Round (2 Questions)
- Q1. This was data modelling round Add Answer
- Q2. Design a uber data model View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare SQl, Python and data modeling
Skills evaluated in this interview
tejas jain
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Newspaper Ad and was interviewed in Aug 2024.
3 Interview Rounds
1
Aptitude Test Round
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
2
Technical Round (2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list View Answers (1)
- Q2. Written a SQL query Add Answer
3
HR Round (2 Questions)
- Q1. Coding question like add numbers Add Answer
- Q2. Experience on your project View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Power BI
Difference between ALL() and ALLSELECTED() View Answers (1)
- Q2. Excel
Difference between COUNT() and COUNTA() View Answers (1)
2
Technical Round (2 Questions)
- Q1. Resume based questions like explain the projects that you have done. Add Answer
- Q2. Sample dataset questions Add Answer
Skills evaluated in this interview
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Project explaining Add Answer
- Q2. Write code to generate csv file with note pad data View Answers (1)
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. What is spark architecture View Answers (1)
- Q2. Optimizations of spark jobs View Answers (1)
2
Coding Test Round
It was also very easy.
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Approached by Company and was interviewed in Aug 2024.
1 Interview Round
1
Coding Test Round
Maxium sub string and reverse a string
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via campus placement at Lady Shri Ram College for Women, Delhi
4 Interview Rounds
1
Aptitude Test Round
Basic English, Quants and Statistics
2
Group Discussion Round
Easy, relevant to pandemic
3
Technical Round (1 Question)
- Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level Add Answer
4
One-on-one Round (2 Questions)
- Q1. Behavioural Questions Add Answer
- Q2. Statistics Case Study Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Good and organized interview process for the post of Data Analyst
Deloitte Interview FAQs
How many rounds are there in Deloitte Snowflake Data Engineer interview?
Deloitte interview process usually has 2 rounds. The most common rounds in the Deloitte interview process are Technical.
What are the top questions asked in Deloitte Snowflake Data Engineer interview?
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 Associate Analyst Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Business Technology Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Snowflake Developer Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Show more
People are getting interviews through
based on 1 Deloitte interview
Referral
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Fast track your campus placements
38%
less
than the average Snowflake Data Engineer Salary in India
View more details
Deloitte Snowflake Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
32.7k
salaries
|  ₹6.2 L/yr - ₹23 L/yr |
|
Senior Consultant
20.8k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
13.8k
salaries
| ₹3.8 L/yr - ₹12.6 L/yr |
|
Assistant Manager
9.9k
salaries
| ₹7.5 L/yr - ₹27.5 L/yr |
|
Manager
7k
salaries
| ₹15.5 L/yr - ₹53 L/yr |
Explore more salaries
Compare Deloitte with
Accenture
Compare
PwC
Compare
Ernst & Young
Compare
Cognizant
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Snowflake Data Engineer Interview Questions
Share an Interview