DataDrivenDataDriven
LearnPracticeInterviewDiscussDailyJobs

The Sale That Needs to Land Now

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

Domain
Pipeline Design
Difficulty
medium
Seniority
L5

Problem

We run a global luxury e-commerce marketplace where sales arrive from three channels in three shapes: the web storefront pushes JSON events, the mobile apps send batched JSON, and partner retail integrations are polled as XML, and every order has to be reconciled into one canonical record before anything downstream reads it. Merchandising runs live flash sales and needs sales from all three channels landing in their dashboard within minutes to tune discounts, so no channel can sit behind a daily-batch-only path, while the data science team only needs a clean daily archive for modeling. Many buyers are in the EU, so customer email and shipping address are GDPR-regulated and can never sit in a queryable table in the clear.

Summary

Three channels feeding one view. Not all of them speak the same language.

Practice This Problem

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

Related

  • All Practice Problems
  • Mock Interview Mode
  • System Design Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons