Job description
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.