Translate functional requirements into technical design.
Recommend design alternatives for data ingestion from variety of sources into different types of target databases.
Design and develop data integration / ETL jobs using Talend Data Integration (DI)
Development of complex code to build business rules to load data into target systems using various components in Talend DI
Create Talend jobs (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle, SQL Server to different types of target databases
Developing and handling of complex ETL flows like slowly changing dimension (SCD) Type1, Type 2, Type 3 to capture the changes.
Parameterization and exporting of Talend jobs to be executed in Windows/UNIX environments.
Strong knowledge in TalenD enterprise edition.
Strong knowledge on the components like Tmap,tjoin,tFilterrows,tAggregaterow,tSortrow,tflowtoiterate,file input and output components, database input and output components,tfilelist,tjava,tjavarow,tjavaflex,tsystem,tdie,tdatabaseconnection,buffer and hash components, tRunjob, joblets.
interaction with client for requirement gathering.
Knowledge on Jira will be an added advantage.
Knowledge in Unix for deployments and running Talend jobs