< Hello World />

Gourav Chawla

I'm a 

Building scalable data pipelines on GCP · Processing 30GB+ daily · Building AI agents with Claude Code & Google ADK

About Me

Gourav Chawla - GCP Data Engineer

I'm a Data Engineer at Accenture with 4+ years of experience designing and building enterprise-scale data platforms on Google Cloud Platform. I specialise in Medallion Architecture, real-time ingestion pipelines, and cost-optimised cloud infrastructure — currently processing over 30GB of data daily across retail and banking domains.

Previously at Tata Consultancy Services, I led cloud data migrations, BigQuery optimisation, and Infrastructure-as-Code using Terraform. I'm a Google Certified Professional Data Engineer and a strong advocate for clean, maintainable pipelines and engineering best practices.

Beyond my day job, I actively mentor aspiring data engineers on Topmate — covering GCP, BigQuery, career guidance, and breaking into data engineering.

Alongside data engineering, I'm building AI agents using Claude Code and Google ADK, focusing on deterministic, guardrailed agent design with human-in-the-loop controls. I write about it on Dev.to .

4+ Years Exp.
30GB Daily Data
6+ Sources
2x Companies

Technical Skills

Cloud & GCP

Google Cloud Platform BigQuery Cloud WorkFlow DataForm Cloud Run Dataproc Cloud Composer Microsoft Azure AWS Cloud Storage Cloud Functions

Big Data & Pipelines

Apache Spark PySpark Apache Airflow dbt Medallion Architecture ETL / ELT Hive Sqoop

Languages

Python Advanced SQL Shell Scripting Java C++

DevOps & Tools

Terraform Docker GitHub / Git CI/CD Jenkins RESTful APIs Data Modeling MySQL

AI Tools & Productivity 2026 Focus

LangChain LangGraph Google ADK Claude (Anthropic) Claude Code Antigravity GitHub Copilot Prompt Engineering AI-Assisted Code Review LLM-Powered Documentation TDD Generation KT Automation

Work Experience

Data Engineer (Senior Analyst)

Accenture

Current

Mar 2025 – Present · Gurugram

  • Architected end-to-end Retail data products using Medallion Architecture (Bronze → Silver → Gold); implemented complex SCD Type 2 and incremental logic via dbt + BigQuery, improving data reliability by 30%.
  • Engineered a metadata-driven ingestion layer using Airflow DAGs + Dataproc processing 30+ GB daily from 6+ sources — cutting manual ETL configuration effort by 40%.
  • Designed a secure RESTful API framework for automated JSON extraction, achieving zero-downtime processing and accelerating vendor onboarding by 25%.
  • Led team deployments via GitHub + Docker CI/CD pipelines, reducing production incidents by 25% through automated quality gates.
  • Mentored a cross-functional team of 5–6 junior engineers across 2–3 teams; conducted KT sessions on Antigravity, Claude AI & GitHub Copilot — enabling the team to auto-generate TDDs, technical documentation, and boilerplate code, saving 3–4 hrs/engineer/week.
  • Certified Claude Architect (Anthropic) — leading internal AI adoption POCs; helping engineers integrate LLM tooling into daily workflows for documentation, code review, and sprint velocity improvement.
BigQuery dbt Airflow Dataproc Docker GitHub CI/CD RESTful APIs

System Engineer

Tata Consultancy Services

Full-time

Aug 2022 – Mar 2025 · Gurugram

  • Optimised large-scale database performance in the Banking domain — complex SQL queries and index maintenance reduced system downtime by 15%.
  • Led high-integrity data migration using GCP, PySpark, and SparkSQL, improving system performance by 20% and ensuring seamless financial data consistency.
  • Fine-tuned BigQuery execution plans, achieving a 20% reduction in cloud compute costs and accelerating report generation by 25%.
  • Utilised Terraform to provision data warehousing environments — datasets, storage buckets, and virtual machines — for repeatable, scalable infrastructure.
GCP PySpark SparkSQL BigQuery Terraform SQL

Featured Projects

Refund Orchestrator Agent (Google ADK)

Nov 2026

Production-style e-commerce refund agent built on Google ADK, where Gemini 2.5 Flash acts only as a semantic router and plain-English interface. Every order lookup, refund calculation and payout runs through deterministic Python tools guarded by ADK lifecycle callbacks, with human-in-the-loop confirmation gates, SQLite injection protection and a $150 cap that escalates larger refunds to finance.

  • Automates the end-to-end refund workflow (lookup, policy check, calculation, payout) for orders under $150, so human agents only handle high-value and high-fraud-risk cases
  • Deterministic refund math (10% restocking fee, waived for defective items, shipping refunded only for defective or not-as-pictured) with two-turn HITL confirmation, so the LLM never guesses policy or arithmetic
  • Security guardrails: strict order-ID regex with parameterized SQL, domain-locking against off-topic prompts, anti-loop protection and idempotency keys that prevent duplicate payouts
  • Automatic escalation of refunds over $150 and fraud scores ≥ 0.80 to a finance HITL ticket, with tool sequencing enforced in before_tool_callback, plus cost controls (300-token cap, temperature 0, static cached prompt) and network-free unit tests with CI
Google ADK Gemini 2.5 Flash Python SQLite Pydantic LLM Guardrails Human-in-the-Loop (HITL) Pytest GitHub Actions

Flipkart Insight Engine

May 2024

Comprehensive e-commerce analysis platform using PySpark on Databricks — processing large-scale product data with weighted ratings, sentiment analysis on customer reviews using NLP, and time-series correlation for market trend identification.

  • Weighted ratings + effective pricing logic at scale
  • NLP-powered sentiment analysis on customer reviews
  • Time-series & correlation analysis for market trends
PySpark Databricks NLP Python Apache Spark

More Projects Coming

Currently building a new AI agent project alongside a GCP data pipeline showcase and a Medallion Architecture demo. More coming soon.

Follow me on GitHub

Certifications

Certified Partner Specialist Gemini Enterprise Agent Development

Google Cloud

Verified

Certified Partner Specialist Gemini Enterprise Deployment

Google Cloud

Verified

Professional Data Engineer

Google Cloud

Verified

Certified Architect – Foundations

Anthropic (Claude AI)

Verified

Azure Fundamentals

Microsoft Azure AZ-900

Verified

Associate Data Practitioner

Google Cloud

Verified

Python for Data Science

IBM

Verified

Spark Foundations Level 1

IBM

Verified

Hadoop Foundation Level 1

IBM

Verified

Awards & Recognition

Costco RMN/Q2 Trailblazers Award

Accenture

Recognised for consistent delivery and impactful contributions to high-priority workstreams.

Leadership Appreciation – FY25 Delivery

Accenture

Awarded for impactful collaboration and quality in delivering key production milestones.

Client & Leadership Appreciation

Accenture

Recognised for proactive problem-solving and innovative handling of infrastructure issues during critical deployment.

Star Performer of the Month

Tata Consultancy Services

Recognised for exceptional quality of work and maintaining high system reliability within the banking domain.

Get In Touch

Have a project, opportunity, or just want to say hello?
Drop me a message and I'll get back to you.

Location

Gurugram, Haryana, India

Please enter your name.
Please enter a valid email.
Please enter a subject.
Please enter your message.