Boss: ingest pipeline
Four dirty files, one pipeline. Pick the right COPY options for each, stage text where the format is odd, and end with typed tables whose counts and amount checksum match.
task
Load the four dirty files with no manual edit into typed tables members_t (members columns), orders_t(id, amt numeric(10,2), d date), readings_t and readings2_t (readings_bad columns). Counts and the amount checksum must match.