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.