🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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 - 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 - Solid 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 Technical Requirements: - Primary skills Informatica PC IICS Production Support 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) .