Informatica PC + IICS Production Support

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. - Key Responsibilities - 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)