Investment data reconciliation
Create two mock investment datasets with differences in positions, cash balances and accrued interest. Reconcile them in Excel or SQL, identify likely causes and write an exception log with validation steps.
The AIS Data Operations role investigates these reconciliation breaks and maintains auditable exception records.
Source posting