Required Experience:
- Minimum of 5 years of hands-on Experience with the Informatica PowerCenter and CDC PowerExchange
- Experience with installation and configuration of Informatica
- Hands-on experience with application upgrade, migration and decommissioning
- Minimum of 5 years of experience with Informatica performance tuning
- Minimum of 5 years of experience with Oracle, Teradata, RedShift, SQL Server relational database platforms
- Expertise in AWS infrastructure (AWS Data Pipelines, DMS, Glue, Step Functions) is preferred
Description of duties:
- Installation and configuration of Informatica Power Center, Informatica MDM, and other related products in DEV/QA/UAT/Production environments
- Managing user access by defining roles and assigning privileges per compliance requirements
- Code migration between environments using deployment groups.
- Provide subject matter expertise on the platform and its tools and maintain Enterprise license compliance and interface with Informatica and Vendor Management to resolve any compliance issues.
- Work with audit/compliance teams to provide evidence related to user access privileges.
- Troubleshoot issues related to repository databases, job failures, software bugs, and performance bottlenecks working with Informatica support and cross-functional teams like DBA, Unix Server Administrator, Networking team and drive them to resolution.
- Assist with the planning and building of roadmaps for the future of the Informatica data integration platform and influence IT with the latest Informatica products, best practices, and improve the overall state of Informatica.
- Identify and address gaps in infrastructure such as storage needs, processing needs, computing needs and work with respective teams to bridge the gaps identified.
- Ensure the integrity, availability, reliability, security, and performance of Informatica platforms, tools, and services.