Strip Interview Question for Data Engineers
- 0of 0 votes
Answer/*
- trish March 19, 2019 in United States
## Setup
The flow of a dispute is as follows:
- A charge is created by an end customer.
- Stripe receives a dispute record from the bank.
- The business responds with evidence.
- If no second dispute is received within 30 days after evidence submission, the dispute is won. If a second dispute is received, the dispute is lost.
Charge
(Maybe) Dispute Record
(Maybe) Evidence submission
(Maybe) Second Dispute Record
The raw tables generated from the API look like:
```
Charges
+---------------+-----------+
| charge_id | varchar |
| created | timestamp |
| amount | int |
| seller_id | varchar |
| customer_id | varchar |
+---------------|-----------+
Dispute Records
+----------------+-----------+
| dispute_id | varchar |
| created | timestamp |
| charge_id | varchar |
+----------------|-----------+
Evidence Submission
+-------------------+-----------+
| evidence_id | varchar |
| created | timestamp |
| charge_id | varchar |
+-------------------|-----------+
```
*/
/*
1. Can you design a unified dispute table that would allow us to compute things like the win rate, dispute rate, evidence submission rate etc?
*/| Report Duplicate | Flag | PURGE
Strip Data Engineer SQL
Interview Type: Phone Interview
- jk June 29, 2019