Fifty Thousand Retailers

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

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

We're a consumer packaged goods company selling through 50,000 retail partners worldwide, and sell-through data arrives three ways: distributor EDI files and retailer portal exports on daily and weekly drops, and direct-to-consumer orders that stream in continuously. Design one unified sell-through pipeline across all three channels where every row carries how fresh its source is, and where promoted units stay separable from baseline for demand planning. Retailer files routinely include duplicate and bad-code rows the data team needs to review, so route those aside for triage rather than silently dropping them.

Summary

Retail data at CPG scale. Every SKU, every store.

Practice This Problem

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