Usage file ingestion
Nightly mediation files are loaded by scripts nobody wants to touch.
Files are chunked, validated and loaded into billing; malformed records go to quarantine.
- 1Mediation file (SFTP)
- 2Split into chunks
- 3Validate records
- 4Deliver to billing
See it working: SFTP CSV → validate → database, rejects emailed