This is a pretty good article about tools to automate the ETL development process. Here is a list of tools covered:
- AnalytixDS Mapping Manager
- Varigence MIST (leveraging the open source BIML)
- Dimodelo Architect
- Wherescape RED
I am quiet impressed with the BIReady. However, they do not imply you could close your eyes when doing your ETL. You still need to understand what these tools are doing so you can maintain your data. Check them out if you are interested.
Reference: Is ETL Development doomed?