Loading...

Consumer Goods Trade Promotion Pipeline on GCP

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
staff

Problem

We are a consumer goods company running dozens of trade promotions simultaneously across hundreds of retail partners, and our commercial analytics team needs to measure promotion ROI in near-real time to see which promotions are working and which are wasting money. Right now the data is fragmented across retailer portals, our own ERP, and third-party syndicated data providers. Design the ingestion pipeline and the BigQuery analytics architecture.

Practice This Problem

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