I have added the details of solution in the below link.
Could you please mark the topic as resolved since the resolution has been provided? Kudos are also welcome :-)
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.