Daily Payment Log Pipeline

A hard 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

hard

Seniority

staff

Interview Prompt

A fintech company processes billions of payment transactions per day across three regions: US, EU, and APAC. Each region writes raw payment logs to its own object storage bucket. The data team needs a batch pipeline that runs daily, ingests the previous day's logs from all regions, deduplicates events, aggregates to a merchant-level summary table, and makes results available for global reporting by 6 AM UTC. Design this pipeline.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your pipeline design solution with real code execution
4. Get instant feedback and a hire/no-hire decision