•
Spearheaded design and development of mappings, mapplets, sessions, and workflows for efficient data loading from source to target database utilizing Informatica Power Center.
•
Transformed legacy data into Staging Area and populated target database through ETL process utilizing Informatica Power Center.
•
Participated in ETL process within development and production environments.
•
Address issues and remediation steps efficiently and promptly.
•
Conduct troubleshooting analysis and resolve critical application and batch process issues.
•
Collaborate with vendors to diagnose and rectify issues
•
Support the Client Reporting Production Environment as a first priority.
•
Utilize Automation Scheduling tool, such as Autosys, for efficient task management.
•
Utilized Informatica Data Quality to address customer address-related issues.
•
Utilized Informatica On Demand to primarily import data from Salesforce.
•
Sourced data from multiple channels, including Flat files and Oracle, and integrated it into target systems utilizing Informatica 9.6.1/10.2.
•
Proficiency in constructing snow pipe.
•
Proficiency in Snowflake virtual warehouse.
•
Managed Slowly Changing Dimensions to ensure comprehensive historical data maintenance.
•
Developed new mappings and revised existing mappings based on updates in Business Logic.
•
Compile status report and engage with Business and Technical leads during daily status call.
•
Developing documents related to designs and technical specifications.