Sahil Kapadnis

Data Engineer

Bengaluru, India $5/hr Hybrid Full-time 1+ yrs exp 93 · Outstanding

About

Data Engineer with 1.5 years of production experience designing and deploying end-to-end AWS data pipelines and analytics solutions. Skilled across the full data stack — incremental ETL architecture, cloud infrastructure, data modeling, and BI delivery. Proven ability to ship reliable data systems that translate complex datasets into measurable business outcomes.

Skills & Expertise (50)

Customer Segmentation Advanced

8.0/10

1.5

Years Exp

Cohort Analysis Advanced

8.0/10

1.5

Years Exp

Pivot Tables Advanced

8.0/10

1.5

Years Exp

MS Excel Advanced

8.0/10

1.5

Years Exp

AWS Glue Advanced

8.0/10

1.5

Years Exp

AWS Lambda Advanced

8.0/10

1.5

Years Exp

Amazon Athena Advanced

8.0/10

1.5

Years Exp

ETL Design Advanced

8.0/10

1.5

Years Exp

Power BI Intermediate

7.5/10

1.5

Years Exp

PySpark Intermediate

7.5/10

1.5

Years Exp

SQL Intermediate

7.5/10

1.5

Years Exp

Power Query Intermediate

7.0/10

1.5

Years Exp

Git Intermediate

7.0/10

1.5

Years Exp

KPI Design Intermediate

7.0/10

1.5

Years Exp

EDA Intermediate

7.0/10

1.5

Years Exp

GitHub Intermediate

7.0/10

1.5

Years Exp

XLOOKUP Intermediate

7.0/10

1.5

Years Exp

Charts Intermediate

7.0/10

1.5

Years Exp

Cross-Functional Collaboration Intermediate

7.0/10

1.5

Years Exp

Independent Remote Work Intermediate

7.0/10

1.5

Years Exp

Pandas Intermediate

7.0/10

1.5

Years Exp

Fact & Dimension tables Intermediate

7.0/10

1.5

Years Exp

Star Schema Intermediate

7.0/10

1.5

Years Exp

DAX Intermediate

6.5/10

1.5

Years Exp

NumPy Intermediate

6.5/10

1.5

Years Exp

RLS Intermediate

6.0/10

1.5

Years Exp

ETL Pipeline Design Intermediate

6.0/10

1.5

Years Exp

Data Cleaning Intermediate

6.0/10

1.5

Years Exp

Python Intermediate

6.0/10

1.5

Years Exp

AWS S3 Intermediate

6.0/10

1.5

Years Exp

Tableau Intermediate

5.5/10

1.5

Years Exp

Accuracy Checks Documentation Trend Analysis Dimension Tables Fact Tables Multi-Source Data Integration Glue integrity checks Subqueries validation Deduplication Joins Dashboards DML DDL Complex formulas VLOOKUP CTEs Window Functions

Work Experience

Data Engineer

Infosol Technosol Pvt Ltd

Jan 2025 - Present

Architected a production-grade incremental data pipeline on AWS (S3, Glue, Lambda, Athena, Redshift Spectrum) — eliminated full-table reloads via timestamp-based change tracking, reducing ETL run time by ~60%. Engineered deduplication logic using PySpark in AWS Glue to resolve critical data integrity issues, implementing overwrite-prevention mechanisms that ensured zero duplicate records in the downstream analytics layer. Designed a 2-level S3 partitioning strategy (table + date) that significantly reduced Athena scan volume, lowering cloud storage costs and improving query response times for BI users. Ran SQL analysis across 380K+ transaction records revealing that the top 20% of customers generated ~75% of revenue — findings directly adopted into the client's customer retention strategy. Built cohort and customer segmentation models that identified churn drop-off windows, enabling the client to launch targeted re-engagement campaigns. Delivered Power BI and Tableau dashboards tracking real-time KPIs, revenue distribution, and high-value customer segments for executive and client stakeholders. Collaborated across 3+ cross-functional teams to define metrics, automate reporting workflows, and reduce ad-hoc data requests — freeing analyst bandwidth for higher-value work.

Education

B.E. in Computer Engineering

2022 - 2025 · India

Diploma in Computer Engineering

2019 - 2022 · India

Certifications

Deloitte Australia Data Analytics

Forage · 2025

Completed a virtual job simulation with Deloitte Australia through Forage. Gained hands-on experience in data analytics and forensic technology by analyzing datasets, building dashboards in Tableau, and using Excel to classify data and derive business insights.

Tata's GenAI Powered Data Analytics

Forage · 2025

Completed the Tata Group Data Analytics Virtual Experience on Forage, focusing on AI-driven data analysis and strategy. Performed EDA using GenAI tools, proposed a no-code predictive model for delinquency risk, and designed an AI-powered collections strategy aligned with ethical and regulatory standards.