- 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
02Requirements
- 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) .
