Novotel India Revenue Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Revenue Analyst in travel, hospitality and food service helps hotels and restaurants decide the right price to charge for rooms and tables each day, using past booking data, demand forecasts and competitor rates. You will track occupancy, average daily rate (ADR) and revenue per available room (RevPAR), run reports, and suggest pricing or package changes to managers. The role sits between finance, sales and operations, so you need strong Excel skills and a comfort with numbers.

Role and technical knowledge

1. 1

   What is RevPAR and how is it different from ADR?

   Explain that RevPAR = ADR x occupancy, or total room revenue divided by available rooms. ADR only looks at average room rate, while RevPAR shows how well you fill rooms at that rate.

2. 2

   How would you calculate occupancy for a 200-room hotel that sold 140 rooms last night?

   Show the math: 140 / 200 = 70 percent. Mention that you would also check if any rooms were out of order or complimentary, as those affect true occupancy.

3. 3

   What is pick-up analysis and why does it matter for a hotel?

   Pick-up is the change in bookings over a period, usually compared to the same time last year or to the forecast. It helps you decide whether to raise or lower rates as the arrival date gets closer.

4. 4

   Name three guest segments a hotel like Novotel might track and how their pricing needs differ.

   Mention corporate, leisure and group/OTA. Corporate may need fixed negotiated rates, leisure is more price-sensitive on weekends, and groups often get bulk discounts but fill low-demand periods.

Practical scenarios

1. 5

   Your hotel has 60 percent occupancy for next Saturday, but a big cricket match is announced nearby. What do you do?

   Say you would check historical demand for similar events, raise rates gradually, close low-rate OTA channels, and monitor pick-up daily. Also consider minimum-stay restrictions if demand spikes.

2. 6

   A competitor hotel drops its room rate by 20 percent for the coming week. How do you respond?

   Do not match blindly. Check your own occupancy, segment mix and remaining inventory. If you are already filling rooms, hold rate; if you are empty, consider a targeted promotion or value-add instead of a straight discount.

3. 7

   The restaurant is seeing low footfall on Tuesday and Wednesday evenings. What revenue ideas would you suggest?

   Suggest a Tuesday-Wednesday set menu, a local corporate happy hour, or a family discount. Mention tracking covers, average check and table turnover to measure if the idea works.

4. 8

   You notice a sudden spike in cancellations for a long weekend. What steps do you take?

   First check if it is a system error or a real trend. Then review cancellation policy, re-open discounted rates to fill rooms, and alert the sales team to push packages to past guests.

Behavioural and situational questions

1. 9

   Tell me about a time you had to explain a number or a mistake to a senior person.

   Use a simple STAR structure. Show that you stayed calm, admitted the error, and came with a fix or a learning. Hospitality values honesty and quick recovery.

2. 10

   You are asked to prepare a last-minute revenue report for a manager who is leaving for a meeting. How do you handle it?

   Show prioritisation: confirm the key metrics needed, use a template if available, double-check the numbers, and send a clear one-page summary rather than a messy file.

3. 11

   Describe a time you worked in a team where someone was not doing their share.

   Focus on how you communicated privately, offered help, and kept the team goal in mind. Avoid blaming; show you can work with different personalities.

4. 12

   Why do you want to work in revenue management for a hotel or restaurant rather than a general finance role?

   Connect your interest in daily decision-making, guest behaviour and fast feedback. Mention that you like seeing the direct impact of pricing on occupancy and revenue.

HR and fit questions

1. 13

   Are you comfortable working shifts, weekends or odd hours during peak season?

   Be honest. Hospitality revenue teams often start early to check pick-up or stay late for month-end. If you can be flexible, say so and give an example of adapting to a schedule.

2. 14

   What do you know about Novotel and its parent company, Accor?

   Show basic research: Novotel is a mid-scale brand under Accor, present in major Indian cities, and serves both business and leisure guests. Mention that revenue decisions differ by location and guest mix.

3. 15

   Where do you see yourself in two to three years in revenue management?

   Show a realistic path: start as an analyst, learn the systems and segments, then move to a revenue manager role for a single property or a cluster. Avoid saying you want to leave hospitality soon.

4. 16

   What is your expected salary for this fresher role?

   Research typical entry-level revenue analyst pay in Indian hospitality, give a modest range, and say you are open to learning and growth. Do not quote a number far above market without justification.