[Skip to main content](#main-content)

[OpenNash Jobs](https://jobs.opennash.com/)
[Hiring report](/reports/hiring/) · [All Citigroup jobs](https://jobs.opennash.com/companies/citigroup/) · [Search jobs](/search/)

Citigroup · Pune Maharashtra India

# Data-ETL Engineering Lead-Vice President

Pune Maharashtra India Executive Data & Analytics 

Listed on Citigroup’s official careers site. Posted September 29, 2026. Check that it is still open and apply there.
[Apply on Citigroup’s careers site →](https://citi.wd5.myworkdayjobs.com/2/job/Pune-Maharashtra-India/Data-ETL-Engineering-Lead-Vice-President_26994927)

[OpenNash Jobs](https://jobs.opennash.com/) / [Citigroup](https://jobs.opennash.com/companies/citigroup/) / Data-ETL Engineering Lead-Vice President

## Job description

The Data & ETL Engineering Lead (C13) is a senior technical leadership role responsible for architecting, designing, and delivering enterprise-scale data integration, ETL/ELT pipelines, and data warehousing solutions. This role requires an expert data engineer with deep hands-on proficiency in Ab Initio, modern Python-based data engineering, and relational database engines ( Oracle DB). As a C13 Data Lead, you will oversee end-to-end data delivery across the Software Development Life Cycle (SDLC), collaborate closely with cross-functional business and technical stakeholders, define data architecture and modeling standards, and implement automated CI/CD deployment pipelines for high-throughput batch and real-time processing systems.

### Key Responsibilities
- Technical Leadership & Data Architecture ETL & Pipeline Architecture: Lead the architecture, design, and implementation of robust, high-volume batch and real-time ETL/ELT pipelines using Ab Initio and Python.

### Data Warehousing Design

Define and implement dimensional data models (Star Schema, Snowflake Schema, Slowly Changing Dimensions - SCD Type 1/2/3/4/6, Conformed Dimensions, Fact Tables) supporting large-scale enterprise reporting and analytics.

### Data Governance & Quality

Enforce enterprise data governance standards, data lineage, metadata management, data dictionary maintenance, and automated data validation/reconciliation frameworks.

### Database Engineering & Performance Optimization Oracle Database Development
- Lead database design, complex SQL authoring, and advanced PL/SQL programming (Stored Procedures, Packages, Triggers, Table Functions).

### Performance Tuning

Perform comprehensive performance tuning of large-scale ETL graphs, Python jobs, and Oracle queries via execution plans, indexing strategies, table partitioning, parallel execution, and optimizer hints.

### Volume Management

Architect solutions capable of processing multi-terabyte datasets within stringent SLA time windows.

### Stakeholder Management & Collaboration Cross-Functional Partnership
- Act as the primary technical liaison between business stakeholders, data product owners, quantitative analysts, reporting teams, and enterprise infrastructure partners.

### Requirements

Translation: Translate complex business rules and regulatory requirements into detailed technical specifications, source-to-target mappings (STTM), and data flow architectures.

### Agile & Program Delivery

Partner with Scrum Masters and Project Managers to plan sprint roadmaps, estimate technical effort, mitigate data pipeline risks, and manage dependency handoffs.

### CI/CD & DevOps Automation DevOps for Data Pipelines
- Build and standardize automated CI/CD pipelines for packaging, testing, and deploying Ab Initio code/graphs, Python scripts, and Oracle DDL/DML migrations (e.g., using Jenkins, Harness, Tekton, GitLab CI, Liquibase).

### Version Control & Release Management

Manage code repositories, branching workflows, and configuration management across environments (Dev, SIT, UAT, Prod).

### Operational Monitoring & Production Resilience

Establish monitoring and alerting systems (e.g., Autosys, Control-M, Grafana, Splunk, Loki), lead Root Cause Analysis (RCA) for critical batch failures, and drive operational stability.

### Team Mentorship & Engineering Standards Team Leadership
- Mentor and guide mid-level and junior ETL developers, data analysts, and database engineers.

### Standardization

Establish code review checklists, design patterns, reusable ETL modules/subgraphs, and automated unit/regression testing standards across data engineering teams. Technical Skills & Competencies e ETL & Data Integration
- Deep hands-on expertise in Ab Initio (Co>Operating System, GDE, Enterprise Meta>Environment (EME), Continuous Flows, Plan>It, Express>It, Component Development, Subgraphs, Partitioning/De-partitioning)
- Strong experience building custom data extractors, loaders, and transformers

### Python Data Engineering
- Advanced Python 3.x for data processing and pipeline scripting
- Proficiency with libraries such as Pandas, NumPy, PyArrow, SQLAlchemy, PySpark, Polars
- Writing clean, object-oriented, testable Python code with unit test coverage (pytest/unittest) Data Warehousing & Modeling
- Comprehensive understanding of Data Warehousing & Data Lakehouse concepts (Inmon vs. Kimball methodologies)
- Dimensional modeling (Star / Snowflake schemas, Factless Facts, Aggregate tables, SCD Types)
- Data lineage, Source-to-Target Mappings (STTM), metadata governance, and data profiling

### Database & SQL
- Advanced Oracle 19c+ & PL/SQL programming (Complex joins, window functions, analytical functions, CTEs)
- Deep knowledge of Oracle optimizer, query execution plans, indexes (B-tree, Bitmap), partitioning/sub-partitioning strategies, and bulk operations (FORALL, BULK COLLECT) CI/CD & Infrastructure
- Experience in CI/CD pipeline authoring ( Jenkins, Harness, Tekton, GitHub Actions, GitLab CI)
- Database change management tools (e.g., Liquibase, Flyway)
- Linux/Unix shell scripting ( Bash/Ksh), job scheduling tools ( Autosys, Control-M, Airflow)
- Version control with Git / Bitbucket Testing & Quality
- Automated data testing, data reconciliation, boundary testing, and regression suites
- Code quality tools and security scanners ( SonarQube, Checkmarx, Snyk)

### Experience & Leadership Profile Total Experience

10+ years of professional experience in data engineering, data warehousing, and ETL development, with at least 3+ years leading technical teams or complex data engineering initiatives.

### Education

Bachelor’s or Master’s degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or equivalent quantitative discipline.

### Domain Knowledge

Prior experience in banking, financial services (e.g., Risk, Regulatory Reporting, Capital Markets, Retail Banking, Wealth Management), or large enterprise data systems is highly preferred.

### Communication & Influence

Proven ability to communicate effectively with business stakeholders, summarize complex technical data architectures, and lead discussions with senior leadership. ------------------------------------------------------ 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.

## At a glance
- Posted by the employer: Sep 29, 2026
- First seen by OpenNash: Oct 13, 2026
- Last checked: Oct 20, 2026
- Listed for: 21 days
- Location: Pune Maharashtra India[Apply on Citigroup’s careers site →](https://citi.wd5.myworkdayjobs.com/2/job/Pune-Maharashtra-India/Data-ETL-Engineering-Lead-Vice-President_26994927)

## More jobs at Citigroup

### [Big Data / PySpark Engineering Lead - Vice President](https://jobs.opennash.com/companies/citigroup/jobs/f64b06372d0ea905830d/)

Pune Maharashtra India

### [Big Data Engineer - Python and Spark](https://jobs.opennash.com/companies/citigroup/jobs/60632496cd7415989f24/)

Pune Maharashtra India

### [Bigdata Scala Engineer Vice president](https://jobs.opennash.com/companies/citigroup/jobs/5759e14835bdb415b614/)

Pune Maharashtra India

### [Business Analytics Lead Analyst - Vice President](https://jobs.opennash.com/companies/citigroup/jobs/3b53041055ccc3d88e5e/)

Pune Maharashtra India

### [Business Data Analytics Group Manager - Senior Vice President](https://jobs.opennash.com/companies/citigroup/jobs/525864565f93b35167ff/)

Pune Maharashtra India

## Similar jobs at other companies

### [Singapore Data Engineering Intern (Etl & Python)](https://jobs.opennash.com/companies/seagate-technology/jobs/279dd583148bb791ab6d/)

Seagate Technology 

### [Sr Data Engineer (6+ Years in Data Engineering + Contact Center Analytics + SQL + ETL/ELT + Power BI+ AWS + API Integrations + Genesys/Cisco/NICE/Five9/Amazon Connect + Team Leadership)](https://jobs.opennash.com/companies/assurant/jobs/3b2c419feef4917e8d22/)

Assurant 

### [Resiliency Data Products - Data Engineer Vice President](https://jobs.opennash.com/companies/jpmorganchase/jobs/9014ce336f0dd9ce5d4c/)

JPMorganChase · LONDON, United Kingdom

### [ETL Test Engineer](https://jobs.opennash.com/companies/ntt/jobs/7d91701630406d1aed40/)

NTT · Bangalore, KA, IN, India

### [Lead Data AI Engineer_Vice President_Data & Analytics Engineering](https://jobs.opennash.com/companies/morgan-stanley/jobs/4ee0180c6da81a59b8a9/)

Morgan Stanley · Bengaluru, India

OpenNash lists jobs from employers’ own careers sites and does not handle applications.
Dates come from the employer where stated; “first seen” and “last checked” are our own observations.

OpenNash Jobs · Official listings with dates and links to the employer. [Weekly hiring report](/reports/hiring/) · [Methodology](/methodology/)