A revenue pipeline at a payments company processes settlement events from Kafka, enriches them with
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 revenue pipeline at a payments company processes settlement events from Kafka, enriches them with a tax-jurisdiction API, validates schema, dedupes, and writes to a Snowflake mart finance reads daily. Every intermediate-tier pattern applies. Compose the resilient pipeline: classify each error class on the worker; wrap the tax-API call in a retry budget and a circuit breaker; add a DLQ for permanent and budget-exhausted events; choose skip-and-quarantine for malformed rows with a 1% threshold; route credential failures to a paging destination so on-call rotates the credential. The Snowflake destination remains on the production read path.
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