Aug 2021 – Present · 4 yrs 7 mos · Bangalore Urban, Karnataka, India · On-site

•  Responsible for the development of ERW (requirements) in BFSI unit - Banking, Finance, Insurance and Retail.
•  Worked as an ETL Developer in an Enterprise Data Warehouse high visibility project for one of the top 5 banks of USA.
•  Involved in developing complex workflows and extracted data from various sources and loaded them into Teradata relational tables using SCD strategies.
•  Performed peer review, unit testing and created test cases for end-to-end delivery.
•  Created design documents and was involved in planning project deliverables for successful delivery.
•  Worked on complex ETL requirements and had hands-on various transformations like Expression, Look Up, Joiner, Router, Filter, Source Qualifier, Sequence Generator, Rank etc.
•  Hands-on expertise in Informatica PowerCenter & PowerExchange 10.2/10.5 with strong business understanding.
•  Development of new/existing mapping, sessions, workflows of ETL pipelines as per JIRA-based requirements.
•  Worked on various data sources like Mainframe, Flat Files, Relational, Oracle, Toad, MDM and Hive (BDH).
•  Worked on Archive logic workflows for better space consumption & performance tuning.
•  Incident Management Request for connectors like creation, updating and password vaulted in CyberArk AAM account.
•  Testing performed: Unit testing, Component testing, Regression testing, DR testing, SIT & UDV testing, UAT, UTD, End-to-End testing.
•  Worked on production failure fixes and component packaging.