Informatica ETL Migration Lead

Primary Skills
Lead the Informatica Version upgrade project from offshore
Analyze the existing ETL inventory and finalize the upgrade strategy based on their complexity
Handson experience in upgrading of Informatica PowerCenter from a lower version to a higher version
Ability to plan indetail the steps required to upgrade Informatica from version 100 to 1053
Well versed in troubleshooting the issues arising in Informatica due to various reasons and specially after the upgrade during the testing phase
Monitors the onetime Informatica upgrade process and reviews all deliverables of the entire upgrade team
Should have experience on PowerCenter tools like Informatica Designer Repository Manager Workflow Manager and Workflow Monitor
Extensively used all the Transformations like Source Qualifier Aggregator Filter Joiner Update Strategy Lookups Expression Router Sequence Generator
Reviews of all deliverables of the entire upgrade team
Excellent communication skills and ability to communicate with various stakeholders of project and attend all the governance calls to update client with the progress
Drive the golive of each environment after successful upgrade and testing
Demonstrate problem solving initiative and technical innovation
Oracle 19c knowledge will be a plus
Lead a team of ETL developers
Secondary Skills
Experience in writing Shell scripts
Experience of working with Insurance Domain
Soft Skills
Good communication
Presentation skills
Team player
Strong ability to work with client stakeholders
Skills
Mandatory Skills : IICS - IDMC,Informatica DVO, Informatica PowerCenter, ANSI-SQL,Dimensional Data Modeling, User Acceptance Testing, Selenium Testing Automation, UFT Testing Automation, API/Microservices RestAssured Testing, Functional/System Testing, Integration/Interface Testing, IOT Testing, SQL & Database testing, Performance Testing -Execution (Baseline, Load, Endurance, Stress, Volume, Network, DR, Failover, Spike, Saas based/COTS),RTM -Testing, Test Design and Execution -Testing, Test Reports and Dashboards -Testing, Jmeter, Blazemeter -Performance Testing