Sangam Kumar Mishra

Summary

Data professional with 4+ years of experience in data engineering, analytics, and cloud data platforms, specializing in SQL, Python, Snowflake, and AWS. Experienced in designing ETL/ELT pipelines, data transformation, validation, and building scalable data solutions for analytics.

Currently working as a Senior Data Analyst, developing workflow automations, validating data pipelines, and supporting cloud data warehousing using Snowflake. Passionate about modern lakehouse architectures, Databricks, Spark, Delta Lake, and building reliable, analytics-ready data platforms.

Overview

years of professional experience

Work History

Senior Data Analyst

LnP Infotech Pvt Ltd

06.2026 - Current

Design and develop workflow automations using n8n to streamline manual business processes.
Query, reconcile, and diagnose data loaded into Snowflake through Fivetran ingestion pipelines.
Developed Python-based integrations with REST APIs to automate data extraction and workflow execution.
Leveraged Cursor (AI-powered IDE), Claude to accelerate development of automation scripts and internal tooling, improving coding efficiency and turnaround time.
Collaborated with business stakeholders and engineering teams to deliver scalable data and automation solutions.

Data Analyst (Cloud Operations)

Capgemini

10.2020 - 01.2025

Analyzed resolution patterns in high-volume cloud system incident data to identify trends and improve future incident handling.
Managed cloud system incidents in ServiceNow, monitoring resolution and escalation patterns for 1000 monthly incidents to enhance incident response.
Developed Python scripts to clean and process raw monitoring data and built interactive Power BI dashboards to track SLA compliance and operational KPIs.

Education

B. Tech. - CSE

IMS Engineering College

Ghaziabad

07-2020

Skills

Languages: Python, SQL
Data Engineering: Apache Spark (PySpark), Delta Lake, ETL,ELT Pipelines, Medallion Architecture
Cloud Technologies: AWS S3, AWS Glue, Amazon Athena
Automation: n8n, Retool, Rest APIs, Workflow Automation

Data Warehousing: Snowflake
Data Analysis: Pandas, NumPy, Statistical Analysis, Feature Engineering
Visualization: Power BI, Excel
Version Control: Git, GitHub, PR

Projects

Enterprise Retail Data Platform | Databricks, Delta Lake, Snowflake

Designed and built an end-to-end ETL/ELT platform using Python, PySpark, and Databricks, implementing Medallion Architecture (Bronze-Silver-Gold) with Delta Lake ACID tables and MERGE-based incremental upserts.
Enforced automated data quality validation using Great Expectations and built analytics-ready business models using dbt, including testing and documentation for curated Gold datasets.
Orchestrated end-to-end pipelines using Apache Airflow and Databricks Workflows, managing dependencies and scheduling across the full data lifecycle.
Loaded curated datasets into Snowflake and designed reporting-ready data models, powering Power BI dashboards for sales, inventory, customer, and operational KPIs.
Managed version control via Git/GitHub and documented pipeline architecture, data lineage, and engineering decisions per best practices.

Timeline