Remote Support IT Engineer
Job Description
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
