Citi—ETL Abinitio Developer

Job description

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.