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.
Skills Required
- 6+ years of hands-on experience with Ab Initio GDE, Co>Operating System, Express>It, Conduct>It, and EME
- Strong proficiency writing and optimizing complex SQL queries in Oracle Database
- Strong working knowledge of UNIX or Linux operating systems
- Shell scripting experience with Bash and Korn shell
- Deep understanding of dimensional modeling, star and snowflake schemas, and enterprise data warehouse architectures
- Experience troubleshooting job failures, resolving performance bottlenecks, and conducting root-cause analysis in high-volume production environments
- Familiarity with CI/CD tools, Git version control, and agile software development methodologies
- Expertise with large language models including OpenAI, Gemini, Claude, Llama, and local or open-source models
- Hands-on Python experience for data ingestion and transformation
- Experience with cloud-native data platforms or migrating ETL workloads to modern data infrastructure
- Knowledge of data governance frameworks, metadata management, or data quality tooling
- Familiarity with project management or consulting approaches in technology delivery
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
