ETL Abinitio Developer

Citi; New York (NY); Hybrid; USD 16,000 - 23,000; Full time

Job summary

Citi in India is seeking an experienced ETL Ab Initio Developer to design and deliver enterprise-scale data integration solutions across global reporting and analytics. You will own end-to-end ETL development using Ab Initio and contribute to data quality and governance.

In this hybrid role, you will collaborate with stakeholders, data architects, and project managers to translate requirements into technical specifications, troubleshoot production issues, and support deployment across CI/CD

Qualifications

• 6+ years of hands-on Ab Initio GDE, Co>Operating System, Express>It, Conduct>It, and EME.
• Strong proficiency in Oracle SQL and complex queries.
• UNIX/Linux OS and shell scripting (Bash, Korn).
• Deep DW concepts, dimensional modeling, star/snowflake schemas.
• Ability to troubleshoot, optimize, and perform root-cause analysis.
• Familiarity with CI/CD, Git, and Agile software methods.

Responsibilities

• Design, develop, and tune scalable ETL processes using Ab Initio.
• Build data integration between source systems and reporting platforms.
• Write and tune SQL queries against Oracle and relational databases.
• Drive data governance and data quality practices across the landscape.
• Oversee code migration, version control, and environment setups (EME).
• Translate requirements into implementable technical specifications.
• Investigate, analyse, and resolve L2 production issues.
• Manage the full data application development lifecycle from planning to production support.

Skills

Ab Initio GDE

Oracle SQL

UNIX/Linux

Data Warehousing

CI/CD

Tools

Git

CI/CD tools

Oracle SQL tools

Job description

ETL Abinitio Developer

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of approximately 219,000 dedicated people from around the globe. At Citi, you'll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

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

Location(s):

Chennai, Tamil Nadu, India, Pune, Maharashtra, India

Job Type:

Hybrid

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.