Zoox·Software Engineer·Technical Phone Screen
- Given a transactions table and a vendors table, find the top 3 vendors by total net revenue (purchases minus refunds) over the past two years.
- For each state and city combination, find the top 3 vendors by total net revenue over the past two years.
- Propose several data quality and anomaly checks for this transaction dataset, then write SQL queries to detect each issue. Think about things like invalid refund references, mismatched refund amounts, duplicate transaction IDs, vendors not in the vendor table, and unusual spikes in volume or amount.
“Pretty standard warm-up.”