anchit@sevaro : ~/pune

Anchit Gupta

I build Medallion lakehouses on Databricks

Senior Data Engineer, 5+ years across healthcare, gaming and enterprise. I work three layers of the same stack: the lakehouse that makes data trustworthy, the MLOps that gets models out of notebooks, and the AI / RAG layer that makes any of it answerable in English. M.Tech, IIIT Delhi.

dag: anchit_prod · schedule @continuous running
5+ years shipping
50M+ records unified
40% faster ETL
16 articles published
8 certifications
01

About

SELECT * FROM anchit

I'm a Senior Data Engineer at Sevaro Health in Pune, building cloud-native data platforms and the GenAI analytics that sit on top of them. Most of my work starts the same way: something upstream is messy, slow, or expensive — and by the time I'm done it's governed, observable, and 40% cheaper to run.

Right now that means a multi-tenant access architecture — per-tenant Databricks service principals, Okta JWT authentication, Unity Catalog scoped grants and AWS Secrets Manager — enforcing client data isolation on shared infrastructure. Alongside it, an OpenMetadata catalog spanning Databricks, DOMO and MongoDB with automated data dictionaries, cross-platform lineage and PII tagging.

Before that: five years at Junglee Games and Axtria resolving 50M+ pharmaceutical records at 87% match accuracy, cutting Spark compute 30% by moving EMR → Databricks, and shipping a LangChain summarisation agent that gave five game studios back 3.5 hours per analyst per day.

Off the clock I write the Medallion & AI series on Medium and build in public — a dbt project with 56 tests, an LLM built from scratch, a KV-cache quantiser, and a browser-native SQL trainer.

core stack self-reported · honest
  • Python / PySpark95
  • Databricks / Delta92
  • SQL / Warehousing90
  • AWS / Cloud Infra85
  • Airflow / dbt82
  • LangChain / MLflow80
programmingPython (advanced) · SQL · Bash · C/C++ · JavaScript
data platformsApache Spark (PySpark) · Delta Lake · Databricks · Airflow · dbt
cloud & infraAWS (S3, Redshift, Lambda) · Snowflake · MongoDB · Docker · GitHub Actions
genai & mlLangChain · HuggingFace · MLflow · LLaMA · NLP (spaCy, fuzzy matching)
etl & mdmTalend · canonical models · MDM pipelines · golden record logic
observabilityAlerting frameworks · anomaly detection · SLA monitoring
bi & reportingTableau · Power BI · business KPI dashboards
02

Three systems

one stack, three layers

A lakehouse nobody trusts is a swamp. A model that never leaves a notebook is a hobby. A RAG system on ungoverned data is a confident liar. I build all three so none of them fails alone.

S/01 lakehouse

Medallion Architecture

Raw lands once and never changes. Everything downstream is a rebuildable opinion of it, and each hop earns a stronger guarantee — replayable, then conformed, then trusted.

  1. Bronzeraw · immutable · replayable
  2. Silvercleaned · conformed · tested
  3. Goldmodelled · served · trusted
  • Delta Lake on Databricks, Unity Catalog scoped grants
  • SCD2 dimensions, partitioning & liquid clustering
  • Freshness and anomaly checks gate every promotion
S/02 mlops

MLOps Backbone

The Gold layer is where models should start. Same tables, same tests, same lineage — so a feature in training is provably the feature in production.

  1. Featuresfrom gold · versioned
  2. TrainMLflow · tracked
  3. Registrystaged · approved
  4. Servebatch · online
  5. Monitordrift · A/B
  • MLflow tracking and model registry, GitHub Actions CI/CD
  • A/B testing harness and dynamic recommendation systems
  • Training/serving skew caught at the feature layer, not in prod
S/03 ai / rag

Retrieval-Augmented Generation

An LLM is only as honest as its retriever. Ground it in governed Gold tables, cite the chunk, evaluate the answer — otherwise you've shipped a very fluent guess.

  1. Chunksemantic splits
  2. EmbedHuggingFace
  3. Indexvector store
  4. Retrievehybrid + rerank
  5. Generatecited answers
  6. Evaluategroundedness
  • LangChain orchestration over LLaMA and hosted models
  • PII tagged upstream, so retrieval can't leak what it shouldn't
  • Shipped in production for clinical summarisation and game analytics
03

Run history

3 companies · 0 failed
  1. Oct 2025 — Present running Pune, India

    Senior Data Engineer @ Sevaro Health

    • Architected a multi-tenant access architecture for the analytics platform — per-tenant Databricks service principals, Okta JWT authentication, Unity Catalog scoped grants and AWS Secrets Manager credential storage — enforcing client data isolation on shared infrastructure
    • Architected the migration to a Medallion architecture, projected to reduce technical debt 20–30% and optimise operational workflows
    • Led an OpenMetadata POC and production onboarding for a unified catalog spanning Databricks, DOMO and MongoDB — automated data dictionary generation, cross-platform lineage and PII tagging
    • Drove catalog adoption across engineering and analytics, cutting the effort to trace dataset ownership and assess downstream impact ahead of schema changes
    • Engineered CI/CD pipelines with GitHub Actions to automate pipeline deployments and enforce code quality gates
    • Established a data observability framework and monitoring dashboards, improving pipeline reliability and incident response
    • Spearheaded cloud cost audits to track resource utilisation and reduce spend
    Unity CatalogOpenMetadataOkta JWTMedallionCI/CDFinOps
  2. Oct 2022 — Oct 2025 success India

    Data Engineer I → II → III @ Junglee Games

    Data Engineer III

    Jul 2024 — Oct 2025
    • Built a LangChain GenAI summarisation agent used daily across 5 games, saving 3.5 hours per analyst per day
    • Migrated Spark jobs from EMR to Databricks — +40% ETL performance, −30% compute cost
    • Developed a LLaMA-based Rummy bot for the Learn/Practice section, improving onboarding
    • Built MLOps pipelines for A/B testing and dynamic recommendation systems

    Data Engineer II

    Jul 2023 — Jul 2024
    • Led 3 engineers to build a centralised alerting and observability framework
    • Designed a reusable alerting system with email support, cutting alert development effort by 70%
    • Created freshness and anomaly detection modules, reducing data quality incidents by 50%

    Data Engineer I

    Oct 2022 — Jul 2023
    • Built self-serve analytics layers for cross-functional teams
    • Enhanced GST/TDS pipelines, reducing turnaround time by 20%
    • Improved KPI dashboards, cutting SLA delays by 80%
    LangChainLLaMASparkMLOpsObservabilityEMR→DBX
  3. Jul 2021 — Sep 2022 success India

    Data Analyst → Associate @ Axtria

    • Developed MDM pipelines unifying 50M+ records with NLP, achieving 87% match accuracy
    • Delivered ETL tooling and Golden Record logic for pharmaceutical client data
    • Generated HCP/HCO hierarchies and automated stakeholder notifications
    • Reduced matching algorithm runtime by 40% through memory optimisation
    MDMNLPTalendPharmaEntity Resolution
04

Impact

measured, not vibed
ETL performance40%

EMR → Databricks migration of production Spark workloads

Compute cost30%

Right-sized clusters, job consolidation and cloud cost audits

Data-quality incidents50%

Freshness + anomaly detection modules shipped platform-wide

Alert dev effort70%

Reusable, config-driven alerting framework with email delivery

SLA delays80%

Rebuilt KPI dashboards and the pipelines feeding them

Entity match accuracy87%

NLP-driven master data management across 50M+ records

and the one that isn't a percentage

3.5 hours back per analyst per day, across five games — the LangChain summarisation agent. Five analysts, five days a week, is most of a working month returned every month.

05

Things I built

github.com/anchitgupt · /ez-biz
P/01 proprietary

GenAI Medical Summarisation

A production RAG pipeline that reads dense clinical documentation and returns the parts a neurologist actually needs. Semantic chunking, retrieval and prompt orchestration tuned for clinical precision — extraction that used to take minutes takes seconds.

LangChainorchestration
Semanticchunking
Clinicaldomain
RAGLLMsLangChainHealthcare
P/02 proprietary

LLaMA Rummy Bot

A LLaMA-driven opponent for Junglee's Learn & Practice mode — it plays a credible hand and explains why, turning onboarding from a tutorial into a game.

LLaMAGenAIGame Systems
P/03 proprietary

A/B & Recommendation MLOps

MLOps pipelines at Junglee Games for A/B testing and dynamic recommendation systems — models fed from the same governed tables that back the reporting.

MLOpsA/B TestingRecommenders
P/04 proprietary

Pharma MDM Pipeline

Entity resolution at scale: 50M+ records collapsed into Golden Records with fuzzy matching and NLP, hitting 87% match accuracy on notoriously dirty HCP/HCO data.

MDMSparkNLPAxtria

data-dbt

A production-grade dbt project for e-commerce analytics — 11 models, 56 tests, CI/CD, BI integration and an interactive GitHub Pages site. Built on dbt + DuckDB, so the whole warehouse runs on a laptop.

11models
56tests
CI/CDevery PR
dbtDuckDBAnalytics Engineering

data-builder

A visual ETL platform — connect databases, browse catalogs, build pipelines by drag and drop, stream CDC to S3, then schedule, monitor and export logs. FastAPI + React.

ETLCDCFastAPIReact

datalearn

LeetCode-style SQL practice that runs entirely in the browser — every solution validated by DuckDB-WASM, plus a learning hub and admin CMS. Next.js, Prisma, Monaco.

DuckDB-WASMNext.jsSQLEducation

learn_llm_code

Build an LLM from scratch: 15 runnable Python scripts that walk from a bare neural network to a 2026-architecture, DPO-aligned tiny GPT — with a companion site.

LLMDPOPyTorchFrom Scratch

pytq

TurboQuant for PyTorch — near-optimal vector quantization for LLM KV-cache compression. The unglamorous inference work that decides whether a model is affordable to serve.

QuantizationKV CachePyTorchInference

r-llm

Python vs Rust, honestly measured: an OpenAI-compatible batch-summariser CLI built twice, with a deterministic mock server, cross-language golden checks and benchmarks.

RustPythonBenchmarksLLM Ops

open-desktop-gpt

Your LLM compiles the wiki, you read it. A desktop app inspired by Karpathy's LLM-knowledge-base idea — generation as a reading surface, not a chat log.

LLMTypeScriptDesktop

papers-code

Implementations of Standard ES and EGGROLL from Evolution Strategies at the Hyperscale (arXiv:2511.16652). Reading a paper properly means running it.

ResearchEvolution StrategiesPython

Wikipedia Citation Verifier

Retrieval before it was fashionable — a Chrome extension that embeds a cited document and surfaces the sentence closest to the claim, so you can check whether the citation says what it claims. IIIT Delhi IR project.

Embeddingsdoc2vecChrome ExtIR

easy-pdf

Free online PDF tools — merge, split, compress, convert, OCR. 100% client-side, so files never leave the device. The privacy guarantee is architectural, not a promise.

Client-sidePDFJavaScript
06

Writing

16 articles · @anchitgupt

I write the series I wanted when I was learning this: how a Medallion actually behaves in production, where MLOps meets data engineering, and what AI genuinely changes about the job.

Fact or Dimension? The All-in-One Guide to Reading a Data Model

A practical decision framework for identifying fact and dimension tables — plus exactly how to explain your reasoning in an interview.

Building a Streaming Medallion: One Micro-Batch at a Time

Most Medallion tutorials quietly assume a batch world — a nightly job reads yesterday's files and rebuilds a table. That model breaks on a stream.

Modern Data Engineering Meets MLOps

How today's data engineers are evolving from pipeline builders into platform enablers — and why MLOps is the missing bridge to AI-driven products.

How AI Is Reshaping Data Engineering: A Practical Guide

From self-healing pipelines to intelligent schema detection — AI is not replacing data engineers, it is making them considerably faster.

AI Meets Data Engineering: The Complete Landscape

Article 1 of the “AI × Data Engineering” series — a practitioner's guide to smarter pipelines and where automation actually pays off.

Building Data Engineering Solutions with AI: The New Playbook

From pipeline plumbing to intelligent systems — how AI is rewriting the data engineer's job description.

End-to-End Medallion Pipeline — Bronze, Silver and Gold in Production

Any single layer is straightforward in isolation. The complexity — and the craft — lives in wiring them together.

Partitioning & Clustering Strategy for Medallion Tables

A perfectly modelled Gold table that takes 3 minutes to query will be bypassed within a month. Someone will build a workaround.

Fact Table Design in the Gold Layer — Why Your Aggregations Are Lying

A wrong dimension gives you the wrong label. A wrong fact gives you the wrong number — and a convincingly wrong number is worse than an obviously broken one.

SCD Type 2 in Streaming Pipelines

Batch SCD2 is a solved problem. Streaming SCD2 is a different animal entirely — and most teams only discover the difference in production.

Choosing the Right Dimension for Your Medallion Table

Your pipeline is only as smart as the decisions baked into the Gold layer — and those decisions start with how you handle a slowly changing dimension.

Best SQL Hacks I Wouldn't Have Believed If I Hadn't Used Them Myself

A data engineer's collection of SQL tricks that changed how I write queries — VALUES as an inline table, GROUPING SETS, LATERAL joins, DISTINCT ON.

The Expert Way to Decide the Data Model for Any Problem

A decision process for picking the right model for the problem in front of you, rather than defaulting to whatever shape you used last time.

RCA Analysis: A Data Engineering Deep Dive into Declining Orders

A case study in root-cause analysis — tracing a fall in orders back through the data until the actual reason surfaces.

Uber Eats Data Warehouse Architecture

A complete guide to trip data modelling and analytics storage — the warehouse design behind delivery at scale, and the interview questions it invites.

Why Should People Move to Big Data at a Certain Point?

When a workload genuinely outgrows conventional tooling — and what actually changes at the point you make the move.

07

Credentials

2 degrees · 8 certs
2019 — 2021

M.Tech, Computer Science

IIIT Delhi

Specialised in Natural Language Processing and Deep Learning. Research work in semantic analysis and information retrieval — the roots of everything I now call RAG.

GATE 98.14 percentile
2014 — 2018

B.Tech, Computer Science

Moradabad Institute of Technology · AKTU

Foundations in programming, Android development and machine learning — where the Blood Bank Finder and my first models came from.

First Division
GATE 201998.14 percentile
Databricks FundamentalsDatabricks
LangChain for LLM AppsDeepLearning.AI
Airflow FundamentalsAstronomer
Azure Databricks & Spark CoreUdemy
MTA Database FundamentalsMicrosoft
J2SE Java CertificationOracle
Android App DevelopmentGoogle
08

Let's build something

I'm open to senior data engineering and platform roles — especially where the lakehouse meets MLOps and AI. Got a gnarly pipeline, a cost problem, or a RAG system that keeps making things up? My inbox is genuinely open.

mail — anchit

$ echo $EMAIL

anchitgupt2012@gmail.com

$

Say hello