ETL L2 Support Engineer

Experience : 3-5 Years

Employment Type : Full-time

Job Overview :

We are seeking an ETL L2 Support Engineer with 3-5 years of production support experience in Informatica, Python, and AWS technologies.

The ideal candidate will possess a strong understanding of Informatica architecture, hands-on debugging expertise, and proficiency in various ETL transformations and data sources.

This role requires robust SQL/PL-SQL knowledge, Unix scripting skills, and experience with incident/problem management in a 24x7 support environment, including the ability to drive critical issue resolution and communicate effectively with stakeholders.

Job Responsibilities :

- Provide 24x7 production support for applications utilizing Informatica, Python, and AWS technologies.

- Possess a strong understanding of Informatica, Python, and AWS environments, enabling efficient handling of batch recoveries and continuous batch support.

- Assess and recommend solutions for permanent fixes to enhance application stability and resiliency.

- Capably handle production incident bridge calls for P1 and high-priority P2 incidents, driving quick resolution.

- Demonstrate strong analytical capabilities for independent ticket analysis and resolution.

- Manage Incident Management, Problem Management, and Change Management processes effectively.

- Conduct thorough Root Cause Analysis (RCA), document issues and problems clearly in emails, and communicate effectively to all stakeholders and cross-functional teams.

- Lead production issue bridges, collaborating across teams to collate impacts and disseminate leadership communications.

- Propose innovative solutions to perform complex troubleshooting.

- Identify areas for improvement and re-engineering scope within existing processes and applications.

- Mentor interns and new team members, assisting them in resolving technical issues.

Required Skills & Qualifications :

- 3-5 years of production support experience on Informatica, Python, and AWS Technologies and applications.

- Strong understanding and technical knowledge of Informatica architecture and client components such as Workflow Manager, Mapping Designer, Workflow Monitor, and Repo Manager.

- Excellent knowledge of AWS and Python concepts.

- Hands-on expertise in debugging Informatica ETL Mappings to efficiently narrow down issues.

- Hands-on experience in ETL transformations such as Lookup, Joiners, Source Qualifiers, and Normalizers.

- Hands-on experience in dealing with various types of sources, including Flat files, Mainframes, XML files, and Databases.

- Experience in the AWS environment, specifically with Data Pipelines, RDS, and Reporting tools.

- Hands-on experience in Unix scripting and file operations.

- Strong knowledge of SQL/PL-SQL and Oracle Databases, with the ability to debug complex queries.

- Good understanding of scheduling tools such as TWS, TIDAL, or others.

- At least 2 years of experience working with ServiceNow for application incident management and problem management in a 24x7 model.

- Strong communication skills, both written and verbal, with the ability to follow established processes.

Preferred Qualifications :

- Experience working with US Clients and Business Partners.

- Exposure to the BFSI (Banking, Financial Services, and Insurance) domain.

- Experience in mainframe technologies is a plus.