The Morning File

A medium 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
medium
Seniority
mid

Interview Prompt

A single JSON file of the previous day's orders from a live-shopping marketplace, about 4 GB and 20 million records, lands in cloud storage each morning. Design the pipeline that makes each day's file queryable in the warehouse before the daily standup.

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