Add office photos
Engaged Employer
i
This company page is being actively managed by
Oyo Rooms Team. If you also belong to the team, you
can get access from
here
Oyo Rooms
Compare
Filter interviews by
Oyo Rooms Business Analyst Interview Questions, Process, and Tips
Updated
30 Aug 2024
Top Oyo Rooms Business Analyst Interview Questions and Answers
- Q1. What would be the probability of getting at least one six after throwing 2 unbiased dice?
- Q2. What are the critical KPIs to be monitored after creating a new website?
- Q3. What are the use cases of self-join?
9 Oyo Rooms Business Analyst Interview Experiences
23 questions found
Sort by:
Popular
Saket Bihari
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Aptitude Test Round
SQL, General Aptitude Questions
2
Group Discussion Round
10 minutes GD on general topics.
3
One-on-one Round (2 Questions)
- Q1. Case study related tl hospitality industry Add Answer
- Q2. Questions related to POR held in college Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Revise SQL & Case study
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via campus placement at Thapar Institute of Engineering and Technology (TIET) and was interviewed in Feb 2024.
2 Interview Rounds
1
Aptitude Test Round
Basic aptitude question and 2 Sql question
2
Technical Round (4 Questions)
- Q1. 2 Sql question i on joins and other on window function Add Answer
- Q2. 1 Guestimate
1 Puzzle Add Answer
- Q3. Intoduction about your self Add Answer
- Q4. About your resume and interest Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Take it easy
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
2 Interview Rounds
1
Coding Test Round
There were some aptitude question, Pandas question, SQL queries.
2
One-on-one Round (2 Questions)
- Q1. Use SQL to filter duplicate entries. View Answers (1)
- Q2. Questions on Excel Shorcuts. Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Aug 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Technical Round (4 Questions)
- Q1. What are the use cases of self-join? View Answers (1)
- Q2. How to extract nth highest salary? Add Answer
- Q3. What are the critical KPIs to be monitored after creating a new website? View Answers (1)
- Q4. What would be the probability of getting at least one six after throwing 2 unbiased dice? View Answers (1)
Interview Preparation Tips
Topics to prepare for Oyo Rooms Business Analyst interview:
- SQL
- Excel
- Aptitude
- Puzzles
- Case Studies
Skills evaluated in this interview
Oyo Rooms interview questions for designations
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Kharagpur and was interviewed before Aug 2023.
3 Interview Rounds
1
Technical Round (2 Questions)
- Q1. SQL Basic Question Add Answer
- Q2. SQL Medium Level Question Add Answer
2
One-on-one Round (2 Questions)
- Q1. Live SQL Programming Add Answer
- Q2. Live Pyhton Programming Add Answer
3
One-on-one Round (2 Questions)
- Q1. Case Study related to hotel industry Add Answer
- Q2. Root cause analysis of a scenario View Answers (1)
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Campus Placement and was interviewed in May 2023.
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Aptitude Test Round
SQL questions and logical reasoning
3
Technical Round (1 Question)
- Q1. Talked about resume, projects and general questions of maths and logical reasoning Add Answer
4
Case Study Round
A guesstimate and a case study on profitability
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed before Apr 2023.
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. SQL Questions are asked, learn joins and aggregate functions Add Answer
2
Case Study Round
Simple Case Study was discussed
3
HR Round (1 Question)
- Q1. Company fit check and salary expectations Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Oyo has very bad work life balance, you might be expected to work on weekends as well.
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2023.
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Details discussion on Previous projects and Situation based questioning Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - What I realise is OYO doesn't have set way of taking interview, Every Hiring Manager takes his approach, so just focus on your key skill and Prepare you resume strong
Interview experience
Good
Difficulty level
Easy
Duration
2-4 weeks
Result
Selected
I applied via Campus Placement and was interviewed before May 2023.
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. SQL, and puzzles Add Answer
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about Oyo Rooms?
Ask anonymously on communities.
Interview questions from similar companies
Chethan B Raj
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Project in previous company Add Answer
Oyo Rooms Interview FAQs
How many rounds are there in Oyo Rooms Business Analyst interview?
Oyo Rooms interview process usually has 2-3 rounds. The most common rounds in the Oyo Rooms interview process are One-on-one Round, Technical and Aptitude Test.
How to prepare for Oyo Rooms Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Oyo Rooms. The most common topics and skills that interviewers at Oyo Rooms expect are SQL, Python, Analytics, Data Analytics and Data Mining.
What are the top questions asked in Oyo Rooms Business Analyst interview?
How long is the Oyo Rooms Business Analyst interview process?
The duration of Oyo Rooms Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Oyo Rooms Interviews By Designations
- Oyo Rooms Business Development Manager Interview Questions
- Oyo Rooms Software Developer Interview Questions
- Oyo Rooms Demand Manager Interview Questions
- Oyo Rooms Business Analyst Interview Questions
- Oyo Rooms Software Engineer Interview Questions
- Oyo Rooms Hotel Manager Interview Questions
- Oyo Rooms Relationship Manager Interview Questions
- Oyo Rooms Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Interview Process at Oyo Rooms Business Analyst
based on 7 interviews in last 1 year
Interview experience
View more
People are getting interviews through
based on 7 Oyo Rooms interviews
Campus Placement
Job Portal
57%
29%
14% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Interview Questions from Similar Companies
Fast track your campus placements
18%
more
than the average Business Analyst Salary in India
View more details
Oyo Rooms Business Analyst Reviews and Ratings
based on 26 reviews
Rating in categories
|
Business Development Manager
2.1k
salaries
|  ₹4.2 L/yr - ₹13 L/yr |
|
Demand Manager
908
salaries
| ₹3 L/yr - ₹9.3 L/yr |
|
Hotel Manager
566
salaries
| ₹1 L/yr - ₹5.1 L/yr |
|
Key Account Manager
554
salaries
| ₹3 L/yr - ₹10.5 L/yr |
|
Guest Relation Executive
464
salaries
| ₹0.9 L/yr - ₹4.2 L/yr |
Explore more salaries
Compare Oyo Rooms with
MakeMyTrip
Compare
Yatra
Compare
Treebo Hotels
Compare
FabHotels
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
- Home >
- Interviews >
- Oyo Rooms Interview Questions >
- Oyo Rooms Business Analyst Interview Questions
Share an Interview