Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Google Operations Center Team. If you also belong to the team, you can get access from here

Google Operations Center Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 489 Reviews

Filter interviews by

Google Operations Center Associate Business Analyst Interview Questions and Answers

Updated 21 Dec 2021

Google Operations Center Associate Business Analyst Interview Experiences

1 interview found

I applied via Walk-in and was interviewed in Nov 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Why you want to joint?
  • Q2. See in future

Interview Preparation Tips

Interview preparation tips for other job seekers - Attractive ; passionate

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

The interview asked in SQL coding he was not in the intention of recruiting me he was Mr.kishlay shukla who was senior analytics manager in Myntra .He was in a hurry while starting itself .He was continuously moving and went way and coming back and saying enough do coding for next question.He was distracting me.Continously talking with some other colleagues.

If he don't want to interview me he could have informed the HR .And I was continuously calling HR caren rodrigues to tell her this and to know about the interview result but she didn't pickup my call

Seriously very worst experience with Myntra .

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't apply for the analyst roles in Myntra . Particularly if HR caren rodrigues calls you please make sure this never happens again to you .

I was interviewed before May 2016.

Interview Questionnaire 

3 Questions

  • Q1.  famous gold puzzle
  • Q2. Case study related: sales were increasing but the monthly profits were falling.
  • Q3.  problem identification - how to reduce per delivery cost from Rs. 75 (hypothetical value).
  • Ans. 

    To reduce per delivery cost from Rs. 75, we can focus on optimizing logistics and operational processes.

    • Analyze the current delivery process to identify inefficiencies

    • Implement route optimization software to minimize travel time and fuel consumption

    • Negotiate better rates with suppliers and shipping partners

    • Invest in technology to automate manual tasks and reduce labor costs

    • Streamline inventory management to minimize st

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: based on Cg.
No test was conducted.

Round: Group Activity
Experience: Nil
I selected this round by mistake.
there was only 1 round.

Round: HR Interview
Experience: We had 3 rounds of interview - first HR followed by two case study rounds. There were three panellist, one HR and the other two technical ones.

First round was specificaly HR round. They asked puzzles as well for this round. But even in the subsequent rounds, they didn't limit themselves to case studies but asked a few basic introduction questions as well. Some standard puzzles were asked in this round - a famous gold puzzle was asked to me. When I told that I know the answer, then they didn't grill me on it. The panellist were insti guys only - so questions like 'Why Saarang coreship ?' and 'Why choosing this track ?' were asked. The HR round also had a bit of senior junior interaction taste - question like 'Most interesting thing in insti' was asked. The 2nd and 3rd round were case study rounds both related to food-delivery only, Swiggy being related to that field. 1st one was a classic case study - sales were increasing but the monthly profits were falling. I solved it and gave suggestions to them. They were asking for data to support our claim. Out of 20-25 students from the first round, only 4 went to 2nd round and subsequently 3 to the 3rd round. 3rd round case study was about problem identification - how to reduce per delivery cost from Rs. 75 (hypothetical value). This was an open ended question and so was different from the first case study.



Tips: As it is a startup so I expected questions broadly related to 3 categories - HR, puzzles, and case studies. For puzzles and case studies - Day 1.0 is the book. Casing point is the book from which you can get even more difficult case studies. I also found a very good link in Quora - in which all the possible puzzles were given. Some HR questions like 'Why startup ?' & 'Why not the convenional company ?' were expected. I reffered to websites like 'themuse.com' for career planning which was very useful.

College Name: IIT Madras
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.

Round 2 - Technical 

(1 Question)

  • Q1. They give you some questions and you have to write sql queries for them
Round 3 - Technical 

(1 Question)

  • Q1. You are given case study and come sql questions based on that
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - HR 

(4 Questions)

  • Q1. Tell me about yourself
  • Q2. What did you know about Urban Company?
  • Q3. Why do you want to join?
  • Q4. Will you be able to relocate and join within 2 days
Round 2 - HR 

(2 Questions)

  • Q1. If you have to convince someone to get the service, how will you do?
  • Q2. How will you generate leads?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL Question using window functions
  • Q2. Guesstimate on Number of McD orders
  • Ans. 

    The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.

    • Consider the population density of the area where the McDonald's is located

    • Take into account the time of day - more orders during meal times

    • Factor in the day of the week - weekends may have higher order volumes

    • Look at historical data or industry averages for similar locations

    • Consider any promotions or speci

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Telephonic Call 

(2 Questions)

  • Q1. Preview company details & working
  • Q2. Product knowledge
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL question about joins on table having null values
  • Q2. SQL question on lead/lag/cummulative sum application
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL QUERY QUESTIONS ON JOINS
Round 2 - Technical 

(1 Question)

  • Q1. Excel basic formulas like lookup
Round 3 - HR 

(1 Question)

  • Q1. About Yourself, resume grilling

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and practise hard
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Going through your resume, past projects and metrics around that project.
  • Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
Round 2 - Technical 

(2 Questions)

  • Q1. RCA on why the conversion is down on the app.
  • Q2. SQL question of high difficulty (don't remember the question as that was his self made question) Logic used: self join with date

Tell us how to improve this page.

People are getting interviews through

based on 1 Google Operations Center interview
WalkIn
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
View all
Senior Associate
279 salaries
unlock blur

₹3.7 L/yr - ₹13.6 L/yr

Digital Media Specialist
115 salaries
unlock blur

₹5.3 L/yr - ₹12.2 L/yr

Digital Marketing Specialist
90 salaries
unlock blur

₹5 L/yr - ₹14.5 L/yr

Analyst
87 salaries
unlock blur

₹2.5 L/yr - ₹7.3 L/yr

Senior Customer Support Associate
76 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Explore more salaries
Compare Google Operations Center with

Amazon Development Centre India

4.1
Compare

Microsoft Corporation

4.1
Compare

IBM

4.1
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview