EY
Ernst & Young Global Limited, a multinational professional services partnership.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Coding
•
medium
Write a PySpark script to read a CSV file from Azure Data Lake, filter out records with null client IDs, and write the output to Parquet format partitioned by transaction date.
#Data I/O
#DataFrames
#Partitioning
Data Engineer
•
Coding
•
easy
Write a PySpark snippet to perform a left anti join. Explain a business use case for this operation in an audit context.
#Joins
#Data Validation
Data Engineer
•
Technical
•
hard
How do you handle data skewness when performing a join in PySpark on a massive dataset of retail transactions?
#Performance Tuning
#Data Skew
#Distributed Computing
Data Engineer
•
Technical
•
medium
Explain the difference between narrow and wide transformations in Spark. Why is this distinction important for optimizing ETL pipelines?
#Spark Architecture
#Transformations
#Shuffling
Data Engineer
•
Technical
•
easy
What is the difference between repartition() and coalesce() in PySpark? When would you use one over the other?
#Partitioning
#Performance Tuning
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.