Filter interviews by
Hackerrank - SQL and Statistics
How to make a regression model
False positive and false negative are terms used in data analysis to describe errors in classification models.
False positive refers to a situation where a test result incorrectly indicates the presence of a condition or attribute.
False negative refers to a situation where a test result incorrectly indicates the absence of a condition or attribute.
In medical field, false positive can occur when a healthy person is wrong...
Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.
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;
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
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
Basic aptitude question and 2 Sql question
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
based on 1 interview
Interview experience
Shift Supervisor
177
salaries
| ₹1.8 L/yr - ₹5 L/yr |
Store Manager
110
salaries
| ₹4.2 L/yr - ₹10 L/yr |
Barista Trainer
92
salaries
| ₹1.1 L/yr - ₹4 L/yr |
Shift Manager
84
salaries
| ₹2.1 L/yr - ₹4.6 L/yr |
Barista Coffee Maker
52
salaries
| ₹1 L/yr - ₹3.4 L/yr |
Oyo Rooms
Mahindra Holidays & Resorts
Marriott International
Oberoi Group of Hotels