Experience Senior ETL Developer (Talend) Noida TCS (WBA) 11/2021 – Present Walgreens Boots Alliance (WBA) is a Trusted, Global Innovator in Retail Pharmacy through dispensing medicines, improving access to a wide range of health services.
Participated in all phases of development lifecycle with extensive involvement in discovery, design meetings, functional and technical walkthroughs.
Used ETL methodologies and best practices to create Talend ETL jobs using tMap, tJoin, tReplicate, tParallelize, tAggregate, tLogcatcher, tRunjob etc., followed and enhanced programming and naming standards.
Design and implemented ETL for data load from heterogeneous sources to Oracle and SQL server as target databases and for fact and slowly changing dimensions SCD type 1, SCD type 2 and incremental loading.
Migration of 30+ Talend jobs which were supporting on premise oracle systems to connect with Oracle Cloud using Talend 7.3.1. Used tParallelize component and multi thread execution option to run subjobs in parallel which increased the performance of job by 17%.
Involved in writing SQL queries and use joins to access data from Oracle and SQL server DB.
Integrated java code inside talend jobs by using components like tJavarow, tJava, tJavaflex.
Created context variables and groups to run talend jobs in different environments.