AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Ernst & Young
Compare
Filter interviews by
Ernst & Young Senior Data Engineer Interview Questions, Process, and Tips
Top Ernst & Young Senior Data Engineer Interview Questions and Answers
- Q1. What are the various layers of mdm?
- Q2. What is pyspark architecture
- Q3. What is skewed partitioning
Ernst & Young Senior Data Engineer Interview Experiences
4 interviews found
Anonymous
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(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 ...
- 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
Interview Preparation Tips
Skills evaluated in this interview
(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...
- 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
It was also very easy.
Skills evaluated in this interview
(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...
(1 Question)
- Q1. Tell me why do you wanna grab this oppurtunity
Skills evaluated in this interview
What people are saying about Ernst & Young
Selected
I applied via Recruitment Consulltant and was interviewed before Jul 2022. There were 4 interview rounds.
Mostly coding questions on Python, pyspark and SQL of medium difficulty.
(1 Question)
- Q1. Manager round with technical and details about the project.
(1 Question)
- Q1. Compensation and other questions Int he company.
Ernst & Young interview questions for designations
Interview questions from similar companies
(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...
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
Like- How many , is there in the given sentence
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Project related discussions
- Q2. Meduim level SQl and DSA
(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
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.
(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.
(1 Question)
- Q1. UseEffect polyfill
Skills evaluated in this interview
I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(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
(4 Questions)
- Q1. Sql scenario based question on joins
- Q2. Window function questions
- Q3. Performance tuning
- Q4. Power bi dax question
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
Ernst & Young Interview FAQs
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 Manager Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Ernst & Young Senior Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Database Admin Interview Questions
- Senior Data Scientist Interview Questions
- Data Analyst Interview Questions
- Senior Consultant Interview Questions
- Show more
Ernst & Young Senior Data Engineer Interview Process
based on 4 interviews
1 Interview rounds
- Technical Round
Senior Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Ernst & Young Senior Data Engineer Reviews and Ratings
based on 6 reviews
Rating in categories
|
Senior Consultant
15.8k
salaries
|  ₹9 L/yr - ₹33.8 L/yr |
|
Consultant
12k
salaries
| ₹6.5 L/yr - ₹20.3 L/yr |
|
Manager
7.6k
salaries
| ₹12 L/yr - ₹51.2 L/yr |
|
Assistant Manager
6.4k
salaries
| ₹9.5 L/yr - ₹28.9 L/yr |
|
Associate Consultant
3.9k
salaries
| ₹3.3 L/yr - ₹12 L/yr |
Deloitte
PwC
EY Global Delivery Services ( EY GDS)
Accenture
- Home >
- Interviews >
- Ernst & Young Interview Questions >
- Ernst & Young Senior Data Engineer Interview Questions
