Talend Data Fabric

Pros

Easy to use
No need to "hard" code in order to have your job done
Easy to integrate with many technologies of BDD (MySQL, noSql and many more)
Easy to integrate with many kind of files (csv, xls, xlsx)
There's a lot of forum with people that's willing to help if you know how to ask

Cons

There's a lot of components, in order to manage everything in this software you will have to do to many formations.

Pros

1. Open source;
2. Full of transformations to support different scenarios;
3. Convenient designer/java code switching capability for troubleshooting;
4. Integrated with java, maven, nexus;
5. Integration support with Big Data and MDM.

Cons

1. When project is big, the designer is becoming slower and slower;
2. The exception handling not convenient. You can either let go the exception or stop the process, or using external controller to resume the applications. But you cannot customize the try catch block of the exception itself;
3. Nexus integration is buggy on talend 7.

Pros

1. Our organization is using it to transform and integrate file data into redshift. It is supporting multiple data connectors as components
2. We use to load the transformed data into reporting tables within less time

Cons

1. It is only an ETL tool and reporting is not supported as of today
2. It has to be deployed over the server

Pros

Ease of learning. Development can be done by writing a few lines of code or in any case with very basic java knowledge.
Graphically it is possible to write writes or readings in the database, writings or readings on file.
Talend already provides default connectors with other systems. Such as Google Cloud, Excel, MySql, Oracle and many others.

Cons

The version for mac is horrible. Sometimes you have to use "Ctrl" sometimes "Cmd" is really badly done.
In my experiences the speed of learning clashes with the consumption of resources and the slowness of the interfaces.
An interface made in pure Java requires more time to implement but is definitely more performing.

Pros

Talend Data Integration has a great set of features. Plus, the company behind the software has earned one of the best reputations and most respect in the realm of data integration and big data. The software user interface is very good to great and takes a short time to explore and get used to it. There is an online community for discussing with other users, or plenty of consultants and developers available if you want to outsource that work. Based on java, it's industrial strength and and army of java pros is available if and when you want.

Cons

Talend is a Windows desktop app running on top of the Eclipse development environment, so you need a several hundred MB of ram and disk space to run the application comfortably.