Ernst & Young U.S. LLP Data Engineer Interview Questions
The questions to prepare for a Ernst & Young U.S. LLP Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find missing employee numbers in a fixed sequence using PostgreSQL generate_series and a left join.
Explain the differences between WHERE and HAVING clauses in SQL and when to use each.
Explain normalization, why it improves data integrity, and how to model many-to-one relationships in operational databases.
Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse a CTE, joins, and distinct aggregates to calculate Meta Logistics bookstore payment metrics.
Meta LogisticsApproach for building data pipelines that scale in throughput, reliability, and operational visibility.
Approach for maintaining data quality and integrity across ETL pipelines.
A structured approach to debugging production data pipelines, with focus on orchestration, data quality, idempotency, and safe backfills.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Compare Python lists and tuples, including mutability, performance, and when each should be used.
Tests understanding of Python list operations and their impact on data structures.