Pension Fund Daily Import Job
A daily background job that ingests and processes multiple CSV files from an external pension fund provider, updating local shadow accounts so e-banking customers always see current portfolio values.
Pension fund values don't live in your own database — they live with the Vorsorgestiftung. To show customers their current balances in e-banking, you need a reliable daily bridge between their world and yours.
This background job runs on a schedule, picks up the incoming CSV files from the pension fund provider, and processes each one in turn. The data is parsed, validated, and mapped onto the local shadow account structure — the internal representation that the e-banking layer reads to display current values to customers.
The job handles multiple files per run, each potentially covering different account types or sub-funds. Error handling is built around observability: bad rows are flagged and logged without stopping the rest of the import, so a single malformed entry doesn't block an entire customer cohort from seeing their data.
Built in C# on .NET, backed by SQL Server.