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

 (9)

 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

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is difference between dynamic data frame and spark data frame in aws glue job? can we change dynamic dataframe to spark datafrmae?
  • Ans. 

    Dynamic data frame in AWS Glue job is a dynamically generated data frame, while Spark data frame is specifically created using Spark APIs.

    • Dynamic data frame is generated dynamically at runtime based on the data source and schema, while Spark data frame is explicitly created using Spark APIs.

    • Dynamic data frame is more flexible but may have performance implications compared to Spark data frame.

    • You can convert a dynamic d...

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Round 1-Sql based theoretical questions Round 2- sql coding questions Round 3- Project based questions Round 4-Project based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - For the logical round be very confident with string based logical sql question.
Like- How many , is there in the given sentence
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Project related discussions
  • Q2. Meduim level SQl and DSA
Round 2 - One-on-one 

(2 Questions)

  • Q1. This was data modelling round
  • Q2. Design a uber data model
  • Ans. 

    Uber data model design for efficient storage and retrieval of ride-related information.

    • Create tables for users, drivers, rides, payments, and ratings

    • Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

    • Establish relationships between tables using foreign keys

    • Implement indexing for faster query performance

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQl, Python and data modeling

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Longest Increasing Subsequence
  • Ans. 

    Find the length of the longest increasing subsequence in an array.

    • Use dynamic programming to solve this problem efficiently.

    • Iterate through the array and keep track of the longest increasing subsequence ending at each index.

    • Example: For array [10, 22, 9, 33, 21, 50, 41, 60, 80], the longest increasing subsequence is [10, 22, 33, 50, 60, 80] with length 6.

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. UseEffect polyfill

Skills evaluated in this interview

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

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • Q3. How to add date table in power bi
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

  • Q1. Do you know the role and responsibility of this position

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.8k salaries
unlock blur

₹9 L/yr - ₹33.8 L/yr

Consultant
12k salaries
unlock blur

₹6.5 L/yr - ₹20.3 L/yr

Manager
7.6k salaries
unlock blur

₹12 L/yr - ₹51.2 L/yr

Assistant Manager
6.4k salaries
unlock blur

₹9.5 L/yr - ₹28.9 L/yr

Associate Consultant
3.9k salaries
unlock blur

₹3.3 L/yr - ₹12 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