Informatica Support Engineer (6-8 yrs)

Strong Informatica Support Engineer with a solid background in ETL support, Unix shell scripting, and PL/SQL (Oracle/Database). The ideal candidate must have experience working in an ITSM-driven production support environment and be willing to work in a 24x7 rotational shift model.

The role involves troubleshooting Informatica workflows, debugging data issues, handling batch failures, and optimizing ETL performance. The candidate should be proactive, analytical, and capable of handling critical production incidents effectively.

Key Responsibilities :

- ETL / Informatica Support

- Provide L2/L3 support for Informatica PowerCenter, handling job failures, debugging, and performance tuning.

- Monitor, troubleshoot, and resolve batch job failures, ensuring timely data processing and availability.

- Work on incident, problem, and change management processes in an ITSM-driven environment.

- Debug Informatica workflows, mappings, and sessions using logs, error messages, and data flow analysis.

- Optimize Informatica jobs for performance improvement and ensure SLA adherence.

- Support real-time and batch data processing across enterprise data warehouses.

- Unix & Shell Scripting

- Analyze and modify Unix shell scripts used in ETL workflows.

- Manage and automate batch job execution using shell scripting.

- Perform log analysis and job monitoring in a Unix/Linux environment.

- PL/SQL & Oracle Database

- Debug SQL queries, stored procedures, and database jobs running on Oracle.

- Perform data validation, reconciliation, and query optimization.

- Collaborate with database teams for indexing, partitioning, and query tuning.

- Handle data discrepancies, missing records, and corruption issues efficiently.

- ITSM & Production Support

- Work in an ITIL/ITSM-based support model handling incidents, problems, and changes.

- Participate in root cause analysis (RCA) and provide permanent fixes for recurring issues.

- Ensure timely resolution of tickets in accordance with SLAs.

- Create and maintain runbooks, SOPs, and knowledge base articles for L1/L2 teams.

- Shift & On-Call Support

- Work in a 24x7 rotational shift environment, ensuring uninterrupted support.

- Handle critical P1/P2 incidents and escalate to appropriate teams as required.

- Provide on-call support as per the roster, including weekends and holidays when required.