Ha! There are no general purpose tools--lots are a) overkill or b) not robust enough given your task but two general ones that have served me well (and of course lot of Python scripting for my domain-specific issues):<p>Refine (formally from ITA/Google, now open source)
IBM Watson Analytics - Don't knock it until you try it. Forget the 'analytics' bit but the ETL bit is pretty decent for getting through the basics
Data Brewery has a nice ETL library called Bubbles for Python [1]<p>Kiba [2] is a really nice library for ETL in Ruby<p>Hope this helps!<p>[1] <a href="http://bubbles.databrewery.org/" rel="nofollow">http://bubbles.databrewery.org/</a><p>[2] <a href="http://www.kiba-etl.org/" rel="nofollow">http://www.kiba-etl.org/</a>
If you are looking for commercial solution then try Informatica, otherwise the opensource soln are Pentaho Kettle and Python based <a href="http://bubbles.databrewery.org/" rel="nofollow">http://bubbles.databrewery.org/</a>