Sift Interview Questions
The questions to prepare for Sift interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
SiftTraverse a binary tree level by level using a queue-based breadth-first search.
SiftSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design a production ranking system with robust feature drift monitoring across batch and real-time features at high QPS.
SiftHandle rare positive labels in ad fraud detection with the right sampling, loss design, validation, and thresholding strategy.
SiftDesign a real-time IoT telemetry pipeline processing 180K sensor events/sec with <10s latency, replayability, data quality checks, and warehouse delivery.
SiftDiagnose a post-release KPI drop by separating instrumentation issues from real behavior changes and tracing the problem through the metric hierarchy.
SiftTests technical ownership and communication through a concrete architecture decision, with emphasis on trade-offs, judgment, and lessons learned.
SiftTests rigorous experimentation practices, including bias control for peeking and novelty effects.
Sift