An overnight ETL produced four kinds of errors last week: HTTP 503 from a downstream during a CPU sp
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
Interview Prompt
An overnight ETL produced four kinds of errors last week: HTTP 503 from a downstream during a CPU spike, HTTP 401 because a service-account token expired, HTTP 429 from a rate limiter that returned a Retry-After header, and a JSON parse error on one malformed row out of two million. The section names two buckets (transient, permanent) plus a third pragmatic case (ambiguous). Classify the failure: add four classifier marker nodes downstream of the ingest transform, one per error, whose names state which bucket the error belongs to and the response that follows.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision