Upload Button Icon Add office photos

Cleartrip

Compare button icon Compare button icon Compare

Filter interviews by

Cleartrip Applications Engineer Interview Questions and Answers

Updated 20 Feb 2024

Cleartrip Applications Engineer Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Design a flight booking system with flight inventory and funds
  • Ans. 

    Design a flight booking system with flight inventory and funds

    • Create a database to store flight inventory including flight details, availability, and pricing

    • Implement a user interface for customers to search for flights, select seats, and make bookings

    • Incorporate a payment gateway for customers to pay for their bookings

    • Include a feature for managing funds, tracking payments, and generating invoices

    • Implement a notificat...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cleartrip Applications Engineer interview:
  • Springboot
  • Java
  • Microservices
  • Design
Interview preparation tips for other job seekers - Prepare for building a microservice with in memory db

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Assignment 

Sql based test.. question on python

Round 2 - Coding Test 

Sql based coding test

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

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
  • Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
  • Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through some questions for interview on data analyst role and read those, this thing will help you to understand many concepts. Not very hard interview also the interviewer is helpful.

Data Analyst Interview Questions & Answers

Impact Guru user image Shubham Upadhyay

posted on 19 Apr 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Difference between rank and dense rank
  • Ans. 

    Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.

    • Rank assigns unique ranks to each distinct value in a dataset

    • Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

    • For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3

  • Answered by AI
  • Q2. How will merge multiple file in python
  • Ans. 

    Merge multiple files in Python using pandas.concat() or pd.merge() functions.

    • Use pandas.concat() function to merge multiple files vertically (row-wise).

    • Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

    • Ensure that the files have compatible column names and data types before merging.

    • Handle any missing or duplicate values appropriately during the merging process.

    • Consider ...

  • Answered by AI
  • Q3. Data frame explain in detail
  • Ans. 

    A data frame is a two-dimensional data structure in which data is stored in rows and columns.

    • Data frames are commonly used in programming languages like R and Python for data analysis.

    • Each column in a data frame represents a variable, while each row represents an observation.

    • Data frames can contain different types of data, such as numeric, character, and factor.

    • Data frames can be created from various sources like CSV f

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Dec 2021. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. When I initially joined my job right after college there was a point where I was constantly
  • Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
  • Q3. Opportunity great time interest must
Round 2 - Group Discussion 

Group discussion can also provide feedback to instructors on participant comprehension.

Interview Preparation Tips

Interview preparation tips for other job seekers - Job search like it's your job look for opportunities

I applied via Walk-in and was interviewed before Feb 2021. There were 3 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 - Aptitude Test 
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - easy to crack they will ask qestions

Interview Questionnaire 

2 Questions

  • Q1. SQL and Excel were the key that helped me get this job.
  • Q2. Puzzles
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in May 2023. There were 3 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 - Assignment 

Send assignment doings MS Excel

Round 3 - Technical 

(2 Questions)

  • Q1. Asked about the previous project
  • Q2. What about your roles in previous company

Interview Preparation Tips

Topics to prepare for Zolo Data Analyst interview:
  • Excel
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Coding Test 

The test lasted about an hour and included data structures, algorithms and basic problem solving.

Round 2 - One-on-one 

(2 Questions)

  • Q1. What some projects you've worked on before and how have you helped improve efficiency?
  • Ans. 

    I have worked on various data analysis projects, focusing on improving efficiency through data-driven insights and automation.

    • Developed a dashboard for sales data analysis, reducing report generation time by 50%.

    • Automated data cleaning processes, which decreased manual effort by 30 hours per month.

    • Implemented predictive analytics for inventory management, leading to a 20% reduction in stockouts.

    • Conducted A/B testing fo...

  • Answered by AI
  • Q2. Introduce yourself
  • Ans. 

    Data Analyst with a passion for transforming data into actionable insights, skilled in SQL, Python, and data visualization tools.

    • Educational Background: Bachelor's degree in Statistics, where I developed a strong foundation in data analysis techniques.

    • Technical Skills: Proficient in SQL for database management and data extraction, and Python for data manipulation and analysis.

    • Experience: Worked on a project analyzing c...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Feb 2025, where I was asked the following questions.

  • Q1. What is your current skills
  • Q2. Your salary requirements

Cleartrip Interview FAQs

How many rounds are there in Cleartrip Applications Engineer interview?
Cleartrip interview process usually has 1 rounds. The most common rounds in the Cleartrip interview process are Technical.

Tell us how to improve this page.

Cleartrip Applications Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

MagicBricks Interview Questions
4.4
 • 256 Interviews
Tracxn Interview Questions
3.2
 • 102 Interviews
Zolo Interview Questions
3.4
 • 53 Interviews
Netmeds.com Interview Questions
3.6
 • 42 Interviews
Carwale Interview Questions
3.5
 • 41 Interviews
Uplers Interview Questions
4.0
 • 41 Interviews
Impact Guru Interview Questions
3.7
 • 40 Interviews
Yahoo Interview Questions
4.6
 • 29 Interviews
BookMyShow Interview Questions
4.0
 • 25 Interviews
View all
Software Engineer
37 salaries
unlock blur

₹7 L/yr - ₹15.5 L/yr

Assistant Manager
32 salaries
unlock blur

₹5.5 L/yr - ₹14.5 L/yr

Senior Software Engineer
30 salaries
unlock blur

₹9.2 L/yr - ₹33 L/yr

Travel Consultant
22 salaries
unlock blur

₹1.8 L/yr - ₹6.2 L/yr

Senior Executive
21 salaries
unlock blur

₹4 L/yr - ₹13.5 L/yr

Explore more salaries
Compare Cleartrip with

MakeMyTrip

3.7
Compare

MagicBricks

4.4
Compare

Videocon d2h

3.9
Compare

Netmeds.com

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