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

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.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

 

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.