ETL Abinitio Developer

Citigroup Inc.; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Citi in Chennai is seeking an ETL Developer to design and deliver enterprise-scale data integration solutions and own end-to-end ETL development using Ab Initio. You will set data quality standards and collaborate with stakeholders to convert complex requirements into production-grade pipelines.

Responsibilities include designing scalable ETL processes with Ab Initio, building robust data integration solutions, and tuning SQL for Oracle.

Qualifications

• 6+ years of hands-on Ab Initio experience with GDE, Co>Operating System, Express>It, Conduct>It, and EME.
• Strong SQL proficiency in Oracle DB.
• UNIX/Linux OS and shell scripting (Bash, Korn).
• Deep understanding of dimensional modeling and star/snowflake schemas in data warehousing.
• Proven ability to troubleshoot job failures and performance bottlenecks in high-volume production environments.
• Familiarity with CI/CD tools and version control (Git) in agile environments.

Responsibilities

• Design, develop and tune scalable ETL processes using Ab Initio to ensure reliable data integration.
• Build and deploy data integration solutions linking source systems to reporting platforms.
• Write and tune SQL/PLSQL for Oracle and relational databases.
• Drive data governance and data quality across the integration landscape.
• Oversee code migration, version control and environment setups (sandboxes, EME permissions).
• Translate business requirements into technical specifications for pipelines.
• Investigate and resolve L2 production issues ensuring data pipeline stability.
• Manage full data application development lifecycle from planning to production support.

Skills

Ab Initio GDE

Co>Operating System

Express>It

Conduct>It

EME

Oracle SQL

UNIX/Linux

Shell scripting

Dimensional modeling

Star/snowflake schemas

Git

CI/CD

OpenAI

Gemini

Claude

Llama

Python

Tools

Git

CI/CD tools

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

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.