Interview questions
Preparing for a data engineering interview at EY? This page contains 24 real interview questions sourced from verified EY interview experiences. Questions are sorted by frequency — the ones asked most often appear first.
EY data engineering interviews typically focus on SQL, Cloud/Tools, and Python/Coding. There's a solid mix of fundamental and advanced questions, making it accessible for candidates at multiple experience levels.
Use the difficulty filters above to focus your preparation. For each question, attempt your own answer first, then compare with our expert solution. You can also practice these questions in our AI Mock Interview Coach for real-time feedback.
What are Airflow Operators? Give examples.
How do you remove duplicate rows in BigQuery?
Explain the difference between Azure Data Factory (ADF) and Databricks.
What are the key components of AWS Glue, and how do they work together?
What is Azure Data Factory (ADF), and what are its main components?
What is Snowflake's architecture, and why is it unique?
What is the difference between S3 and HDFS?
What is the role of AWS Lambda in a data engineering pipeline?
What is the role of the Integration Runtime (IR) in ADF?
Difference Between Internal and External Tables in BigQuery
What is the difference between OLTP and OLAP?
Describe AWS Glue components and their functions.
Reverse a string with special characters preserved.
Write Python code to remove duplicates from a string.
Explain BigQuery Architecture.
Explain Data Modeling SCD Types (Type 1, 2, 3).
How many records result from Inner Join, Left Join, Right Join given Table A and Table B?
Self-introduction including current role, projects, and key responsibilities. Focus on SQL expertise, Python skills, and experience in data warehousing and modeling.
What are BigQuery Slots?
What are the benefits of BigQuery Warehouse?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.