Experience
2 - 5 yrs
Salary (CTC)
₹4.6L - ₹5.3L
Job Location
Hyderabad, India
Vacancy
1
Designation
Production Support Engineer
Job Type
Not specified
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)
No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.