Informatica PC-IICS (Production Support)

Production Support & Monitoring
Monitor daily ETL workflows, mappings, and jobs in PowerCenter and IICS
Ensure timely execution of batch jobs and meet SLA commitments
Perform initial triage and resolve production issues quickly
Incident & Problem Management
Troubleshoot failures in sessions, workflows, and integrations
Analyze logs and identify root causes for data issues
Work on incident management tools (ServiceNow, Jira)
Provide permanent fixes for recurring issues
Informatica PowerCenter (PC) Support
Support PowerCenter environments (10.x)
Monitor Repository Service, Integration Service
Debug session errors and optimize workflows
Perform deployment/migration across environments
IICS (Informatica Cloud) Support
Monitor IICS jobs, task flows, and mappings
Manage Secure Agent (installation, upgrades, troubleshooting)
Handle connectivity issues between cloud and on-prem systems
Support application integration and data integration pipelines
Data Validation & Quality Checks
Perform data validation and reconciliation
Ensure data accuracy, completeness, and consistency
Work with data quality tools if required (IDQ - optional)
Scheduling & Automation
Manage job scheduling tools:
Control-M / Autosys / Informatica Scheduler
Develop shell scripts for automation and monitoring
Ensure dependencies and workflows are executed correctly
Performance Optimization
Identify performance bottlenecks in workflows and mappings
Optimize queries and transformation logic
Tune sessions for better throughput
Database & Integration Support
Work closely with databases:
Oracle, SQL Server, DB2, etc.
Optimize SQL queries and connections
Handle source/target data issues
Required Skills & Qualifications
Core Skills
3-6 years of experience in Informatica Production Support
Hands-on experience in:
Informatica PowerCenter (mandatory)
Informatica IICS (mandatory)
Technical Skills
Strong understanding of:
Workflow/session configuration & debugging
ETL processes and data pipelines
Strong SQL skills (mandatory)
Knowledge of data warehousing concepts
IICS Components
Data Integration
Application Integration
Secure Agent
Taskflows
Tools & Platforms
Scheduling tools (Control-M / Autosys)
Incident management tools (ServiceNow / Jira)
Version control (Git - optional)

* Primary skills: Informatica PC, IICS & Production Support