AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Hilton Data Analyst Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
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.
(1 Question)
- Q1. Basic 1-on-1 round with your manager/ or any senior from the company
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 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
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
Guesstimate and behavioral question
(2 Questions)
- Q1. Basic discussion around your experience
- Q2. Last internship or college extra currics
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. SQL, and puzzles
Selected
I applied via Campus Placement and was interviewed before Aug 2023. There were 3 interview rounds.
(2 Questions)
- Q1. SQL Basic Question
- Q2. SQL Medium Level Question
(2 Questions)
- Q1. Live SQL Programming
- Q2. Live Pyhton Programming
(2 Questions)
- Q1. Case Study related to hotel industry
- Q2. Root cause analysis of a scenario
- Ans.
Root cause analysis involves identifying the underlying reason for a problem or issue.
Identify the problem or issue that needs to be analyzed
Gather relevant data and information related to the problem
Use tools like fishbone diagram or 5 Whys to dig deeper into the root cause
Consider all possible factors that could have contributed to the problem
Develop a plan to address the root cause and prevent future occurrences
(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
- 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
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
Basic aptitude question and 2 Sql question
(4 Questions)
- Q1. 2 Sql question i on joins and other on window function
- Q2. 1 Guestimate 1 Puzzle
- Q3. Intoduction about your self
- Q4. About your resume and interest
Interview Preparation Tips
Tell us how to improve this page.
Hilton Interviews By Designations
- Hilton Chef DE Partie Interview Questions
- Hilton Management Trainee Interview Questions
- Hilton HR Executive Interview Questions
- Hilton Maintenance Engineer Interview Questions
- Hilton Director Engineering Interview Questions
- Hilton Business Analyst Interview Questions
- Hilton Industrial Trainee Interview Questions
- Hilton Food & Beverage Supervisor Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Guest Service Associate
45
salaries
|  ₹1 L/yr - ₹4.5 L/yr |
|
Food & Beverage Executive
31
salaries
| ₹2.4 L/yr - ₹4.5 L/yr |
|
Housekeeping Executive
27
salaries
| ₹2 L/yr - ₹6 L/yr |
|
Commis Chef
21
salaries
| ₹1.5 L/yr - ₹3.2 L/yr |
|
Assistant Manager
17
salaries
| ₹3.6 L/yr - ₹7.8 L/yr |
Oyo Rooms
Mahindra Holidays & Resorts
Oberoi Group of Hotels
Marriott International
- Home >
- Interviews >
- Hilton Interview Questions >
- Hilton Data Analyst Interview Questions
