Public payments company
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
Public payments company. The financial-close streaming aggregator was blamed last week for a duplicate-revenue incident during a Kafka rebalance; reports for two days had to be reissued. The canvas shows the dual-write antipattern, a Flink aggregator whose engine-level exactly-once does not extend to its sink, and a plain Snowflake destination. The CFO needs exact reconciliation against a bank settlement file at quarter close. Apply the section's six-step synthesis so every boundary is effectively-once and the contract is documented.
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