Upload Button Icon 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 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Oyo Rooms Business Analyst Interview Questions and Answers for Experienced

Updated 30 Aug 2024

Oyo Rooms Business Analyst Interview Experiences for Experienced

2 interviews found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(4 Questions)

  • Q1. What are the use cases of self-join?
  • Ans. 

    Self-join is used to join a table with itself to compare rows within the same table.

    • Used to compare rows within the same table

    • Helps in retrieving hierarchical data

    • Can be used to find employees who report to the same manager

  • Answered by AI
  • Q2. How to extract nth highest salary?
  • Q3. What are the critical KPIs to be monitored after creating a new website?
  • Ans. 

    Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.

    • Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.

    • Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.

    • Bounce Rate: Measure the percentage of visitors who leave the website after vi...

  • Answered by AI
  • Q4. What would be the probability of getting at least one six after throwing 2 unbiased dice?
  • Ans. 

    The probability of getting at least one six after throwing 2 unbiased dice is 11/36.

    • The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)

    • The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Oyo Rooms Business Analyst interview:
  • SQL
  • Excel
  • Aptitude
  • Puzzles
  • Case Studies

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Details discussion on Previous projects and Situation based questioning

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

Business Analyst Interview Questions Asked at Other Companies for Experienced

Q1. How would you sell a simple pen for 1 lakh.
asked in HCLTech
Q2. 5. In certain condition you are not able to achieve the target of ... read more
Q3. 1. What are different requirements Gathering technique?
asked in Wipro
Q4. What is the difference between Saving and current account
Q5. In an organisation where standard costing is implemented, why is ... read more

Business Analyst Jobs at Oyo Rooms

View all

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Quant,Logical Reasoning

Round 2 - Assignment 

Simple Aptitude and Case study

Round 1 - One-on-one 

(5 Questions)

  • Q1. What did you learn in your internship
  • Q2. What's happening in the world , India or whats in the news
  • Q3. Share a situation when you handled guest
  • Q4. Tell us about the hotel where you trained
  • Q5. What do you know about the Oberoi
Round 2 - One-on-one 

(1 Question)

  • Q1. Technical Questions department specific

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and genuine, grooming is important
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - One-on-one 

(2 Questions)

  • Q1. How will you handle veg nonveg concern ?
  • Q2. How to handle angary customer?
  • Ans. 

    Handling an angry customer requires active listening, empathy, and a willingness to find a solution.

    • Listen actively to the customer's concerns without interrupting them

    • Empathize with the customer's frustration and acknowledge their feelings

    • Apologize for any inconvenience caused and take responsibility for finding a solution

    • Offer a solution that meets the customer's needs and expectations

    • Follow up with the customer to e

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - to Use of Leads producer to handle to handle the customer in good way
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(3 Questions)

  • Q1. Introduction and about my experience
  • Q2. Technical questions about service
  • Q3. Why you want to join hyatt?
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Mar 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - One-on-one 

(3 Questions)

  • Q1. Tell me about your journey or (if experienced) then tell me your career journey.
  • Ans. 

    I have had a diverse career journey that has prepared me for the role of Team Lead.

    • Started my career as a software engineer, gaining technical expertise in various programming languages.

    • Progressed to a senior developer role, where I led small teams and mentored junior developers.

    • Took on project management responsibilities, ensuring successful delivery of complex projects.

    • Transitioned into a team lead role, overseeing a...

  • Answered by AI
  • Q2. Why do you think you are a fit for the job?
  • Ans. 

    I have strong leadership skills and experience in managing teams.

    • I have successfully led a team of 10 members in my previous role.

    • I have excellent communication and problem-solving skills.

    • I am highly organized and able to prioritize tasks effectively.

    • I have a proven track record of meeting deadlines and achieving targets.

    • I am passionate about mentoring and developing team members.

  • Answered by AI
  • Q3. What are your key strengths?
  • Ans. 

    My key strengths include leadership, communication, and problem-solving skills.

    • I have experience leading teams in various projects and ensuring their success.

    • I am an effective communicator and can convey complex ideas clearly and concisely.

    • I am skilled in problem-solving and can think creatively to find solutions to challenges.

    • I am adaptable and can handle changing priorities and deadlines with ease.

    • I am a quick learne...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and clear with your answers also working environment is perfect to work as a fresher.

Interview Questionnaire 

4 Questions

  • Q1. Do you know the English language property
  • Ans. 

    Yes

    • The English language is a West Germanic language that originated in England.

    • It is the third most spoken language in the world, with over 1.3 billion speakers.

    • English has a large vocabulary and is known for its complex grammar rules.

    • It is the official language of many countries and widely used in international communication.

    • English has various dialects and accents, including British English, American English, and Aus

  • Answered by AI
  • Q2. Yes I know English language
  • Q3. What additude you carry
  • Ans. 

    I carry a positive and proactive attitude towards my work and team.

    • I believe in leading by example and always strive to maintain a positive outlook.

    • I am proactive in identifying and addressing challenges, finding solutions, and motivating my team to do the same.

    • I foster a collaborative and supportive environment where everyone feels valued and motivated.

    • I am open to feedback and continuously seek opportunities for pers...

  • Answered by AI
  • Q4. How many skills you have

Interview Preparation Tips

Interview preparation tips for other job seekers - Please wear formal dress carry a positive attitude and be fresh and energetic
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic Php ,Oops
Round 2 - Technical 

(1 Question)

  • Q1. Security questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Join if you don't have only offer in your hand
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Use of model in laravel
  • Ans. 

    Models in Laravel are used to interact with the database and represent data.

    • Models in Laravel are used to perform database operations such as retrieving, inserting, updating, and deleting data.

    • Models help in organizing and structuring the data in the application.

    • Models in Laravel follow the MVC (Model-View-Controller) pattern.

    • Example: Creating a User model in Laravel to interact with the users table in the database.

  • Answered by AI
  • Q2. SQL get highest salary for employee
Round 2 - Technical 

(2 Questions)

  • Q1. SQL joins and types of joins
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN returns rows when there is at least one match in both tables.

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

    • F...

  • Answered by AI
  • Q2. What is self join and realted question
Round 3 - HR 

(1 Question)

  • Q1. Previous projects and contributions

Skills evaluated in this interview

Oyo Rooms Interview FAQs

How many rounds are there in Oyo Rooms Business Analyst interview for experienced candidates?
Oyo Rooms interview process for experienced candidates usually has 1-2 rounds. The most common rounds in the Oyo Rooms interview process for experienced candidates are Resume Shortlist, Technical and One-on-one Round.
How to prepare for Oyo Rooms Business Analyst interview for experienced candidates?
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, Data Analytics, Analytics and Data Mining.
What are the top questions asked in Oyo Rooms Business Analyst interview for experienced candidates?

Some of the top questions asked at the Oyo Rooms Business Analyst interview for experienced candidates -

  1. What would be the probability of getting at least one six after throwing 2 unbi...read more
  2. What are the critical KPIs to be monitored after creating a new websi...read more
  3. What are the use cases of self-jo...read more
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 Business Analyst Interview Process for Experienced

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Burger King Interview Questions
3.8
 • 72 Interviews
Hyatt Regency Interview Questions
4.2
 • 44 Interviews
Pizza Hut Interview Questions
3.9
 • 43 Interviews
JW Marriott Interview Questions
4.2
 • 41 Interviews
Tata Starbucks Interview Questions
4.3
 • 39 Interviews
View all
Oyo Rooms Business Analyst Salary
based on 277 salaries
₹5 L/yr - ₹17.5 L/yr
11% more than the average Business Analyst Salary in India
View more details

Oyo Rooms Business Analyst Reviews and Ratings

based on 30 reviews

3.5/5

Rating in categories

3.7

Skill development

2.9

Work-life balance

3.3

Salary

3.3

Job security

3.1

Company culture

3.0

Promotions

3.3

Work satisfaction

Explore 30 Reviews and Ratings
Business Development Manager
1.6k salaries
unlock blur

₹4.4 L/yr - ₹14.5 L/yr

Demand Manager
834 salaries
unlock blur

₹3 L/yr - ₹9.6 L/yr

Key Account Manager
454 salaries
unlock blur

₹3 L/yr - ₹10.5 L/yr

Hotel Manager
440 salaries
unlock blur

₹1 L/yr - ₹4.5 L/yr

Guest Relation Executive
389 salaries
unlock blur

₹0.9 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Oyo Rooms with

Jubilant Foods Works

3.7
Compare

Mahindra Holidays & Resorts

3.5
Compare

Oberoi Group of Hotels

4.0
Compare

Marriott International

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview