The Scenario
A small business receives a daily CSV export from their point-of-sale system. They want to load this data into a PostgreSQL database so they can query it with SQL instead of opening Excel every morning.
The Brief
Document the complete ETL flow. You do not need to write production code — describe each step clearly enough that a junior developer could implement it.
Deliverables
- Extract: Where the CSV comes from, how it is retrieved, and what validation you do before processing
- Transform: The specific cleaning and transformation steps (date parsing, null handling, type casting)
- Load: The database table schema and the insertion strategy (truncate-and-reload vs upsert)
Submission Guidance
Think about what happens when the CSV is missing, empty, or has a new column that was not there yesterday.
Submit Your Work
Your submission is graded against the rubric on the right. If you pass, you get a public Badge URL you can share on LinkedIn. There is no draft save, so work offline first and paste your finished response here.