KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2919
Applications open Internship

Referral Opportunity

Microsoft

  • India (Remote / Multiple), India
  • 12 LPA - 15 LPA
  • Fresher (0-1 Yrs)
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Google, a global technology leader, has its Indian headquarters in Bengaluru and operates across a wide spectrum of products ranging from search, cloud services, advertising, to cutting‑edge AI solutions. The company is renowned for its innovative culture, relentless focus on user experience, and a commitment to solving complex problems at scale. With a workforce that values diversity, collaboration, and continuous learning, Google offers an environment where fresh talent can thrive alongside industry veterans.

The organization’s Indian operations not only drive regional growth but also contribute to global product development, making it an exciting place for fresh graduates eager to make a tangible impact.

The Business Analyst role at Google India is designed for recent graduates who are passionate about turning data into actionable insights that influence product strategy and business decisions. As a Business Analyst, you will work closely with product managers, engineers, and cross‑functional teams to understand business challenges, design analytical frameworks, and deliver data‑driven recommendations. This position serves as a gateway to a career path that can evolve into senior analytics, product management, or strategic consulting roles within the company.

Key Responsibilities

  • Gather and interpret business requirements from stakeholders across product, marketing, and operations.
  • Design, develop, and maintain dashboards and reports using tools such as Looker, Tableau, or Data Studio.
  • Perform ad‑hoc data analysis using SQL and Python to uncover trends, anomalies, and growth opportunities.
  • Conduct market and competitive analysis to support strategic planning.
  • Translate complex data findings into clear, concise presentations for senior leadership.
  • Collaborate with engineering teams to define data pipelines and ensure data quality.
  • Identify process inefficiencies and propose automation solutions.
  • Monitor key performance indicators (KPIs) and track the impact of product launches.
  • Participate in A/B testing design, execution, and result interpretation.
  • Contribute to documentation of analytical methodologies and best practices.

Tech Stack: SQL, Python (pandas, numpy), Google BigQuery, Looker/Tableau, Google Cloud Platform, Excel, and basic knowledge of statistical modeling.

Growth Path: Starting as a Business Analyst, high performers can progress to Senior Analyst, Analytics Manager, Product Manager, or move into specialized roles such as Data Scientist or Business Strategy Lead. Google’s internal mobility programs and continuous learning resources support rapid career advancement.

Why Join Google? You will be part of a world‑class talent pool, work on products that impact billions of users, and enjoy a culture that encourages curiosity, creativity, and personal growth. The company offers competitive compensation, generous benefits, and a supportive environment that values work‑life balance and employee well‑being.

Eligibility & process

Who can apply

Bachelor's degree in Engineering, Computer Science, Information Technology, Business Administration, Economics or related fields; Minimum CGPA/percentage 7.5/65%; Final year students of 2025 batch; No active backlogs at the time of application; Strong analytical mindset and problem‑solving ability.

Skills & stack

SQL Python Data Analysis Advanced Excel Tableau Looker Google Bigquery Business Acumen

Selection process

  1. Round 1: Online Assessment (aptitude & logical reasoning)
  2. Round 2: Technical Interview (SQL, Python, case studies)
  3. Round 3: HR Interview (fit & cultural alignment)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Python, Data Analysis, Advanced Excel, Tableau, Looker, Google Bigquery, Business Acumen) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Microsoft Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Microsoft as a Referral Opportunity?
Highlight Microsoft's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Microsoft 12 LPA - 15 LPA
Recruiter Resume Apply
Chat Chat with Kashii