Much of my current work is supporting a large data warehouse in the energy industry. Most of the ETL code is SQL. I hate it but I know that there's no good alte

Much of my current work is supporting a large data warehouse in the energy industry. Most of the ETL code is SQL. I hate it but I know that there's no good alternative. Lots of the ETL stored procs are >1000 lines of code. There is lots of duplication - of code and data. There is no testing. There is little documentation.