Description

Build and maintain complex ETL pipelines using Ab Initio in a large-scale data environment.

Responsibilities

• Develop, debug, and troubleshoot Ab Initio graphs, including deployment architectures, pset, and AI objects.
• Execute source-to-target ETL mappings and perform deep data investigation and analysis.
• Manage batch processing, delta processing, and data capturing for large volumes of data.
• Validate UAT results, identify technical issues, and manage stakeholder communication.
• Write and optimize complex SQL queries and PL/SQL code.

Required Skills

• 5+ years of experience in Ab Initio development.
• Proficiency with ETL processes, Hadoop, and Hive.
• Strong SQL and Oracle skills, including required PL/SQL experience.
• Hands-on experience with ExpressIT.
• Solid UNIX shell scripting and Python programming skills.
• Experience working in Unix environments.
• Ability to handle large-scale data integration and processing.

Preferred Skills

• Prior work experience within the Banking or Finance industry.

Key Skills

Education

ANY GRADUATE