Informatica PC-IICS (Production Support)

Production Support & Monitoring:

Monitor daily ETL workflows, mappings, and jobs in Power Center 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 (Service Now, Jira)
Provide permanent fixes for recurring issues

Informatica Power Center (PC) Support

Support Power Center 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 Power Center (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 (Service Now / Jira)
Version control (Git – optional)

• Primary skills: Informatica PC, IICS & Production Support

Education: MCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech

• Preferred skills: Foundational->Maintenance and Production Support process->Support Process
• Transition,Technology->Data Management
• Data Integration->Informatica->Informatica
• Informatica Power Center,Technology->Data on Cloud
• Datastore->Cloud based Integration Platforms->Informatica Intelligent Cloud services(IICS)