Informatica Support

1RoleProduction support engineer 2Required Technical Skill SetETL and Cloud Tools PowerCenter Informatica, IICS, CA7 scheduler/Autosys, ServiceNow/any other ticketing tool, Linux basics, Databases Oracle, Teradata, SQL Server.3No of Requirements74Desired Experience Range3-7 years5Location of Requirement Hyderabad6IOU-DetailBFSI US East Banking PA&MI

Desired Competencies (Technical/Behavioral Competency)Must-Have

• Good hands-on experience in Handling incidents (P1, P2, P3, P4) and issues related to ETL workflow failures, ability to categorize the issues as source, connectivity, design, scheduling, data issues
• Knowledge of Linux basics and job scheduling tools. Basic understanding of ETL concepts and data warehousing
• Familiarity with SQL for querying and troubleshooting

Good-to-Have

• ITIL, SNOW, Dynatrace
  

Responsibility of / Expectations from the Role

1. Monitor and manage ETL jobs and data pipelines using tools like Informatica and IICS
2. Identify and escalate abended jobs to technical expert teams, follow the instructions to resolve the issues. Categorize, log and troubleshoot the issues as source system, connectivity (DB/network), design, scheduling, bad data or performance issues
3. Ability to analyze SQL queries in case of job failures with SQL issues
4. Perform job restarts, holds, releases and emergency job run as needed
5. Perform timely communication and coordination with L2/L3 and all the associated Stakeholders and Change teams for unresolved issues
6. Provide the first level of support for user-related issues via ServiceNow ticketing system
7. Ability to work Independently as well as a part of team
8. Contribute to Knowledge base updates and areas for process improvements
9. Support 24x7
10. Strong ITIL Skills on Incident Management, Problem Management, Change Management