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):
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
If you are looking for commercial solution then try Informatica, otherwise the opensource soln are Pentaho Kettle and Python based http://bubbles.databrewery.org/
9 comments
[ 5.2 ms ] story [ 39.6 ms ] threadRefine (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
Kiba [2] is a really nice library for ETL in Ruby
Hope this helps!
[1] http://bubbles.databrewery.org/
[2] http://www.kiba-etl.org/