Informatica Powercenter is a good ETL tool. Support extraction, transform and load the data to different targets from heterogeneous sources. It is a very reliable tool for data engineers to load data into data warehouses.

It has a bit of a learning curve but once that is passed the tool becomes easy to use. As a data engineer, it is very useful in mapping out the pipeline and flow of data and visualizing it with the appropriate objects associated with it.