ETL Abinitio Developer

Citi; Chennai District; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Citi is seeking an ETL Developer to design and deliver enterprise-scale data integration solutions for a global financial institution. You will own end-to-end ETL development using Ab Initio, setting standards for data quality and governance, and collaborating with stakeholders to translate complex requirements into production-grade pipelines.

This high-impact role requires strong Ab Initio, SQL, and UNIX/Linux skills, with responsibility for production support and scalable data architectures.

Qualifications

• 6+ years of hands-on Ab Initio with GDE, Co>Operating System, Express>It, Conduct>It, and EME.
• Strong proficiency in writing and optimizing SQL for Oracle.
• Unix/Linux experience and shell scripting (Bash, Korn).
• Deep understanding of dimensional modeling, star/snowflake schemas, and data warehousing.
• Troubleshoot job failures, resolve production bottlenecks, and perform root-cause analysis in high-volume environments.
• Familiarity with CI/CD, Git, and Agile software development methodologies.

Responsibilities

• Design, develop, and tune scalable ETL processes using Ab Initio — including GDE, EME, Co>Operating System, Conduct>It, and Continuous Flows — to ensure reliable data integration.
• Build and deploy robust data integration solutions between source systems and reporting platforms.
• Write and tune SQL/PLSQL queries for Oracle databases to support data processing.
• Promote data governance and data quality across the integration landscape.
• Oversee code migration, version control, and environment setups including sandboxes and permissions.
• Translate business requirements into technical specs and implement them.
• Investigate, analyze, and resolve L2 production issues to maintain pipeline stability.
• Manage end-to-end data application development lifecycle from planning to production support.

Skills

Core Ab Initio Expertise

SQL

UNIX/Linux

Data Warehousing

CI/CD

Git

Agile

Tools

Ab Initio GDE

Co>Operating System

Express>It

Conduct>It

EME

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.

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.