Upload Button Icon Add office photos

TravelTriangle

Compare button icon Compare button icon Compare

Filter interviews by

TravelTriangle Business Analyst Interview Questions and Answers

Updated 6 Nov 2019

TravelTriangle Business Analyst Interview Experiences

1 interview found

Business Analyst Interview Questions & Answers

user image Snigdh Khandelwal

posted on 6 Nov 2019

I applied via Referral and was interviewed before Nov 2018. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Advanced sql queries related to dense rank, row num, self joins, pivoting, case studies, visualization questions, puzzles, questions on probability

Interview Preparation Tips

Interview preparation tips for other job seekers - Relax and go with open minds

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 8 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 - HR 

(1 Question)

  • Q1. They will ask about your profile and past experience.
Round 3 - Technical 

(1 Question)

  • Q1. A peer level colleague will ask some basic knowledge check questions
Round 4 - Coding Test 

This is literally a live coding test. For analytics expect SQL, python, R.

Round 5 - One-on-one 

(1 Question)

  • Q1. Interviewed by a manager of another team
Round 6 - One-on-one 

(1 Question)

  • Q1. Interviewed by dotted line reporting manager
Round 7 - One-on-one 

(1 Question)

  • Q1. Cross functional interview
Round 8 - One-on-one 

(1 Question)

  • Q1. Core Values Interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the core values, remember them, understand them and embody them. And being good at your advertised skills also helps.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. About the industry

Interview Preparation Tips

Interview preparation tips for other job seekers - Have an idea about the travel industry before you go for the interview.
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
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
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 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
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
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement 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
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

TravelTriangle Interview FAQs

How to prepare for TravelTriangle Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at TravelTriangle. The most common topics and skills that interviewers at TravelTriangle expect are SQL, Bigquery, Business Analysis, Business Reporting and CCTV Monitoring.

Tell us how to improve this page.

Interview Questions from Similar Companies

Oyo Rooms Interview Questions
3.3
 • 218 Interviews
MakeMyTrip Interview Questions
3.6
 • 122 Interviews
Expedia Group Interview Questions
3.8
 • 75 Interviews
Thomas Cook Interview Questions
3.7
 • 44 Interviews
Yatra Interview Questions
3.4
 • 31 Interviews
Airbnb Interview Questions
3.8
 • 23 Interviews
Treebo Hotels Interview Questions
3.3
 • 22 Interviews
Cleartrip Interview Questions
3.4
 • 18 Interviews
KrazyBee Interview Questions
3.7
 • 14 Interviews
View all
TravelTriangle Business Analyst Salary
based on 9 salaries
₹6.1 L/yr - ₹16 L/yr
5% more than the average Business Analyst Salary in India
View more details
Travel Consultant
151 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Travel Consultant
68 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Accounts Manager
52 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
44 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Executive
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare TravelTriangle with

MakeMyTrip

3.7
Compare

Yatra

3.4
Compare

Cleartrip

3.4
Compare

Goibibo

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