OYO logo

OYO Business Analyst Interview Questions
& Process

Real candidates share what happened, how many rounds they had,
and how the experience turned out.

Based on 43 interview experiences · FREE TO READ

2.6 Rounds average
Average Typical difficulty
62.8% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at OYO.

Showing 3 of 43
OYO logo
OYO

Business Analyst

Analytics · nearly a year ago

Mid Average Positive experience Accept offer 2 rounds
Interview process
Technical screen Presentation
Interview formats
Technical Coding Case Group

There were two rounds in this interview. The first round was entirely focused on SQL and Python. The second round involved a case study and some guesstimates. They asked about Pandas and Window Functions. Overall, it felt like an average interview.

Confirmed questions5 questions
  • Can you explain different types of Joins in SQL?
  • Tell me about your experience with Pandas.
  • How do you use Window Functions in SQL?
OYO logo
OYO

Business Analyst

Analytics · nearly a year ago

Entry Easy Negative experience No offer 2 rounds
Interview process
Recruiter call Phone screen
Interview formats
Behavioral Technical

The interview was pretty easy and all over the place. The interviewer spent more time talking about his own life than about the job. I feel like they should get people who know what they are doing to conduct interviews.

Confirmed questions3 questions
  • Considering booking a property via Oyo, what aspects would be important to you?
  • Imagine you're opening a new pasta business right next to an established one; what strategies would you use to draw in customers?
  • What is the Vlookup formula?
OYO logo
OYO

Business Analyst Intern

Analytics · more than a year ago

Intern Easy Negative experience No offer 1 round
Interview process
Recruiter call Technical screen
Interview formats
Technical Case

I went through the campus placements for Oyo and my turn came after over 100 candidates had already been interviewed. The interview itself wasn't too hard, but it felt like they had already made their decisions on who to select. There were some guesstimate questions and also questions about machine learning algorithms.

Confirmed questions4 questions
  • Could you list the attributes you'd use to predict booking cancellations?
  • What factors and parameters should we consider when expanding hotel offerings into new locations?
  • Can you define the null hypothesis?

OYO Business Analyst Interview Questions

Quoted word for word from OYO interview reports.

Can you print all pythagorean triplets with integer sides below n?

Read reports

Which cities generated the most revenue within each country?

Read reports

What are lambda functions and how is merge used in Python?

Read reports

Since Oyo collects payment upon arrival, which can lead to losses when guests don't show up, what factors can help predict whether a person will actually turn up for their booking?

Read report

Can you estimate the monthly revenue of a hotel located in an urban area of Delhi?

Read report

Given two tables, how would you perform a LEFT JOIN and a RIGHT JOIN, and then determine the count of rows in each resulting table?

Read report

Can you estimate how many houses of 1, 2, and 3 stories are there in your hometown?

Read report

Can you explain what joins are in SQL and provide examples of their usage?

Read report

Formats, difficulty and experience

Across all 43 OYO interview reports.

Interview formats

Technical 37.7%
Behavioral 26.2%
Case 12.3%
Coding 10.7%
Group 9%

Interview difficulty

Easy 23.3%
Average 60.5%
Difficult 16.3%

Candidate experience

Neutral 20.9%
Positive 62.8%
Negative 16.3%