Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Ixigo.com Team. If you also belong to the team, you can get access from here

Ixigo.com Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Ixigo.com Business Analyst Interview Questions and Answers

Updated 10 Nov 2024

Ixigo.com Business Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Guestimates, sql questions

Round 2 - Coding Test 

Sql questions geeks for geeks

Interview Preparation Tips

Interview preparation tips for other job seekers - Not very tough on skillset but grilled on business cases

Interview questions from similar companies

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 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
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - Coding Test 

I was asked with SQL querying questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Set of questions related to excel.
  • Q2. Vlookup, sumifs, pivot tables
Round 3 - HR 

(2 Questions)

  • Q1. Related to past work experience.
  • Q2. Scenario based questions related to business industry.
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
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
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

Ixigo.com Interview FAQs

How many rounds are there in Ixigo.com Business Analyst interview?
Ixigo.com interview process usually has 2 rounds. The most common rounds in the Ixigo.com interview process are Aptitude Test and Coding Test.
How to prepare for Ixigo.com 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 Ixigo.com. The most common topics and skills that interviewers at Ixigo.com expect are Python, SQL, Data Visualization, Google Analytics and Business Analysis.

Tell us how to improve this page.

Ixigo.com Business Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Ixigo.com Business Analyst Salary
based on 4 salaries
₹9 L/yr - ₹25 L/yr
65% more than the average Business Analyst Salary in India
View more details
Software Engineer
35 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer2
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Manager
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Ixigo.com 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