ETL APP Development Engineer – Ab Initio Staff Engineer, Assistant Vice President

ETL App Development Engineer – Ab Initio Staff Engineer, Assistant Vice President

Discover your future at Citi. Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you'll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

We are looking for a skilled Data Engineer with strong experience in Ab Initio, ETL development, SQL, and scripting. The role involves designing, developing, and supporting robust data pipelines and solutions while collaborating closely with cross-functional teams. This position is ideal for engineers who are technically strong, analytical, and open to learning new technologies.

Key Responsibilities

• Design, develop, and maintain ETL solutions using Ab Initio
• Build and optimize complex SQL queries for data transformation and analysis
• Develop automation and support scripts using Unix/Shell or other scripting languages
• Perform data validation, performance tuning, and troubleshooting of ETL workflows
• Work with tools such as EME, Co-Op, ACE, BRE, Express IT/Query IT, and Control Center
• Collaborate with stakeholders to understand data requirements and deliver scalable solutions
• Adhere to best practices for data quality, performance, and security

Required Skills & Experience

• Strong hands-on experience with Ab Initio (ETL development)
• Good proficiency in SQL (intermediate to advanced level)
• Experience with scripting (Unix/Shell preferred)
• Solid understanding of ETL concepts and data warehousing principles

Good to Have

• Experience with Oracle / Hive
• Strong working knowledge of Unix/Linux environments
• Exposure to large-scale data platforms and enterprise ETL frameworks
• Familiarity with production support and scheduling tools

Additional Expectations

• Strong analytical and problem-solving skills
• Ability to work independently as well as in a team
• Open and eager to learn new technology stacks as business needs evolve

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.