Nilesh Rane
Bengaluru
Summary
Strategic Data Engineering Lead with deep expertise in architecting scalable ETL/ELT pipelines and executing cloud migrations. Proficient in AWS, PySpark, Oracle PL/SQL, and Finacle eBanking, with significant achievements in data governance and PII remediation across 1,000+ tables. Leads cross-functional teams to enhance data quality and deliver compliance-aligned, business-critical solutions.
Overview
10
10
years of professional experience
3
3
Certifications
Work History
Data Engineering Lead
AngelOne
Bengaluru
12.2023 - 01.2026
- Led and mentored data engineering team, architecting scalable ETL/ELT pipelines using AWS Glue, Airflow, Appflow, PySpark, and Python, establishing best practices and automating production workflows across cross-functional teams
- Engineered real-time data integrations with 15+ third-party providers (Salesforce, Appsflyer, Experian, CIBIL, Finbox) and implemented Medallion Architecture (Bronze/Silver/Gold), enhancing data quality, lineage, and accessibility for business intelligence
- Led enterprise cross-cloud migrations (GCP BigQuery → AWS Redshift/S3 & Databricks) while managing hybrid storage environments (Redshift, DynamoDB, BigQuery), optimizing performance, cost-efficiency, and low-latency analytical scale
- Built advanced customer segmentation, cohorts, and retargeting buckets powering Meta & Google ad campaigns, directly boosting active user rates and unlocking revenue from dormant leads
- Architected enterprise-wide PII Remediation Framework to remediate sensitive data across 1,000+ tables and master datasets, designing centralized Data Vault with strict access controls, encryption, and zero-trust retrieval for critical use cases
- Established DMZ Account and NAT Gateway architecture for secure vendor data sharing.
Team Lead
Saama Technologies
Pune
04.2022 - 12.2023
- Engineered multi-client data integrations using Python, Kafka, PySpark, Airflow, Git, and Docker, enabling reliable real-time data streaming and workflow orchestration between clinical applications
- Implemented CDISC-compliant Clinical Study domain mappings across therapeutic areas including Adverse Events, Concomitant Medications, Medical History, Laboratory (Local & Central), Demographics, Dispositions, and Protocol Deviations
- Processed and transformed clinical data across multiple file formats — XPT, SAS7BDAT, AVRO, PARQUET, and CSV — ensuring compatibility and integrity across downstream systems
- Integrated data from EDC source systems (RAVE, VEEVA, CTMS) using CRF documentation to accurately map and validate clinical trial data for analysis and reporting
- Developed Clinical and Operational analytics dashboards using SQL, Python Pandas, Amazon S3, and ETL tools, delivering study-level insights on Site & Country milestones for Clinical Research Organizations (CROs)
- Diagnosed and resolved complex dashboard and backend reporting issues by analyzing data anomalies and optimizing multi-layered SQL logic, ensuring accuracy and reliability of clinical reporting
Associate
Deutsche Bank
Pune
08.2021 - 04.2022
- Provided Finacle eBanking (FEBA 11) production support for Retail & Corporate banking, managing build deployment, UAT-to-Production transitions, resolving incidents across Direct Debit, Transfers, FD/RD, Batch Processing, and Alerts Solution (SMS/Email across Core Banking, ATM, Mobile, UPI), while leading Incident, Problem & Change Management and ensuring IT Audit & Regulatory compliance through Geneos monitoring and cross-channel XServices support
IT Business System Analyst
Axis Bank
Mumbai
05.2019 - 08.2021
- Architected enterprise-scale data migration pipelines using Oracle GoldenGate, PL/SQL, and HikariCP, migrating 2–5 lakh customers in 1–2 hours with parallel execution and zero disruption, while enhancing Payment Gateway security, developing a high-throughput beneficiary API (50+ lakh daily requests), delivering SQL dashboards, ML-inspired campaigning procedures, and managing end-to-end migration lifecycle including data mapping, DB setup, and performance tuning
Software Engineer
Nelito Systems
Mumbai
10.2015 - 05.2019
- Led end-to-end Retail & Corporate internet banking data migration for Axis & RBL Bank (with Infosys), managing FEBA build/deployment, migrating critical modules (SI, Payee, MOBANK, Credit Card) from legacy systems to Finacle eBanking 11, developing PL/SQL procedures, tuning performance via AWR/ASH reports, ensuring data quality, audit compliance, and coordinating cross-functional teams for seamless delivery
Education
PG Diploma - Computer And Information Systems
CDAC
Kharghar , Navi Mumbai08-2015
Bachelor of Engineering - Computer Engineering
Pune University
Pune08-2014
Skills
- ETL pipeline development
- PII Data Governance tools
- Data integration and modeling
- AWS Services EC2,S3,Glue,Airflow,Appflow
- Docker , Kubernetes , Github , CICD
- SQL / PL-SQL / Redshift /Bigquery
- Databricks / Delta lake / Data Lake
- Python / Pyspark / Kafka
- Data Migration
- Data Quality Management
- Leading Team and Building Team
Languages
English
Proficient (C2)
C2
Hindi
Native
Native
Certification
AWS Fundamentals: Going Cloud Native
Affiliations
Cooking , Travelling , Swimming
Timeline
Data Engineering Lead
AngelOne
12.2023 - 01.2026
Team Lead
Saama Technologies
04.2022 - 12.2023
Associate
Deutsche Bank
08.2021 - 04.2022
IT Business System Analyst
Axis Bank
05.2019 - 08.2021
Software Engineer
Nelito Systems
10.2015 - 05.2019
PG Diploma - Computer And Information Systems
CDAC
Bachelor of Engineering - Computer Engineering
Pune University