Job Description :
Minimum Qualifications:
Bachelor’s Degree or relevant technical certifications/experience
Strong Informatica experience with versions 9.5 and 10.2
Informatica BDM or ETL experience
Scope of Work:
Develop reusable transformations, mappings and mapplets using most transformations (expression, sequence generator, lookup, aggregator, joiner, normalizer, router, filter, rank, sorter, update strategy), Sessions, Worklets and Workflows
Conceptualize strategy and design the workflows execution to maintain data integrity
Design, develop and schedule Informatica workflows
Redesign ETL (existing workflows) execution to optimize performance
Perform SQL performance tuning and cut down application data refresh time through optimized schedule
Develop Jobs, Job Plans and Events to automate the Informatica workflows and Oracle jobs through UC4
Migrated all conventional schedules across the platforms to the unified scheduling UC4 tool
Create shell scripts to invoke Informatica workflows through PMCMD and Oracle jobs through UC4 scheduler
Lead Informatica version upgrade from version 9.5 to 10.2
Validate and remediate all the migrated objects to the latest version 10.2
Enable FTP process from the upstream applications to the new Informatica 10.2 server

Client : Confidential