Sagar Khandelwal

Software professional with 2+ years of experience working with financial market data systems, ETL workflows, SQL transformations, data validation, and reconciliation of 3 Lakh+ financial instruments daily. Hands-on experience with Python, SQL, PySpark, ADF, Azure Databricks, ADLS Gen2, Apache Spark, and Delta Lake through production work and end-to-end data engineering projects. Skilled in building data pipelines, performing data transformations and validation, and troubleshooting production data workflows to deliver reliable, business-ready datasets.

Analyst L2 at Estee Advisors (2023-12 – Present)

• Supported automated ETL pipelines processing daily financial market data, using SQL Server, Python, C# services, and scheduled jobs for data ingestion, validation, transformation, and loading.
• Implemented data validation and reconciliation logic for 3 Lakh+ financial instruments/day, identifying new, existing, and modified securities and generating unique IDs for newly listed instruments.
• Monitored and troubleshot 20+ dependent data-processing jobs, using SQL, Python, application logs, and runtime diagnostics to identify pipeline failures and data issues, reducing manual investigation time by 70%.

Analyst L2 at Estee Advisors (2023-12 – Present)

• Processed JSON files containing user and investment data, extracted relevant information, and combined it with data from the SQL database to create structured datasets for the Business Development team.
• Developed SQL queries and data validation logic to combine user, investment, transaction, and portfolio data into business-ready datasets, reducing manual data preparation by 90%.

Bachelor of Technology – Poornima College of Engineering (2019-08 – 2023-06)