1. 1 hr call with the hiring manage
2. 45 mins SQL test
3. System design
4. In person final motivation chat
I got rejected in stage 3
SQL test was about some exchange rate question and need to do a lead window function.
In the system design part, you will need to define schema of two datasets related to payment in order to answer some questions in a chart. Then design model that is efficient and cost saving. (e.g. incremental model) Also need to deal late arriving data.