Upload Button Icon Add office photos

Filter interviews by

Niraamaya Retreats Business Analyst Interview Questions and Answers

Updated 28 Jan 2025

Niraamaya Retreats Business Analyst Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
2-4 weeks
Result
No response

I was interviewed in Jul 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. Interview done from CEO
  • Q2. Un realistic questions
  • Q3. Rude behavior ceo
  • Q4. Multiple rounds of technical rounds conducted
  • Q5. Not doing interview because of some documents not provided.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't go to this company there is no professional growth. Only stress and zero learnings.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

SQL, General Aptitude Questions

Round 2 - Group Discussion 

10 minutes GD on general topics.

Round 3 - One-on-one 

(2 Questions)

  • Q1. Case study related tl hospitality industry
  • Q2. Questions related to POR held in college

Interview Preparation Tips

Interview preparation tips for other job seekers - Revise SQL & Case study
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Thapar Institute of Engineering and Technology (TIET) and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude question and 2 Sql question

Round 2 - Technical 

(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

Interview preparation tips for other job seekers - Take it easy
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected
Round 1 - Coding Test 

There were some aptitude question, Pandas question, SQL queries.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Use SQL to filter duplicate entries.
  • Ans. 

    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.

  • Answered by AI
  • Q2. Questions on Excel Shorcuts.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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)

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Oyo Rooms Business Analyst interview:
  • SQL
  • Excel
  • Aptitude
  • Puzzles
  • Case Studies

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Indian Institute of Technology (IIT), Kharagpur and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL Basic Question
  • Q2. SQL Medium Level Question
Round 2 - One-on-one 

(2 Questions)

  • Q1. Live SQL Programming
  • Q2. Live Pyhton Programming
Round 3 - One-on-one 

(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

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in May 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

SQL questions and logical reasoning

Round 3 - Technical 

(1 Question)

  • Q1. Talked about resume, projects and general questions of maths and logical reasoning
Round 4 - Case Study 

A guesstimate and a case study on profitability

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL Questions are asked, learn joins and aggregate functions
Round 2 - Case Study 

Simple Case Study was discussed

Round 3 - HR 

(1 Question)

  • Q1. Company fit check and salary expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Oyo has very bad work life balance, you might be expected to work on weekends as well.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Details discussion on Previous projects and Situation based questioning

Interview Preparation Tips

Interview preparation tips for other job seekers - What I realise is OYO doesn't have set way of taking interview, Every Hiring Manager takes his approach, so just focus on your key skill and Prepare you resume strong
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. SQL, and puzzles

Niraamaya Retreats Interview FAQs

How many rounds are there in Niraamaya Retreats Business Analyst interview?
Niraamaya Retreats interview process usually has 1 rounds. The most common rounds in the Niraamaya Retreats interview process are Technical.
What are the top questions asked in Niraamaya Retreats Business Analyst interview?

Some of the top questions asked at the Niraamaya Retreats Business Analyst interview -

  1. Not doing interview because of some documents not provid...read more
  2. Multiple rounds of technical rounds conduc...read more
  3. Un realistic questi...read more

Tell us how to improve this page.

Niraamaya Retreats Business Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Oyo Rooms Interview Questions
3.3
 • 217 Interviews
ITC Hotels Interview Questions
4.1
 • 85 Interviews
Burger King Interview Questions
3.8
 • 68 Interviews
Cafe Coffee Day Interview Questions
3.8
 • 60 Interviews
Hyatt Regency Interview Questions
4.1
 • 43 Interviews
Pizza Hut Interview Questions
3.9
 • 41 Interviews
View all
General Manager
7 salaries
unlock blur

₹8 L/yr - ₹22 L/yr

Account Assistant
5 salaries
unlock blur

₹2.4 L/yr - ₹3 L/yr

Graphic Designer
5 salaries
unlock blur

₹1.8 L/yr - ₹4.2 L/yr

Security Officer
4 salaries
unlock blur

₹3.3 L/yr - ₹3.6 L/yr

Assistant Manager Finance
4 salaries
unlock blur

₹5.4 L/yr - ₹6.5 L/yr

Explore more salaries
Compare Niraamaya Retreats with

Swashaa

4.0
Compare

Ananda in the Himalayas

4.1
Compare

Oberoi Group of Hotels

4.1
Compare

Taj Hotels Resorts and Palaces

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview