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.
Assesses practical SQL and Python fundamentals for data engineering work.
Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPCompare 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.