Compute dasher payout from API data
Company: DoorDash
Role: Software Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Onsite
Given a REST endpoint GET /payout that returns each delivery’s components (base pay, distance/time bonuses, promotions, tips, fees, adjustments, taxes, refunds) with timestamps, compute each Dasher’s total pay for a pay period. Handle pagination, missing/late events, time zones, partial-day boundaries, cancellations/chargebacks, negative adjustments, and rounding rules. Provide a Python or SQL implementation that aggregates per Dasher and outputs totals and itemized breakdowns; include test cases and discuss complexity.
Quick Answer: This question evaluates a candidate's proficiency in data manipulation and transaction aggregation using SQL or Python, encompassing time-zone-aware timestamp handling, pagination, late or missing events, cancellations and negative adjustments, rounding rules, and itemized breakdowns.