Intermediate · 25 min · 5 steps
Do the billing system and the data warehouse agree?
Sandeep Kulkarni, Data Integrity & Reliability Engineer at CloudPay FinTech
It is Thursday, 9:00 AM. Sandeep Kulkarni is a data reliability engineer at CloudPay FinTech, a company that handles payments for businesses and runs the money systems behind digital banking in South Asia. It processes over 250,000 settlements a day. Today is the monthly risk review, and the audit team is getting ready for the yearly inspection by the Reserve Bank of India (RBI).
The question
Do the two systems agree? What exactly is wrong with each account that does not match, and how do we explain it simply to leaders?
- FULL OUTER JOIN
- Data reconciliation
- CASE WHEN
- Data quality
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.