About Hemsagar
English
Native or bilingual
Experience
- Fractal Analytics,Senior Data EngineerBANKING AND INSURANCESeptember 2025 - Today (11 months)Noida, Uttar Pradesh, IndiaProject: 360• • Architected and deployed scalable ETL pipelines using Azure Data Factory (ADF) and Databricks, ingesting large-scale policy datasets into ADLS Gen2.• • Leveraged Claude Code CLI to generate automated PySpark unit-test suites, cutting syntax refactoring time by 20%.• • Automated job orchestration through Databricks Workflows, resulting in a 40% reduction in manual operational overhead.• • Enhanced data reliability by 30% through robust PySpark and SQL-based data quality frameworks.• • Optimized Spark performance via partitioning, caching, and join strategies, reducing overall processing time by 35%.• • Executed storage optimization via Parquet compression and lifecycle policies, cutting cloud storage costs by 20%.Project: Chubb-Ontology• • Built a Generative AI-powered observability agent, integrated via a custom MCP (Model Context Protocol) server, to autonomously monitor Databricks job runs and cluster health.• • Exposed Databricks Jobs and Clusters APIs as MCP tools, enabling the LLM agent to query job status, fetch failure logs, and trigger automated cluster restart and recovery on job failure.• • Engineered an LLM-based root-cause analysis layer that parses failure logs and generates actionable remediationsuggestions.• • Delivered real-time, context-rich failure alerts to developers with root cause and suggested fix, reducing mean time to resolution (MTTR) and on-call triage effort.
- Publicis Sapient (TLG India Pvt Ltd),Data EngineerDIGITAL AND ITMay 2023 - August 2025 (2 years and 3 months)Gurugram, Haryana, India• • Developed high-volume data pipelines in the finance domain using Databricks and ADF, processing 8GB+ of daily transactional data.• • Optimized existing PySpark ETL transformations and analytical queries, improving pipeline execution efficiency by 25%.• • Integrated automated monitoring and alerting to proactively flag data SLA breaches, maintaining 99.9% platform availability.• • Ensured data privacy and compliance by implementing GDPR-compliant processing pipelines and governance controls.• • Engineered 20+ automated reconciliation scripts, improving data validation accuracy by 35%.
- Dunnhumby,Data EngineerBANKING AND INSURANCEApril 2022 - May 2023 (1 year and 1 month)Gurugram, Haryana, India• • Implemented cloud data warehouse solutions for a UK pharmaceutical client using DBT and Google Cloud BigQuery.• • Managed complex workflow orchestration with Cloud Composer for reliable pharmaceutical analytics delivery.• • Automated deployment by designing and maintaining Jenkins CI/CD pipelines, and used Terraform (IaC) to provision BigQuery tables and schemas.• • Integrated datasets from 10+ vendors (~50GB) into a centralized analytics platform while reducing operational costs by 20%.
Recommendations
Be the first to recommend Hemsagar
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- B.E.Samrat Ashok Technological InstituteB.E.
- Cloud Data Engineer2024Cloud Data Engineer
Certifications
- Databricks Data Engineer ProfessionalDatabricks2024