i
Ihg Group
Filter interviews by
I applied via Referral and was interviewed in Jul 2022. There was 1 interview round.
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.
There were some aptitude question, Pandas question, SQL queries.
Use SQL query with DISTINCT keyword to filter duplicate entries.
Use SELECT DISTINCT column_name FROM table_name;
DISTINCT keyword removes duplicate values from the result set.
For example, SELECT DISTINCT name FROM employees;
You can also use GROUP BY clause to eliminate duplicates.
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
Simple Case Study was discussed
based on 40 reviews
Rating in categories
Senior Analyst
256
salaries
| ₹3.4 L/yr - ₹8.3 L/yr |
Specialist
207
salaries
| ₹5.1 L/yr - ₹11 L/yr |
Team Lead
149
salaries
| ₹5.1 L/yr - ₹14 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