Requires Hybrid work mode, 2-3 days at Mississauga, Ontario

This is a senior developer position requiring excellent coding skills in Talend. The main responsibility will be tasks related to development, project testing, including working with business users and technology groups , support of the deployment of the coding changes in production and post-production support. This is a high profile project and will require a strong focus on coding, design and communication skills and the ability to deliver in demanding and challenging time schedules.

Key Responsibilities:

• 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

• Knowledge in Database

• Experience in performance tuning.

Job Skills

• Extensive experience development experience in Talend is a must.

• Expertise in a wide range of requirement elicitation and documentation techniques, using a range of methodologies

• Extensive experience of documenting use cases, functional specifications or similar

• Experience with system and user acceptance testing, including test management tools

• Experience of business process modelling and tools

• Strong communications skills

• Analytical and problem solver

• Familiar with all phases of the SDLC

• Able to work as part of a virtual team in a culturally diverse background

Experience

• Excellent degree in technology disciplines

• Extensive years (5+) of experience in business analysis attained with in financial services

• Experience of business process improvements and automation through the use of technology will be extremely advantageous