Someone Else's Server

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
senior

Interview Prompt

On days the external payments vendor settling our marketplace orders rate-limits or returns errors on pages of its paginated REST API, the finance team's reconciliation comes up short. Design the scheduled pull that keeps ingesting through those failures and only lets clean, deduplicated records reach the finance warehouse, at a few million records a day.

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