A startup has nine fragile point-to-point pipelines on the canvas: three sources (Postgres, Stripe,

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Problem

A startup has nine fragile point-to-point pipelines on the canvas: three sources (Postgres, Stripe, Zendesk) each with three team-specific extracts. Every Postgres schema change breaks three pipelines and the on-call gets paged four times a week. Apply the beginner tier (three gaps, four roles, fan-in, layered architecture) to consolidate. Each source should land once into a shared raw zone, one curated transform should feed a shared warehouse, and every dashboard should read from the warehouse. The final canvas should have fewer nodes than it started with.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.