Upload Button Icon 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 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Ernst & Young Senior Data Engineer Interview Questions, Process, and Tips

Updated 8 Oct 2024

Top Ernst & Young Senior Data Engineer Interview Questions and Answers

Ernst & Young Senior Data Engineer Interview Experiences

4 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is spark architecture
  • Ans. 

    Spark architecture refers to the structure of Apache Spark, a distributed computing framework.

    • Spark architecture consists of a cluster manager, worker nodes, and a driver program.

    • The cluster manager allocates resources and schedules tasks across worker nodes.

    • Worker nodes execute tasks in parallel and store data in memory or disk.

    • The driver program coordinates the execution of tasks and manages the overall workflow.

    • Spar...

  • Answered by AI
  • Q2. Optimizations of spark jobs
  • Ans. 

    Optimizing Spark jobs involves tuning configurations, partitioning data, using appropriate data structures, and leveraging caching.

    • Tune Spark configurations for optimal performance

    • Partition data to distribute workload evenly

    • Use appropriate data structures like DataFrames or Datasets

    • Leverage caching to avoid recomputation

    • Optimize shuffle operations to reduce data movement

  • Answered by AI
Round 2 - Coding Test 

It was also very easy.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is pyspark architecture
  • Ans. 

    PySpark architecture is a distributed computing framework that combines Python and Spark to process big data.

    • PySpark architecture consists of a driver program, cluster manager, and worker nodes.

    • The driver program is responsible for creating SparkContext, which connects to the cluster manager.

    • Cluster manager allocates resources and schedules tasks on worker nodes.

    • Worker nodes execute the tasks and return results to the ...

  • Answered by AI
  • Q2. What is skewed partitioning
  • Ans. 

    Skewed partitioning is when data is not evenly distributed across partitions, leading to performance issues.

    • Skewed partitioning can occur when a key column has a few values that are much more common than others.

    • It can lead to uneven processing and resource utilization in distributed systems like Hadoop or Spark.

    • To address skewed partitioning, techniques like data skew detection, data skew handling, and data skew preven

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all basics

Skills evaluated in this interview

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What are the various layers of mdm?
  • Ans. 

    MDM (Master Data Management) typically consists of three layers: operational, analytical, and data governance.

    • Operational layer: manages the day-to-day data operations and transactions.

    • Analytical layer: focuses on data analysis and reporting for decision-making.

    • Data governance layer: ensures data quality, security, and compliance.

    • Example: In a retail company, the operational layer manages customer transactions, the ana...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Tell me why do you wanna grab this oppurtunity

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jul 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Mostly coding questions on Python, pyspark and SQL of medium difficulty.

Round 3 - Technical 

(1 Question)

  • Q1. Manager round with technical and details about the project.
Round 4 - HR 

(1 Question)

  • Q1. Compensation and other questions Int he company.

Ernst & Young interview questions for designations

 Data Engineer

 (10)

 Big Data Engineer

 (2)

 Lead Data Engineer

 (1)

 Data Architect

 (1)

 Senior Data Scientist

 (3)

 Senior Data Analyst

 (1)

 Associate Data Engineer

 (2)

 Senior Software Engineer

 (8)

Interview questions from similar companies

I applied via Referral and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About past experience.

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was technical one. Mostly on my previous experience. I was for about 40 minutes. After you clear technical round there will be online communication test which includes listening skills, writing skills, etc. Best of luck.

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Joins, union
  • Q2. Delete truncate

Interview Preparation Tips

Interview preparation tips for other job seekers - Answer to the point
Confidence

I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. About previous work experience
Round 2 - Technical 

(1 Question)

  • Q1. Not much .. process of recon and fund accounting

Interview Preparation Tips

Interview preparation tips for other job seekers - Go prepared ... Questions can be on anything and on past experience

I applied via Walk-in and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

No

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Check all the review and think accordingly.

I applied via Walk-in and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Accounting questions and work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare for accounting entries and work experience

I applied via Walk-in and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Technical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Give your best and prepare well

Ernst & Young Interview FAQs

How many rounds are there in Ernst & Young Senior Data Engineer interview?
Ernst & Young interview process usually has 2-3 rounds. The most common rounds in the Ernst & Young interview process are Technical, Coding Test and HR.
How to prepare for Ernst & Young Senior 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, GCP, Python, AWS and Analytics.
What are the top questions asked in Ernst & Young Senior Data Engineer interview?

Some of the top questions asked at the Ernst & Young Senior Data Engineer interview -

  1. What are the various layers of m...read more
  2. What is pyspark architect...read more
  3. What is skewed partition...read more

Tell us how to improve this page.

Ernst & Young Senior Data Engineer Interview Process

based on 4 interviews

1 Interview rounds

  • Technical Round
View more

Senior Data Engineer Interview Questions from Similar Companies

View all
Ernst & Young Senior Data Engineer Salary
based on 121 salaries
₹11 L/yr - ₹33.5 L/yr
11% more than the average Senior Data Engineer Salary in India
View more details

Ernst & Young Senior Data Engineer Reviews and Ratings

based on 6 reviews

3.9/5

Rating in categories

4.3

Skill development

3.8

Work-life balance

3.5

Salary

4.7

Job security

3.8

Company culture

3.5

Promotions

3.8

Work satisfaction

Explore 6 Reviews and Ratings
Senior Consultant
15.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
12k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
7.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
6.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
3.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Ernst & Young with

Deloitte

3.8
Compare

PwC

3.4
Compare

EY Global Delivery Services ( EY GDS)

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview