Loading interview...
Loyalty Rewards Pipeline with Late Bank Data
A medium 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
- medium
- Seniority
- senior
Interview Prompt
Our loyalty app links to users' bank accounts and credits reward points when they make purchases at partner brands. The problem is that bank data from our aggregators arrives 12 to 48 hours after the actual transaction, and by that time an offer may have expired or the user may have already redeemed that offer slot. We're also seeing duplicate transactions from aggregator bugs causing users to be double-credited. Design a pipeline that handles the late data problem and guarantees we never credit points twice for the same purchase.
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