Publicis Groupe Data Engineer Interview Questions
The questions to prepare for a Publicis Groupe Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Compare ETL and ELT, and explain when ELT is the better pipeline pattern.
Publicis GroupeDesign an AWS-native real-time clickstream pipeline processing 1M events/sec with under 2-minute latency, replay support, and strong data quality controls.
Publicis GroupeApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
Publicis GroupeExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
Publicis GroupeTests performance tuning for large-scale analytics queries on high-volume advertising data.
Publicis GroupeTests correct treatment of NULLs to ensure accurate metrics in reporting pipelines.
Publicis GroupeCalculate month-over-month sales growth for each product category using JOINs and window functions.
Wayfair
REVOLVE
FanaticsUse joins, a CTE, and aggregation to rank the top 5 products by non-returned revenue in the last 30 days.
Blue Nile
O'Reilly Auto Parts
CengageUse a CTE, joins, and RANK() to find the top 2 clients by revenue for each product from completed 2024 orders.
GooglePublicis Groupe
RTXUse Kadane's algorithm to find the contiguous subarray with the largest sum in linear time.
Publicis GroupeCompare Python lists and tuples, including mutability, performance, and when each should be used.
Publicis GroupeSign up to see every question
Create a free account to unlock this list and practice real interview questions.