Unity Data Engineer Interview Questions
The questions to prepare for a Unity Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Sort intervals by start time, then merge overlapping ranges into a minimal non-overlapping list.
UnityTests ability to process large files efficiently with streaming and transformations.
UnityApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
UnityDesign a real-time event pipeline that can handle millions of events per second with sub-second latency.
UnityDesign an AWS data lake architecture handling 12 TB/day batch data and 80K events/sec with governed bronze, silver, and gold layers.
UnitySign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how RANK(), DENSE_RANK(), and ROW_NUMBER() differ when ordering tied clinical trial results.
UnityTests correctness and robustness of aggregation logic with incomplete data.
UnityTests handling of late-arriving events and deduplication logic in SQL.
UnityCalculate monthly active-user retention for Unity Ads using CTEs, joins, date truncation, and conditional aggregation.
Unity
DoorDash
AutodeskCompute daily distinct active users and a 7-day rolling average using a CTE and window function.
Activision
Stripe
Pyramid ConsultingRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
Waymo