Pacific Data Integrators
Website:
pacificdataintegrators.com
Job details:
Informatica IDMC Support Engineer
Remote
Position Overview
We are seeking 2 experienced Informatica IDMC Support Engineers to join our offshore managed services team in India. This role focuses on overnight production support for enterprise data integration workloads.
Shift: Thursday–Monday, 8:30 AM – 8:30 PM IST (8-hour shifts)
Role Summary
This position is primarily responsible for production monitoring, incident response, and ETL troubleshooting, with limited involvement in development and enhancements.
Key Responsibilities
Production Monitoring & Incident Support
- Monitor 100+ concurrent IDMC/PowerCenter jobs
- Identify and resolve job failures, performance issues, and data anomalies
- Perform real-time troubleshooting and debugging of ETL processes
- Execute job restarts, maintenance tasks, and routine fixes
- Respond to incidents within defined SLAs
- Document incidents with detailed root cause analysis
ETL Development & Enhancements (Limited Scope)
- Develop and modify simple to medium complexity mappings
- Update workflows and configurations
- Maintain technical documentation
Required Skills & Qualifications
- 5+ years Informatica PowerCenter (v9.x/10.x)
- 3+ years PowerExchange for Mainframe
- Strong experience with SQL Server (query optimization, performance tuning)
- Proven ability to troubleshoot ETL jobs in production environments
- Experience with session failures, performance issues, and data anomalies
- Knowledge of mainframe data (VSAM, sequential files, copybooks, EBCDIC/ASCII, JCL basics)
- Strong log analysis and debugging skills
- Solid understanding of ETL design patterns and best practices
- Bachelor’s degree in Computer Science, IT, or related field
- Strong written and verbal communication skills
- Ability to work independently in overnight/on-call support environments
Preferred Skills
- Informatica IDMC (Cloud) experience
- Unix/Linux shell scripting
- Experience with Oracle, DB2, SAP sources
- Performance tuning with large data volumes
Key Competencies
- Strong analytical and problem-solving skills
- Ability to diagnose and resolve issues under pressure
- Quick response and decision-making ability
- Effective escalation judgment
- Clear and concise communication
SLA Expectations
- P1 (Critical): 15-minute response, 2-hour resolution/escalation
- P2 (High): 30-minute response, 4-hour resolution/escalation
- P3 (Medium): 1-hour response, next business day resolution
- P4 (Low): 2-hour response, scheduled resolution
Click on Apply to know more.