data consultancy Data Engineer Interview Questions
The questions to prepare for a data consultancy Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Identify duplicate active Finacle transactions using a CTE, grouped business keys, and a customer lookup.
Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Identify common SQL join types and explain when each is appropriate.
Compare ETL and ELT, and explain when ELT is the better pipeline pattern.
Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.
Approach for maintaining data quality and integrity across ETL pipelines.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests understanding of execution concepts in distributed pipelines.
Find two indices whose values reach a target sum in one pass using a hash map.