Use Pentaho's open source data integration tool (Kettle) to create Extract-Transform-Load (ETL) processes to update a Socrata open data portal. Documentation is available at http://open-data-etl-utility-kit.readthedocs.io/en/stable
Admittedly, it's hard to define a solid unit testing framework, but should have some tests to do some regression testing. This should be done in Windows (Appveyor) and Linux (Travis CI) builds.
[ ] Compare outputs of ETL utilities (e.g., Log/A_DatasetLogs, Log/A_ETLRuntimes) to ensure it outputs the "correct" answers
[ ] Ensure four-by-four checks work with ETL utilites
Admittedly, it's hard to define a solid unit testing framework, but should have some tests to do some regression testing. This should be done in Windows (Appveyor) and Linux (Travis CI) builds.