Geetha Areti

Data Engineer with 3 years at Kotak Mahindra Bank, promoted from Associate 2 to Associate 3 for high-impact pipeline automation. Leads data modeling for a near-real-time DWH on AWS Redshift (Kafka, medallion architecture), owns the team-wide batch scheduler backend, and led a Redshift-to-Aurora UDF migration cutting a ~₹2K/day compute cost to near-zero across 10Cr+ daily rows. Strong in SQL, ETL/ELT design, and cross-functional delivery across Credit Monitoring, Collections, and asset/liability teams.

NITW graduate targeting Data Engineer roles in fintech.

Associate 3 Data Engineer | Business Intelligence Team at Kotak Mahindra Bank Limited (2025-04 – Present)

• Led migration of 500+ tables (2–3 TB/day) from legacy systems to the DEX platform, owning the full pipeline lifecycle — data modeling, ETL rewrites, testing, CI/CD (Azure DevOps) — improving data integrity by ~30%, deployment speed by ~15%, and cutting error rates by ~40% via a single source of truth. As part of this migration, redesigned a cost-prohibitive Redshift Python UDF pipeline (10Cr+ rows/day, ~₹2K/day) for the EWS system by rewriting the logic as JavaScript UDFs on Aurora, scaling compute cost to near-zero while preserving identical output.
• Led data modeling and segmentation for a near-real-time DWH on Redshift; migrated the first schema, achieving 5–6 min end-to-end latency with zero errors and a ~70% reduction in business-side report errors.
• Built the Feature-Mart Rule Engine, a declarative SQL generation engine on AWS Redshift using JSON-based configuration, enabling the risk team to configure EWS triggers and NPA scoring rules without SQL expertise.
• Built and own the scheduler backend used team-wide to schedule and orchestrate all batch pipelines; also developed reusable Python utilities for ETL JSON config generation and data validation, cutting manual setup work across the team.
• Mentored 10+ juniors and new hires on end-to-end pipeline design and scheduling; serve as data owner for Credit Monitoring, BBA, EWS, Affluent Segment, and Leap reports across asset and liability product teams.

Associate 2 Data Engineer | Data Tech Team at Kotak Mahindra Bank Limited (2023-08 – 2025-03)

• Automated 120+ reports across the RA vertical (NPA, EMI presentment, transaction reports) using Power BI and SQL, saving 360 hours/month of manual effort.
• Built end-to-end Nexensus API integration using Python (Pydantic modeling, ORM structuring) on AWS Aurora, modeling 160+ tables and cutting manual processing from 10 hours to 2 hours/month.

B.Tech – National Institute of Technology Warangal (NITW) (2019 – 2023)