Sift Interview Questions
The questions to prepare for Sift interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
SiftUse a CTE and window functions to calculate daily, cumulative, and three-day moving transaction volumes by Mastercard MCC.
MastercardUse PostgreSQL window functions to calculate client running totals and trailing 30-day average transaction volumes.
PwCTraverse 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 rigorous experimentation practices, including bias control for peeking and novelty effects.
SiftTests Bayesian reasoning and probability calculations for interpreting fraud alert performance.
Sift