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 daily.
Use 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 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 GroupeCompare ETL and ELT, and explain when ELT is the better pipeline pattern.
Publicis GroupeApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
Publicis GroupeSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain the differences between WHERE and HAVING clauses in SQL and when to use each.
Publicis GroupeAssesses practical SQL skills for joining datasets and using temporary tables to transform data.
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.
Google
Publicis Groupe
RTXTests Python performance practices and reliability for large-scale data processing.
Publicis Groupe