Mitanshu Baranwal
Open to Mid-level Data Engineering Roles

Hi, I'm

Mitanshu Baranwal

Data Engineer, ETL & Pipeline Architect, AWS Cloud Platform Engineer, LLM Automation Engineer

5 years building production-grade ETL pipelines on AWS, orchestrating 1M+ record/day workflows with Apache Airflow, and integrating LLM-based automation into data platforms.

About

About Me

About Mitanshu

Data Engineer & Platform Builder

William O'Neil India  ·  Bengaluru, Karnataka

Data Engineer with 5 years of experience designing and owning production-grade ETL pipelines on AWS. Specialized in Apache Airflow orchestration, PySpark and AWS Glue transformations, and analytical data modeling for large-scale workloads (1M+ records/day). Currently serving as interim lead for a team of 4 engineers, building LLM-based automation (OpenAI, LangGraph, Pinecone) into the data platform for failure detection and self-service analytics.

Name Mitanshu Baranwal
Degree B.Tech Computer Science
Experience 5 Years
Location Bengaluru, India
Certification AWS CCP (CLF-C02)
Email mitanshubaranwal70232@gmail.com
Mail Me View Experience
Career

Education & Experience

Education

2017 – 2021
B.Tech, Computer Science & Engineering

Lovely Professional University, Phagwara, Punjab

2017
XII CBSE — PCM

P.C. High School, Samastipur

2014
X CBSE

Holy Mission High School, Darbhanga

Certifications

May 2025
AWS Certified Cloud Practitioner (CLF-C02) AWS Official

Amazon Web Services

Work Experience

Dec 2023 – Present
Software Developer – Data Engineer Current

William O'Neil India, Bengaluru

  • Interim lead for 4 engineers, running code reviews and enforcing engineering best practices.
  • Own Airflow-orchestrated ETL pipelines processing 1M+ records/day with incremental loads, monitoring, and automated failure recovery.
  • Built AWS Glue + PySpark jobs loading large datasets into Amazon Redshift for downstream analytics.
  • Built OpenAI-powered failure detection that summarizes root cause and emails alerts — cutting manual triage.
  • Added LangGraph + Pinecone RAG for natural-language querying of pipeline metadata and workflow steps.
Sep 2022 – Jul 2023
Software Developer (Founding Engineer)

Excelmax Technologies / Unlimiteye, Bengaluru

  • Built an AI-driven video proctoring platform from scratch (0 → production) with computer-vision and NLP workflows.
  • Developed Django (MVT) microservices & MySQL schemas handling 2,000+ requests/day.
  • Built data pipelines feeding CV models (object detection, face & eye tracking) enabling 30+ automated assessments/week.
Jun 2021 – Sep 2022
Software Developer – Data Engineer

SHL (Saville and Holdsworth Ltd), Gurugram

  • Delivered analytical insights from 35M+ annual assessments for Fortune 500 clients.
  • Built modular big-data ETL workflows transferring 80GB+ daily into Amazon Redshift using Python, SQL & AWS.
  • Designed fact and dimension tables optimized for analytical workloads and downstream reporting.
  • Automated failure recovery and load balancing — saving 15 hours/week of manual work.
Stack

Tech Stack

Core Languages
Python SQL
Orchestration & ETL
Apache Airflow ETL Pipelines Batch Processing Incremental Loads
Big Data & Processing
Apache Spark PySpark AWS Glue (Spark)
Data Modeling
Data Warehousing Star Schema Fact & Dimension Tables
AWS Cloud
Amazon S3 AWS Glue Amazon Redshift Amazon Athena AWS Lambda
Databases
PostgreSQL MySQL SQL Server Redis
AI / LLM
OpenAI API LangGraph Pinecone (RAG) Prompt Engineering
Backend & Tools
Django REST APIs Docker Celery Git
Work

My Projects

Automated Web Data Extraction Pipeline ETL Pipeline
Automated Web Data Extraction Pipeline

Python-powered extraction pipeline that automates web data ingestion, cleans messy content, and prepares analytics-ready datasets for reporting and downstream workflows.

PythonRequestsBeautifulSoupPandas
View on GitHub
Order Processing & Data Workflow Platform Backend + Data
Order Processing & Data Workflow Platform

Robust Django + Celery + Redis workflow platform that processes orders and moves structured business data reliably through connected pipeline stages with async task queuing.

DjangoCeleryRedisDRFMySQL
View on GitHub
Computer Vision Analytics Pipeline AI + Vision
Computer Vision Analytics Pipeline

Image analytics stack for object detection, face recognition, and emotion analysis — demonstrating expertise in unstructured data pipelines for advanced AI-driven analytics use cases.

PythonOpenCVDeep LearningKeras
View on GitHub
Certs

My Certifications

  • All
  • Artificial Intelligence
  • AWS
  • Python
  • Cybersecurity
Contact

Get In Touch

Let's Build Something Great Together

Feel free to reach out — I'd love to connect and explore opportunities in data engineering, ETL automation, and cloud data platforms.