Informatica PC-IICS (Production Support)

Infosys; Hyderabad; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Infosys is seeking an Informatica Production Support Engineer to manage enterprise ETL/data integration systems in Hyderabad. The successful candidate will monitor, troubleshoot, and ensure smooth execution of data pipelines using Informatica PowerCenter and IICS.

The ideal applicant will have a Bachelor’s degree in Engineering or equivalent, strong SQL skills, and experience with data quality tools. This role offers an exciting opportunity to work with a dedicated team in a dynamic environment.

Qualifications

• Skilled in Informatica PowerCenter with mandatory hands-on experience.
• Strong SQL skills are essential.
• Hands-on experience with Informatica IICS is mandatory.

Responsibilities

• Support and maintain enterprise ETL/data integration systems.
• Monitor and troubleshoot data pipelines in production environments.
• Ensure timely execution of batch jobs and meet SLA commitments.

Skills

Informatica PowerCenter

PowerCenter (PC)

Informatica Intelligent Cloud Services (IICS)

SQL

Shell scripting

Education

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

Tools

Control-M

Autosys

ServiceNow

Jira

Job description

Educational Requirements

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

Service Line

Data Analytics Unit

Responsibilities

• We are looking for a skilled Informatica Production Support Engineer with expertise in PowerCenter (PC) and Informatica Intelligent Cloud Services (IICS) to support and maintain enterprise ETL/data integration systems.
• The ideal candidate will be responsible for monitoring, troubleshooting, and ensuring smooth execution of data pipelines in production environments.
• 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

Additional Responsibilities

• 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)
  • Operating Systems
  • Strong knowledge of UNIX/Linux
  • Experience with shell scripting (bash/ksh)

Preferred Qualifications

• Experience with Informatica IDQ (Data Quality)
• Exposure to cloud platforms (AWS / Azure / GCP)
• Informatica certifications (PC / IICS)
• Knowledge of CI/CD pipelines

Technical and Professional Requirements

• Primary skills: Informatica PC, IICS, Production Support

Preferred Skills

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