Badging Items That Already Sold Out

A hard Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
Pipeline Design
Difficulty
hard
Seniority
L6

Interview Prompt

We promise same-day delivery on millions of SKUs, and the engine that decides which items get the same-day badge needs fresh data every few minutes. Stale features are making us over-promise on items that are out of stock or whose nearest fulfillment center is at capacity. Design a data pipeline that keeps the feature store current.

Summary

Same-day delivery. The features have to be faster.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Draw your pipeline on the design canvas: sources, transforms, storage and checks
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision