Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
Filter interviews by
Ernst & Young Data Engineer Interview Questions, Process, and Tips
Updated
15 Nov 2024
Top Ernst & Young Data Engineer Interview Questions and Answers
- Q1. Difference between star and Snowflake schema in detail
- Q2. Diff btw transient table , fact table and dimension table
- Q3. list vs tuple difference
7 Ernst & Young Data Engineer Interview Experiences
14 questions found
Sort by:
Popular
avish goswami
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Difference between star and Snowflake schema in detail View Answers (1)
- Q2. Diff btw transient table , fact table and dimension table View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare more for Data Warehousing and Data modelling
Skills evaluated in this interview
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed in Sep 2024.
2 Interview Rounds
1
Coding Test Round
Spark and SQL question can expect
2
Case Study Round
Focusing on the past project
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared on basic understanding and practice the coding questions.
Interview experience
Poor
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Spark Optimization Techniques View Answers (1)
- Q2. Spark Architecture Add Answer
Skills evaluated in this interview
What people are saying about Ernst & Young
View All
happyshrike
works at
Bitwise Solutions
Need advice
I want to know about the company Capco.
Current domain: Data Engg
YOE: 4.7
CCTC: 16.4
Offer: 23(fixed)+1 JB
Post: Sr Consultant 2 grade M2.
I want to know about the company culture,WLB,job security,bench policy.Also,I am a bit confused.The role offered is for a consultant,but the questions were more oriented toward arch. There were no questions on PySpark.The manager said the work is on ETL migration for Barclays using AWS Glue and Spark,but no related questions.Should I take the offer or continue rounds with EPAM,UST,EY?
There are other offers.
Yash Tech:22LAP(fixed)
Publicis Sapient: 25(fixed)
Quantiphi: 25(quoted from my side,no offer yet)
But the thing is that here the work is unclear. Also there are other company rounds going like EPAM,UST.
Got a question about Ernst & Young?
Ask anonymously on communities.
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Referral and was interviewed in May 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Tell me about yourself Add Answer
- Q2. Discussion on current project architecture Add Answer
Ernst & Young interview questions for designations
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Jan 2024.
4 Interview Rounds
1
One-on-one Round (2 Questions)
- Q1. Python pandas SQL Tableau Add Answer
- Q2. List vs tuple difference View Answers (1)
2
Technical Round (1 Question)
- Q1. SQL ,python problem solving Add Answer
3
One-on-one Round (1 Question)
- Q1. Manager Discussion Add Answer
4
HR Round (1 Question)
- Q1. Salary discussion Add Answer
Skills evaluated in this interview
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. About sql language Add Answer
- Q2. About your current project Add Answer
Data Engineer Jobs at Ernst & Young
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I was interviewed in Jan 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Questions about pyspark , sql, etl Add Answer
Interview questions from similar companies
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql constrainsts, star schema, dml dcl commands Add Answer
- Q2. About cureent project and responsibilities Add Answer
2
Technical Round (2 Questions)
- Q1. Current projects and resposibilities Add Answer
- Q2. Where vs having, reason for job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. Technical - about you current project and responsibilities, basic SQL question-constraints, starschema, DML DCL command, one sql query write.
2. Technical with senior manager- about project ,where vs having , reason of job change
2. Technical with senior manager- about project ,where vs having , reason of job change
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
Ernst & Young Interview FAQs
How many rounds are there in Ernst & Young Data Engineer interview?
Ernst & Young interview process usually has 1-2 rounds. The most common rounds in the Ernst & Young interview process are Technical, One-on-one Round and HR.
How to prepare for Ernst & Young Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Ernst & Young. The most common topics and skills that interviewers at Ernst & Young expect are SQL, Python, Spark, Big Data and ETL.
What are the top questions asked in Ernst & Young Data Engineer interview?
Tell us how to improve this page.
Ernst & Young Interviews By Designations
- Ernst & Young Consultant Interview Questions
- Ernst & Young Senior Consultant Interview Questions
- Ernst & Young Analyst Interview Questions
- Ernst & Young Associate Consultant Interview Questions
- Ernst & Young Tax Analyst Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Ernst & Young Manager Interview Questions
- Ernst & Young Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Interview Process at Ernst & Young Data Engineer
based on 7 interviews in last 1 year
1 Interview rounds
- Technical Round
View more
People are getting interviews through
based on 3 Ernst & Young interviews
Company Website
Job Portal
Referral
33%
33%
33%
1% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
15%
more
than the average Data Engineer Salary in India
View more details
Ernst & Young Data Engineer Reviews and Ratings
based on 16 reviews
Rating in categories
|
Senior Consultant
15.3k
salaries
|  ₹9 L/yr - ₹33.3 L/yr |
|
Consultant
11.7k
salaries
| ₹6 L/yr - ₹20 L/yr |
|
Manager
7.4k
salaries
| ₹16.5 L/yr - ₹51.2 L/yr |
|
Assistant Manager
6.2k
salaries
| ₹9.5 L/yr - ₹28 L/yr |
|
Associate Consultant
3.7k
salaries
| ₹3.5 L/yr - ₹12 L/yr |
Explore more salaries
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
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 >
- Ernst & Young Interview Questions >
- Ernst & Young Data Engineer Interview Questions
Share an Interview