Roadmap to Get a Data Role at Google (Starting 2nd Year, 4th Sem)
STEP 1: Foundation (4th Semester – Current Phase)
Goal: Build core skills in Python, SQL, and Excel
• [ ] Learn Python basics (Data types, loops, functions)
• [ ] Learn Python for Data Analysis (NumPy, Pandas, Matplotlib, Seaborn)
• [ ] Master SQL (Joins, Aggregations, Subqueries) – use Leetcode + StrataScratch
• [ ] Learn Excel (Pivot Tables, Formulas, Charts)
• [ ] Start your GitHub, upload basic EDA projects
Recommended Timeframe: April–June
STEP 2: Basic Projects + Resume Start
Goal: Apply skills to small, real-world datasets
• [ ] Do at least 2 Exploratory Data Analysis (EDA) projects from Kaggle
• [ ] Create a clean, impact-based resume
• [ ] Add projects to GitHub with readme files
• [ ] Begin learning Git + GitHub version control
Timeframe: May–July
STEP 3: Intermediate Data Science + Visualization (5th Semester)
Goal: Learn storytelling + start applying ML
• [ ] Learn Feature Engineering & Data Cleaning techniques
• [ ] Learn basic ML (Linear Regression, Classification, Sklearn)
• [ ] Start using Power BI or Tableau
• [ ] Build a dashboard project (sales, healthcare, etc.)
• [ ] Join a college tech club or open-source program
Timeframe: July–October
STEP 4: DSA + Google-Focused Prep Starts (End of 5th Semester)
Goal: Prepare for Google-level interviews
• [ ] Start solving DSA daily (1–2 problems from LeetCode)
• [ ] Focus on Arrays, Strings, Trees, HashMaps, Graphs
• [ ] Start solving SQL challenges on LeetCode + StrataScratch
• [ ] Prepare for Google’s past interview questions (Glassdoor)
Timeframe: October–December
STEP 5: Internship Ready (6th Semester)
Goal: Apply for real internships + build portfolio
• [ ] Apply to internships on LinkedIn, Internshala, AngelList
• [ ] Build a project that solves a real-world problem (e.g., ML model, data
dashboard)
• [ ] Write blog posts on your projects (use Medium or Hashnode)
• [ ] Create a portfolio site (GitHub Pages or personal domain)
Timeframe: January–April (3rd Year)
STEP 6: Advanced ML + Cloud Basics
Goal: Become eligible for DS engineer roles
• [ ] Learn Tree-based models (Random Forest, XGBoost)
• [ ] Learn NLP basics (Text cleaning, TF-IDF, Sentiment analysis)
• [ ] Understand basic cloud concepts (GCP, BigQuery, Colab)
• [ ] Practice End-to-End ML project
Timeframe: April–July
STEP 7: Mock Interviews + Networking (7th Semester)
Goal: Prepare for real Google interviews
• [ ] Mock interviews (with friends, or platforms like Pramp)
• [ ] Attend Google Code Jam, Kick Start (practice rounds)
• [ ] Network with Googlers on LinkedIn, ask for feedback or referrals
• [ ] Reach out to alumni who work at Google or similar firms
Timeframe: August–October
STEP 8: Apply to Google (Final Year – 8th Semester)
Goal: Land that Google interview
• [ ] Apply via Google Careers + Careers.google.com/students
• [ ] Use referral if possible
• [ ] Tailor your resume for each role (Data Analyst / DS Engineer)
• [ ] Prepare for case-based + behavioral questions
Timeframe: October–December
Ongoing (Every Month)
• [ ] LeetCode (Python + SQL) – 3–4 questions/week
• [ ] Kaggle/Personal Project – 1 per month or 2 months
• [ ] LinkedIn post or blog update – 1 per month
• [ ] GitHub commits – regular updates
