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

Clear (1)

Oyo Rooms Analyst Interview Questions and Answers

Updated 16 Sep 2024

Oyo Rooms Analyst Interview Experiences

5 interviews found

Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Sep 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is your greatest ahievement?
  • Ans. 

    My greatest achievement was leading a team to successfully launch a new product ahead of schedule and under budget.

    • Led a team to launch a new product ahead of schedule

    • Managed project under budget

    • Received recognition for successful project completion

  • Answered by AI
  • Q2. What is your name?
  • Ans. 

    My name is John Smith.

    • Full name is John Smith

    • Common first and last name combination

    • Easy to remember and pronounce

  • Answered by AI

Analyst Interview Questions & Answers

user image Anonymous

posted on 6 Oct 2022

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 Resume tips
Round 2 - Aptitude Test 

Guesstimate and behavioral question

Round 3 - One-on-one 

(2 Questions)

  • Q1. Basic discussion around your experience
  • Q2. Last internship or college extra currics

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for guesstimates and talk around your experience

Analyst Interview Questions Asked at Other Companies

asked in Capgemini
Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, you ... read more
asked in Deloitte
Q2. Reverse a Number Problem Statement Given an integer 'N', write a ... read more
Q3. A 10x10x10 cube is made up of 1x1x1 cubes. Its outer surface is p ... read more
Q4. Ninja and the Game of Words In this game, Ninja is provided with ... read more
Q5. Good old standard problem: Playing number game with your friend t ... read more

Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Jun 2021

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Extract the oyo from domain name in google sheets.
  • Ans. 

    Extract 'oyo' from domain name in Google Sheets.

    • Use the formula =REGEXEXTRACT(A1, "oyo") where A1 is the cell containing the domain name.

    • This will extract the first occurrence of 'oyo' in the domain name.

    • If 'oyo' appears multiple times, use =REGEXEXTRACT(A1, "oyo", 2) for the second occurrence, and so on.

  • Answered by AI
  • Q2. Time. Time() in sql
  • Ans. 

    Time() is a SQL function that returns the current system date and time.

    • Time() can be used in SELECT, INSERT, UPDATE, and DELETE statements.

    • The returned value is in the format 'YYYY-MM-DD HH:MI:SS'.

    • Timezone can affect the returned value.

    • Example: SELECT Time() AS CurrentTime;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be spotenous.

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Shobhit Shrivas

posted on 1 Nov 2015

I applied via Campus Placement

Interview Questionnaire 

7 Questions

  • Q1. I was asked 2 questions from a course called principle of economics, such as what is elasticity etc
  • Q2. It was again from my course work they asked me how to solve linear programming problem graphically
  • Q3. Then they asked me to tell me about my self
  • Q4. They asked me to estimate number of microwaves manufactured in india per year
  • Q5. Then I was asked what is my biggest achivement till now
  • Q6. Then I was asked if I have any question for them
  • Q7. He gave me 15 min to convence him so that he hirs me for his company

Interview Preparation Tips

Round: Resume Shortlist
Experience: They were mainly looking for people who has or worked in Start ups or who has some good PORs. They also shortlisted students with CGPA of more than 7.5.
Tips: Try taking good PORs and maintain a healthy CGPA. Make a one page resume.

Round: Technical Interview
Experience: It was good. This was my first interview, I was bit nurvous for obvious reasons but controlled my emotions perfectly. As interview progressed things started becoming normal.
Tips: Be confidant of what ever you speak. Try hidding you nervousness, its okay if you are not able to answer any question but make strong comeback in next.

Round: HR Interview
Experience: I was very confidant of myself and told some 8-9 qualities that I have and gave examples of where I used them in past.
Tips: Again be very confidant. Its okay if you fumble in between but make strong comeback. look into the eyes of interviewer it shows you are confidant. Don't lie, be yourself.

General Tips: Keep working hard, there is no subsitute of hardwork, even in IITs. And don't forget sometimes you have to loose small battels to win Wars.
All the best:)
Skills:
Duration: 8-10weeks
College Name: IIT Madras
Motivation: Oyo is progressing very fast and I wanted to be the part of there amazing journey.
Funny Moments: I kept looking into the eyes of both of my interviewer just to show them I was very confidant but the reality is I was very nervous and I was bluffing them:). After interview I had a headache.

Oyo Rooms interview questions for designations

 Business Analyst

 (9)

 Data Analyst

 (1)

 Revenue Analyst

 (1)

 Senior Data Analyst

 (1)

 Business Analyst Intern

 (1)

 BDM

 (3)

 Product Manager

 (3)

 Guest Relation Executive

 (2)

Analyst Interview Questions & Answers

user image Sushant Dogra

posted on 2 Nov 2015

I applied via Campus Placement

Interview Preparation Tips

Round: Puzzle Interview
Experience: basic Guesstimation questtions,
for eg. estimate the no of sleeping all over the world right now.

Tips: Walk the interviewer through your thinking process.
donot make vague guesses.

Round: HR Interview
Experience: 1 Tell us 5 reasons why we should hire you.
2 being an electrical engineering student, why have you applied for a analytic s/operations job profile.

Skills: Ability To Cope Up With Stress, Guesstimation Cases
Duration: 2
College Name: IIT Madras

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. About the industry

Interview Preparation Tips

Interview preparation tips for other job seekers - Have an idea about the travel industry before you go for the interview.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - Coding Test 

I was asked with SQL querying questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Set of questions related to excel.
  • Q2. Vlookup, sumifs, pivot tables
Round 3 - HR 

(2 Questions)

  • Q1. Related to past work experience.
  • Q2. Scenario based questions related to business industry.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Guestimates, sql questions

Round 2 - Coding Test 

Sql questions geeks for geeks

Interview Preparation Tips

Interview preparation tips for other job seekers - Not very tough on skillset but grilled on business cases
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 Resume 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 Questionnaire 

17 Questions

  • Q1. Find if a string is substring of other string
  • Ans. 

    The function checks if a string is a substring of another string.

    • Use the built-in string methods like 'indexOf' or 'includes' to check for substring.

    • If the language supports regular expressions, you can also use them to find substrings.

    • Consider the case sensitivity of the strings when comparing.

  • Answered by AI
  • Q2. Write a code to multiply two matrices of dimension M*N and N*K
  • Ans. 

    Code to multiply two matrices of dimension M*N and N*K.

    • Create a result matrix of dimension M*K.

    • Iterate through each row of the first matrix.

    • For each row, iterate through each column of the second matrix.

    • For each element in the row of the first matrix, multiply it with the corresponding element in the column of the second matrix.

    • Sum up the products and store the result in the corresponding position of the result matrix.

    • ...

  • Answered by AI
  • Q3. Write a Sql to perform Matrix Multiplication.Two tables has three columns row,col and value
  • Ans. 

    SQL query to perform matrix multiplication using two tables with row, col, and value columns.

    • Use JOIN operation to combine the two tables based on matching row and col values.

    • Use GROUP BY clause to group the result by row and col values.

    • Use SUM function to calculate the dot product of corresponding row and col values.

    • Use INSERT INTO statement to insert the result into a new table.

  • Answered by AI
  • Q4. What is prototype in javascript?
  • Ans. 

    Prototype in JavaScript is an object that is associated with every function and object by default.

    • Prototype is used to add properties and methods to an object.

    • It allows objects to inherit properties and methods from other objects.

    • Modifying the prototype of a function affects all instances of that function.

    • Prototypes can be used to create new objects based on existing objects.

    • The prototype chain allows for property and

  • Answered by AI
  • Q5. How do we write classes in javascript?
  • Ans. 

    Classes in JavaScript are written using the class keyword.

    • Use the class keyword followed by the class name to define a class.

    • Use the constructor method to initialize class properties.

    • Add methods to the class using the class prototype.

    • Use the new keyword to create an instance of the class.

  • Answered by AI
  • Q6. There is a ladder of N steps.We can either take 1 step or 2 steps.In how many different ways one can climb the ladder?
  • Ans. 

    The number of different ways to climb a ladder of N steps by taking 1 or 2 steps at a time.

    • This is a classic problem that can be solved using dynamic programming.

    • The number of ways to climb N steps is equal to the sum of the number of ways to climb N-1 steps and N-2 steps.

    • The base cases are when N is 0 or 1, where there is only 1 way to climb the ladder.

    • For example, for N=4, there are 5 different ways: [1, 1, 1, 1], [1

  • Answered by AI
  • Q7. Print a square matrix in spiral order
  • Ans. 

    Print a square matrix in spiral order

    • Start by defining the boundaries of the matrix

    • Iterate through the matrix in a spiral pattern, printing each element

    • Adjust the boundaries after each iteration to move inward

    • Repeat until all elements are printed

  • Answered by AI
  • Q8. Given a table with 3 columns StudentName,Subject and Marks.Write a sql to retrieve second highest Marks Obtained for each student
  • Ans. 

    Retrieve the second highest marks obtained by each student from a table with student name, subject, and marks.

    • Use the RANK() function to assign a rank to each row based on the marks in descending order.

    • Filter the result to only include rows with rank 2 for each student.

    • Group the result by student name to get the second highest marks for each student.

  • Answered by AI
  • Q9. Given a Website with header,footer,side ads(Google ads,Internal ads).How will you extract only useful data from the page
  • Q10. Difference between .live() and .delegate() in jquery
  • Ans. 

    The .live() method attaches an event handler to the current and future elements, while .delegate() attaches an event handler to a parent element.

    • The .live() method is deprecated in newer versions of jQuery.

    • The .delegate() method is preferred over .live() for performance reasons.

    • Both methods are used to handle events for dynamically added elements.

    • Example: $(document).live('click', 'button', function() { ... });

    • Example:...

  • Answered by AI
  • Q11. What is chaining in jquery?
  • Ans. 

    Chaining in jQuery allows multiple methods to be called on a single element in a single line of code.

    • Chaining simplifies code and improves readability.

    • Each method in the chain operates on the result of the previous method.

    • The chain ends with a method that does not return a jQuery object.

    • Example: $('div').addClass('highlight').fadeOut();

  • Answered by AI
  • Q12. What is callback function?
  • Ans. 

    A callback function is a function that is passed as an argument to another function and is executed later.

    • Callback functions are commonly used in event-driven programming.

    • They allow asynchronous execution of code.

    • Callback functions can be used to handle responses from APIs or user interactions.

    • They can be anonymous functions or named functions.

    • Example: setTimeout(function() { console.log('Hello!'); }, 1000);

  • Answered by AI
  • Q13. What is .bind() function in jquery?
  • Ans. 

    The .bind() function in jQuery is used to attach an event handler function to one or more elements.

    • It allows you to specify the event type and the function to be executed when the event occurs.

    • The .bind() function can be used to bind multiple events to the same element.

    • It can also be used to pass additional data to the event handler function.

    • The .bind() function is deprecated in jQuery version 3.0 and above. It is reco

  • Answered by AI
  • Q14. Find the angle between hour handle and minute handle in a clock
  • Ans. 

    The angle between the hour and minute hands of a clock can be calculated using a formula.

    • The hour hand moves 30 degrees per hour and 0.5 degrees per minute.

    • The minute hand moves 6 degrees per minute.

    • Calculate the angle between the two hands using the formula: |30H - 11M/2|, where H is the hour and M is the minute.

  • Answered by AI
  • Q15. Is it possible to create slideshow without using javascript
  • Ans. 

    Yes, it is possible to create a slideshow without using JavaScript.

    • Use CSS animations and transitions to create the slideshow.

    • Use HTML and CSS to structure and style the slideshow.

    • Utilize keyframe animations to create the slide transitions.

    • Use radio buttons or checkboxes to control the slideshow navigation.

    • Apply the :target pseudo-class to create a simple slideshow without JavaScript.

  • Answered by AI
  • Q16. Questions about my current project and academic project
  • Q17. Given two points A and B with distance between them lets say D.there are N men who want to go from point A to point B.All men walk with same speed.They also have one scooter with them which has speed grea...
  • Ans. 

    The men can take turns riding the scooter, allowing them to reach point B faster.

    • The men can form a queue and take turns riding the scooter.

    • The person riding the scooter can drop it off at a certain point and the next person can pick it up.

    • The scooter can be passed along the line of men until everyone reaches point B.

  • Answered by AI

Interview Preparation Tips

Skills: Algorithm, Javascript
College Name: na

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Oyo Rooms Interview FAQs

How many rounds are there in Oyo Rooms Analyst interview?
Oyo Rooms interview process usually has 2 rounds. The most common rounds in the Oyo Rooms interview process are Resume Shortlist, Aptitude Test and One-on-one Round.
How to prepare for Oyo Rooms 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 Analytical, Dashboards, Data Interpretation, Data Visualization and Excel.
What are the top questions asked in Oyo Rooms Analyst interview?

Some of the top questions asked at the Oyo Rooms Analyst interview -

  1. Extract the oyo from domain name in google sheet...read more
  2. Time. Time() in ...read more
  3. I was asked 2 questions from a course called principle of economics, such as wh...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

DESIGNATION

DESIGNATION

INTERVIEWS

Air India

No Interviews

INTERVIEWS

Oyo Rooms

No Interviews

DESIGNATION

INTERVIEWS

BlackBuck

No Interviews

INTERVIEWS

BlackBuck

No Interviews

INTERVIEWS

Ninjacart

No Interviews

Tell us how to improve this page.

Oyo Rooms Analyst Interview Process

based on 1 interview

1 Interview rounds

  • Technical Round
View more

Interview Questions from Similar Companies

MakeMyTrip Interview Questions
3.7
 • 122 Interviews
Burger King Interview Questions
3.8
 • 69 Interviews
Pizza Hut Interview Questions
3.9
 • 43 Interviews
Hyatt Regency Interview Questions
4.2
 • 43 Interviews
JW Marriott Interview Questions
4.2
 • 39 Interviews
View all
Oyo Rooms Analyst Salary
based on 31 salaries
₹4.1 L/yr - ₹15 L/yr
56% more than the average Analyst Salary in India
View more details

Oyo Rooms Analyst Reviews and Ratings

based on 4 reviews

2.3/5

Rating in categories

1.4

Skill development

2.5

Work-life balance

2.3

Salary

1.6

Job security

1.9

Company culture

1.7

Promotions

2.3

Work satisfaction

Explore 4 Reviews and Ratings
Business Development Manager
1.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Demand Manager
845 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Hotel Manager
503 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Key Account Manager
482 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Guest Relation Executive
402 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Oyo Rooms with

MakeMyTrip

3.7
Compare

Yatra

3.4
Compare

Treebo Hotels

3.3
Compare

FabHotels

3.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent