Sanofi Data Engineer Interview Questions
The questions to prepare for a Sanofi Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Calculate total and average completed Sanofi sales by region using a LEFT JOIN, aggregation, date filtering, and NULL handling.
SanofiCompare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
SanofiExplain star and snowflake schemas, their tradeoffs, and when to use each in Meta-scale analytics systems.
SanofiUse joins, a CTE, and aggregations to calculate average vehicle idle minutes in a specific geographic zone.
WaymoAnalyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.
Deloitte
ReputationEvaluates your ability to implement robust duplicate handling logic in dataframes.
SanofiAssesses your fundamentals of Python list operations and slicing.
SanofiAssesses collaboration practices and engineering hygiene for team-based development.
SanofiSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests concise self-introduction, clear project storytelling, and the ability to explain personal impact in a data science context.
SanofiAssesses your hands-on experience level with ETL development.
Sanofi