Staff Data Engineer Top Tech Architecture
SplunkWhich Promotion Is Actually Working
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.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Which Promotion Is Actually Working
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
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.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision