Open to opportunities

Divyansh Agarwal

@divyanshagarwal

Message

Data Engineer optimizing large-scale ETL and BI to cut costs and speed compliance.

India

Message

What I'm looking for

I’m looking for a role where I can own scalable ETL and SQL/BI solutions end-to-end—optimizing performance, automating workflows, and delivering measurable cost and reporting improvements.

I’m a Data Engineer with 3+ years of experience in BFSI, designing production-grade ETL pipelines (SSIS, SQL, AWS) that process 3TB+/month transaction data. I focus on dependable data engineering with measurable outcomes, from performance wins to faster decision-making.

I’ve delivered ₹5+ Cr annual cost savings through large-scale automation, reducing manual effort by 80%. I also built regulatory BI systems that reduced compliance reporting time by 90%, while cutting production failures by 25%.

My strengths include SQL optimization, star-schema data modeling (fact-dimension modeling), and scalable BI engineering using Power BI and Tableau Cloud. I take end-to-end ownership across the lifecycle—requirements gathering, data modeling, ETL development, validation, production deployment, and BI delivery.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

HDFC Bank Ltd.

Feb 2023 - Present (3 years 4 months)

Architected reusable SSIS-based ETL pipelines integrating 12+ banking systems and processing multi-TB/month transaction datasets. Optimized SQL to cut execution time by 35%, built Power BI regulatory dashboards reducing compliance reporting time by 90%, and developed reconciliation to detect ₹2 Cr revenue leakage and eliminate ₹5+ Cr annual operational inefficiencies.

SSIS ETL SQL Query Optimization Stored Procedures Power BI Data Modeling Performance Tuning AWS S3 EC2 Lambda Python (Pandas)Data Validation

Software Developer

Decimal Technologies Pvt. Ltd.

Feb 2022 - Aug 2022 (6 months)

Built secure API integrations for BFSI applications serving enterprise banking clients and supported analytics initiatives. Developed a SQL + Python anomaly detection pipeline to identify ₹2 Cr in unbilled transactions and contributed to automated RBI compliance reporting using Power BI and SQL.