How to choose the best ETL tool?

Modern data warehousing companies are switching to ETL, and there are dozens of tool’s with capabilities but how to choose the best one?

Which tool is capable of using SQL or any other scripting language to perform data transformations and supports multiple data-sources.