Ingestion
S3 + Lambda ETL
Export files from all four systems land in S3. A Lambda fires on each file, identifies the source by its header pattern, applies that source's transformations and writes validated records to Aurora MySQL.
AWS LambdaS3Pythonpandas