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, up-to-date 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
1. 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.

2. 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.

3. Stakeho

📌 Data-ETL Engineering Lead-Vice President (Pune)
🏢 Citi
📍 Pune