i
Ihg Group
Filter interviews by
Top trending discussions
I applied via Campus Placement
I applied via Campus Placement
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
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.
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;
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
My name is John Smith.
Full name is John Smith
Common first and last name combination
Easy to remember and pronounce
Guesstimate and behavioral question
SQL, General Aptitude Questions
10 minutes GD on general topics.
I applied via Campus Placement and was interviewed in May 2023. There were 4 interview rounds.
SQL questions and logical reasoning
A guesstimate and a case study on profitability
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
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
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...
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)
I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.
based on 41 reviews
Rating in categories
Senior Analyst
245
salaries
| ₹3.4 L/yr - ₹7.5 L/yr |
Specialist
203
salaries
| ₹5.1 L/yr - ₹9.5 L/yr |
Team Lead
149
salaries
| ₹5.1 L/yr - ₹14.5 L/yr |
Analyst
113
salaries
| ₹2.8 L/yr - ₹5 L/yr |
Assistant Manager
99
salaries
| ₹8 L/yr - ₹22.5 L/yr |
Oyo Rooms
Oberoi Group of Hotels
Marriott International
Hyatt Regency