Dataford
Top 32
Prep plan
Updated weekly · Last refresh Aug 30

Ernst & Young Data Engineer Interview Questions

The questions to prepare for a Ernst & Young Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 12 questions + 3 drills · ~128 min
Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsErnst & Young
Optimize Large-Scale QueriesHard
Recently asked

Tests query optimization strategies for large datasets and performance troubleshooting.

Performance Tuningquery optimizationsqlErnst & Young
Refactor Correlated SubqueriesHard
Recently asked

Tests understanding of correlated subquery performance and refactoring approaches.

SubqueriesPerformance TuningsqlErnst & Young
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Recently asked
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoWorld Wide Technology
SQL Bookstore Schema PracticeEasy
Practice
Practice drill

Use a CTE, joins, and distinct aggregates to calculate Meta Logistics bookstore payment metrics.

sql queriessqlpythonMeta Logistics
Average Vehicle Idle Time by ZoneHard
Practice
Practice drill

Use joins, a CTE, and aggregations to calculate average vehicle idle minutes in a specific geographic zone.

JoinsData ManipulationsqlWaymo
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~33 min
OOP With Python ClassesMedium
Recently asked

Tests how you apply OOP concepts to build maintainable data engineering code.

data engineeringobject-oriented programmingpythonErnst & Young
Pandas DataFrame ManipulationMedium
Recently asked

Tests practical Pandas skills for transforming and preparing data for analytics.

pandasData ManipulationpythonErnst & Young
Tuple vs ListEasy
Recently asked

Tests basic Python data structure knowledge relevant to data engineering.

Data StructurespythonErnst & Young
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership15 questions · ~123 min
Optimize a Slow-Running PipelineMedium
Recently asked

Tests practical pipeline performance tuning and root-cause analysis.

optimizationErnst & Young
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~8 min
Extract and Transform Heterogeneous DataMedium
Recently asked

Tests ability to build robust ETL logic for mixed source formats and schemas.

pythondata extractionErnst & Young
The finish line: interview-readyComplete all 32 questions plus 3 hands-on drills to finish this plan.