Dedicated ETL Developer, with over 5+ years of experience in Talend Open Studio, Ab-initio, Oracle, Linux, MQ Explorer and Teradata applications with an excellent reputation for resolving problems, improving client satisfaction and driving overall improvements.
Overview
6
6
years of professional experience
1
1
Certification
Work History
ETL Developer - Talend Open Studio/Oracle Developer
Fujifilm Data Management Solutions
04.2022 - Current
Working as an ETL Developer with Talend Open Studio tool and Oracle as Database
Developed job using talend open studio for hubload, email generation, sms generation job
Mostly working with banking clients such as ANZ, wespac, also handled clients such as Energy Australia
The main concept of job is to generate sms, email to client's customers for any alerts which is requested
Testing the codes with different scenario till UAT, and deployed them using release notes in PROD
Also having experience in ansible scripts for automated deployment in PROD
The jobs are usually called-by broker queues, using MQ explorer
Created scripts for running also cleanup script for log rotations in PROD
Also working in reporting application job for report creation as per client requirement
Having experience in xml files also developed a job for creating automatic hubxml for input to our hubload
Participated in all standups, client call and scrum call for understanding the business needs and background.
ETL Developer- Abinitio/Teradata Developer
Tata Consultancy Service
10.2018 - 12.2021
Worked on SAS to Ab-initio Conversion for Tableau Reporting for data analytics perspective
Developed ETL graphs using Abinitio GDE 3.5.2 to extract data from source databases like Teradata
Used various components, such as rollup, reformat, joins, files, etc., to create GDE
The central concept of the graphs is to create a replicate of SAS code but with a 1-day delay in data for reporting purposes
Created shell scripting
Ksh for job scheduling
Testing the codes with a few test cases in a lower environment and deployed to PROD using CR
Created Bteq scripts for loading Teradata tables using fast load and mload
Participated in Client meetings and Scrum calls to understand the business needs
Worked on a few complicated requirements and delivered the products with zero defects
Experienced in scheduling and running Autosys Jobs
Experience using HP ALM and Jira
Expertise in reviewing requirements, deriving and executing Test Cases, developing and maintaining test documents like Test plans, Test Summary Reports, and Test scripts according to the business specification given
Experienced in identifying, resolving, and tracking defects
Also handled the resolution of production defects
Status reporting to the stakeholders and higher management
Strong experience in Unit Testing, System Testing, Integration Testing, UAT testing, and Regression Testing
Experienced in software design, development, and unit testing
Proven ability to have independent and effective communication with stakeholders
Created a Daily status tracking sheet to report the daily status to Team Lead
Logging defects and tracking them to closure.
DWH/EAP ETL Developer DataStage/Oracle Developer
Tata Consultancy Service - CITI Bank APAC Region
12.2018 - 04.2020
Created Functional ids for template jobs for automated runs
Developed a few jobs using DataStage Designer 11.3 to extract data from different sources like Teradata nd Oracle
Created Autosys JILL for an automated run in the PROD environment
Worked on requirements like implementing CML (Citi Markup Language) for Talend Migration and DWH to EAP conversion for the India Region
Experienced in scheduling and running Autosys Jobs
Been a part of a few complicated requirements and delivered products with zero defects, increasing customer satisfaction
Performed data analysis, documentation, testing, implementation, and user support for platform transitions
Experienced in software design, development, and unit testing
Proven ability to have independent and effective communication with stakeholders.
Education
B.Tech in Electrical and Electronics Engineering -