ETL Abinitio Developer

Citi is looking for a ETL Developer to design and deliver enterprise-scale data integration solutions that keep critical reporting and analytics capabilities running reliably across a global financial institution. In this role, you will take ownership of end-to-end ETL development using Ab Initio, set the standard for data quality and governance practices, and work directly with stakeholders across the business to translate complex requirements into production-grade pipelines. This is a high-impact position for a technical specialist who wants to solve meaningful data challenges at scale within a collaborative, performance-driven environment.

Responsibilities

• Design, develop, and tune highly scalable ETL processes using Ab Initio — including GDE, EME, Co>Operating System, Conduct>IT, and Continuous Flows — to ensure reliable and efficient data integration across the organization.
• Build and deploy robust data integration solutions that streamline data flows between source systems and downstream reporting and analytics platforms.
• Write and tune advanced SQL and PL/SQL queries against Oracle and relational databases to support accurate and performant data processing.
• Drive data governance and data quality best practices across the integration landscape, ensuring accuracy, consistency, and reliability of data assets.
• Oversee code migration, version control, and environment infrastructure setups including private and public sandboxes and EME permissions management.
• Translate functional requirements from business stakeholders, data architects, and project managers into clear and implementable technical specifications.
• Investigate, analyse, and resolve L2 production issues, maintaining the stability and continuity of live data pipelines.
• Manage the full data application development lifecycle — from technical planning and feasibility assessment through to testing, implementation, and ongoing production support.

Required qualifications & skills

• * Core Ab Initio Expertise: 6+ years of hands-on experience with Ab Initio GDE, Co>Operating System, Express>It, Conduct>It, and EME.

  * Database & SQL: Strong proficiency in writing and optimizing complex SQL queries in Oracle DB.

  * OS & Scripting: Strong working knowledge of UNIX/Linux operating systems and shell scripting (Bash, Korn shell).

  * Data Warehousing Concepts: Deep understanding of dimensional modeling, star/snowflake schemas, and enterprise data warehouse architectures.

  * Problem Solving: Demonstrated ability to troubleshoot job failures, resolve performance bottlenecks, and manage root-cause analysis in high-volume production environments.

• Familiarity with CI/CD tools, version control (Git), and agile software development methodologies.

Beneficial skills & qualifications

• Expertise in Large Language Models (LLMs) including OpenAI, Gemini, Claude, Llama, and local/open source models
• Hands-on experience in Python for data ingestion, transformation.
• Experience working with cloud-native data platforms or migrating ETL workloads from on-premise environments to modern data infrastructure.
• Knowledge of data governance frameworks, metadata management practices, or data quality tooling within large-scale enterprise environments.
• Familiarity with project management or consulting approaches applied in a technology delivery context.

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

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.