Three Regions, One Report

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

Domain

Pipeline Design

Difficulty

hard

Seniority

L7

Problem

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.

Summary

Three regions, billions of payments, one merchant summary by 6 AM.

Practice This Problem

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