dentsu Data Engineer Interview Questions
The questions to prepare for a dentsu Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Explain the architecture of a complex ETL pipeline built from scratch, including orchestration, data quality, idempotency, and backfill strategy.
Approach for building data pipelines that scale in throughput, reliability, and operational visibility.
Discuss how cloud storage fits into ETL pipelines, including staging, data quality, and operational monitoring.
Compare batch and stream processing across latency, complexity, cost, and data quality in a modern analytics pipeline.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Tests your ability to write correct SQL logic for complex transformations.
Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.
Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Capgemini
NomuraAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests ownership in diagnosing a data issue, communicating clearly under pressure, and driving a durable fix with measurable impact.