A platform team is rebuilding ingestion from a Postgres operational database to a Snowflake warehous
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
A platform team is rebuilding ingestion from a Postgres operational database to a Snowflake warehouse. Three tables matter. customers (2M rows, slow updates) needs hourly. orders (500M rows, +10M/day, deletes critical) needs five-minute. legacy_events (hosted Postgres, no WAL access) needs daily. Compose the ingestion: pick the load and CDC strategy per table with the trade-off named, wire bookmark stores or replication slots as appropriate, ensure each sink dedupes on a stable key, and route everything into Snowflake.
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