Informatica PowerCenter Application Support

About the Role

Provide L2/L3 production support for Informatica PowerCenter applications and ETL workflows.

Key Responsibilities

• Monitor batch jobs, workflows, sessions, and data pipelines to ensure successful execution.
• Analyze and resolve production incidents, service requests, and problem tickets within agreed SLAs.
• Troubleshoot ETL failures, performance issues, and data discrepancies.
• Perform root cause analysis (RCA) and implement preventive measures.
• Work closely with development, database, infrastructure, and business teams to resolve issues.
• Support deployment activities and application releases.
• Monitor data loads and ensure data accuracy, integrity, and completeness.
• Create and maintain support documentation, SOPs, and knowledge base articles.
• Participate in on-call support and weekend release activities when required.

Requirements & Tech Stack

• Strong experience in Informatica PowerCenter administration and support.
• Good knowledge of ETL concepts, mappings, workflows, sessions, and repositories.
• Strong SQL skills with databases such as Oracle, SQL Server, Teradata, or PostgreSQL.
• Experience with Unix/Linux commands and shell scripting.
• Knowledge of incident, problem, and change management processes.
• Experience with ticketing tools like ServiceNow, Remedy, or Jira.
• Understanding of production support processes and SLA management.
• Excellent troubleshooting and analytical skills.