AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Novotel Hotels Data Analytics Consultant Interview Questions and Answers
Novotel Hotels Data Analytics Consultant Interview Experiences
1 interview found
Anonymous
I applied via Job Fair and was interviewed in Oct 2022. There were 2 interview rounds.
(6 Questions)
- Q1. App is phele job kha par Kiya
- Q2. Wa selery kya ti
- Q3. Wa job kiun chodi
- Q4. Aapki ya jo dege to aap kise karege
- Q5. Ya job rules follow karne padega
- Q6. Or Time follow karna padega
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement
Interview Preparation Tips
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
Shobhit Shrivas
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
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.
I applied via Referral and was interviewed before Oct 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About IHG history
- Q2. What you know about IHG?
- Ans.
IHG is a multinational hospitality company that owns and operates several hotel brands worldwide.
IHG stands for InterContinental Hotels Group
It was founded in 2003 and is headquartered in Denham, UK
IHG owns and operates several hotel brands including InterContinental, Crowne Plaza, Holiday Inn, and Kimpton Hotels & Restaurants
It has over 5,900 hotels in nearly 100 countries
IHG is one of the largest hotel companies in t
Interview Preparation Tips
Selected
(1 Question)
- Q1. Tell me about ur self, phase when u supported ur team, accruals, excel
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.
- 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;
Interview Preparation Tips
Skills evaluated in this interview
Saket Bihari
SQL, General Aptitude Questions
10 minutes GD on general topics.
(2 Questions)
- Q1. Case study related tl hospitality industry
- Q2. Questions related to POR held in college
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in May 2023. There were 4 interview rounds.
SQL questions and logical reasoning
(1 Question)
- Q1. Talked about resume, projects and general questions of maths and logical reasoning
A guesstimate and a case study on profitability
Selected
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
(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
- 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...
- 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)
Interview Preparation Tips
- SQL
- Excel
- Aptitude
- Puzzles
- Case Studies
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. SQL, and puzzles
Novotel Hotels Interview FAQs
Tell us how to improve this page.
Novotel Hotels Interviews By Designations
- Novotel Hotels Workshop Supervisor Interview Questions
- Novotel Hotels Waiter Interview Questions
- Novotel Hotels Safety Officer Interview Questions
- Novotel Hotels Executive Assistant Interview Questions
- Novotel Hotels Chef DE Cuisine Interview Questions
- Novotel Hotels Commis Chef Interview Questions
- Novotel Hotels Restaurant Captain Interview Questions
- Novotel Hotels Store Keeper Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Data Analytics Intern Interview Questions
- Analytics Consultant Interview Questions
- IT (Data Analytics) Interview Questions
- Decision Analytics Associate Interview Questions
- Data Analytics Engineer Interview Questions
- Data Analytics Lead Interview Questions
- Analytics Engineer Interview Questions
- Show more
Novotel Hotels Data Analytics Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Guest Service Associate
60
salaries
|  ₹1 L/yr - ₹3.2 L/yr |
|
Commis Chef
25
salaries
| ₹1 L/yr - ₹3.6 L/yr |
|
Team Lead
21
salaries
| ₹2.2 L/yr - ₹3.7 L/yr |
|
Housekeeping Supervisor
19
salaries
| ₹1.8 L/yr - ₹4 L/yr |
|
Food & Beverage Associate
18
salaries
| ₹1.2 L/yr - ₹4.5 L/yr |
Oyo Rooms
Mahindra Holidays & Resorts
Oberoi Group of Hotels
Hyatt Regency
- Home >
- Interviews >
- Novotel Hotels Interview Questions >
- Novotel Hotels Data Analytics Consultant Interview Questions
