Google Data Engineer Interview Experience (Bangalore) – 3 YOE

🎯 Got into Google as a Data Engineer (Bangalore) | My Interview Experience | 3 YOE | 35+ LPA Offer! In this video, I’m sharing my real and complete interview experience for the Google Data Engineer role in Bangalore. With just 3 years of experience, I cracked the interviews and received a package of over ₹35 LPA! 🔍 What you'll learn: All 6 interview rounds explained in detail What kind of questions Google asks (SQL, Python, Data Pipelines, System Design, Behavioral) Tools and concepts you NEED to know (BigQuery, Airflow, GCP, Streaming logic) Realistic CTC breakdown (base, bonus, stocks) My preparation strategy and useful tips 🧠 Whether you’re applying to Google or preparing for any top-tier company (FAANG, Product-Based), this breakdown will give you clarity, strategy, and confidence. 00:00 - Introduction 00:05 - Received Offer from Google Bangalore 00:10 - Profile Overview (3 Years Exp, Tech Stack) 00:34 - Previous CTC & Application Mode 00:45 - Google Final Offer Breakdown (Salary + Stocks + Bonus) 01:16 - Total Compensation Overview (35–40 LPA) 01:19 - Interview Rounds Overview (6 Rounds) 01:24 - Round 1: Online Assessment (DSA + SQL + Python) 01:38 - DSA: Sliding Window Question 01:54 - SQL: Join, Aggregate, Window Function 02:38 - Python: Detect Schema Anomalies in Logs 03:00 - Tip for OA: Leetcode Medium + Hackerrank SQL 03:02 - Round 2: Data Engineering Round 03:06 - Design ETL from External API to BigQuery 03:18 - Schema Evolution, Airflow Scheduling, Query Optimization 03:29 - Tips: Failure Handling, Retry, Partitioning 03:39 - Round 3: Coding Round 03:44 - Process GBs of Log File to Get Top 10 Users (Streaming) 03:59 - Follow-up: Handling Schema Change Midway 04:09 - Tips: Generators, External Sorting 04:13 - Round 4: System Design 04:16 - Real-time Clickstream Pipeline Design 04:23 - Follow-up: Fault Tolerance, Deduplication, Efficient Storage 04:35 - Tips: Pub/Sub, Kafka, Dataflow, BigQuery, Z-Ordering 04:49 - Round 5: Behavioral + Googliness 04:54 - Ownership of Failing Project, Conflict with PM 05:09 - STAR Format, Humility, Growth Mindset 05:23 - Round 6: Hiring Manager Round 05:26 - Project Deep Dive, Junior Onboarding, Metrics 05:43 - Motivation for Joining Google 05:51 - Tips: Talk About Scale, Impact, Learning 05:56 - Key Tech Asked (SQL, Python, Airflow, GCP, Optional Tools) 06:21 - Timeline (Application to Joining) 06:34 - Final Tips for Aspirants 06:55 - Acknowledgement & Closing