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 Naukri.com and was interviewed in May 2019. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Technical power bi tool

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was average complete on power BI reporting tool

I applied via Recruitment Consultant and was interviewed in Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Industry related question for NBFC and Insurance focusing on these industries past, present and future survival and challenges these industries face and auditing of these industries and other questions mai...

Interview Preparation Tips

Interview preparation tips for other job seekers - Appearance - Strict Formals - Suit and a tie
Body language should be genuine and communicative.

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 Campus Placement and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Audit related

Interview Preparation Tips

Interview preparation tips for other job seekers - nothing much is asked but be sure that you are not gonna get real work at sdc and no value addition will be there thus think before you join

I applied via Recruitment Consultant and was interviewed before Feb 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Depreciation methods and what is the life of a particular category assets
  • Ans. 

    Depreciation methods and asset life are important factors in financial accounting.

    • Depreciation methods include straight-line, double-declining balance, and units of production.

    • Asset life varies by category, such as buildings, vehicles, and equipment.

    • The useful life of a building may be 40 years, while a vehicle may have a useful life of 5 years.

    • Depreciation is important for accurately reporting the value of assets on f

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and accept if you don't know the answer

I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What is Materiality?
  • Ans. 

    Materiality refers to the significance or importance of information in relation to a company's financial statements.

    • Materiality is a concept used in accounting and auditing.

    • It helps determine what information is important enough to be included in financial statements.

    • Materiality is based on the amount or nature of the information and its impact on the financial statements.

    • For example, a $10,000 error in a company with ...

  • Answered by AI
  • Q2. Proposed dividend?
  • Ans. 

    The proposed dividend is currently under review and will be announced at a later date.

    • The company is currently reviewing its financials to determine the feasibility of a dividend payout

    • The decision on the proposed dividend will depend on various factors such as profitability, cash flow, and future growth prospects

    • The announcement of the proposed dividend will be made after the review process is complete

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and keep faith on yourself.

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 129 salaries
₹9 L/yr - ₹33.5 L/yr
6% 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
16.2k salaries
unlock blur

₹9 L/yr - ₹34 L/yr

Consultant
12.2k salaries
unlock blur

₹6.5 L/yr - ₹21 L/yr

Manager
7.6k salaries
unlock blur

₹16 L/yr - ₹48.5 L/yr

Assistant Manager
6.5k salaries
unlock blur

₹9.5 L/yr - ₹29 L/yr

Associate Consultant
4k salaries
unlock blur

₹3.5 L/yr - ₹11.9 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