Upload Button Icon Add office photos

Filter interviews by

Cleartrip Data Analyst Interview Questions, Process, and Tips

Updated 11 Sep 2024

Top Cleartrip Data Analyst Interview Questions and Answers

View all 6 questions

Cleartrip Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Sep 2024

Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Explain Moving Average
  • Ans. 

    Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.

    • Moving Average helps in smoothing out fluctuations in data to identify trends over time.

    • It is calculated by taking the average of a specific number of data points within a defined window.

    • For example, a 3-day moving average for stock prices would be the average of the stock pri...

  • Answered by AI
  • Q2. Explain Decorators
  • Ans. 

    Decorators in Python are functions that modify the behavior of other functions.

    • Decorators are denoted by the @ symbol followed by the decorator function name.

    • They allow you to add functionality to an existing function without modifying its code.

    • Common use cases include logging, timing, and authentication.

    • Example: @decorator_function def function_to_decorate(): pass

  • Answered by AI
  • Q3. Explain Object Oriented Programming
  • Ans. 

    Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.

    • OOP focuses on creating objects that interact with each other to solve complex problems.

    • Objects have attributes (data) and methods (functions) that can manipulate the data.

    • Encapsulation, inheritance, and polymorphism are key principles of OOP.

    • Example: In a car simulation program, a 'Car' object can hav...

  • Answered by AI
  • Q4. Explain classes objects
  • Ans. 

    Classes are blueprints for creating objects in object-oriented programming.

    • Classes define the properties and behaviors of objects

    • Objects are instances of classes

    • Classes can inherit properties and behaviors from other classes

    • Classes can have constructors to initialize objects

    • Classes can have methods to perform actions

  • Answered by AI
  • Q5. Explain Functions
  • Ans. 

    Functions are blocks of code that perform a specific task and can be reused multiple times in a program.

    • Functions help in organizing code and making it more modular.

    • They can take input parameters and return output values.

    • Functions can be called multiple times from different parts of the program.

    • Examples: summing two numbers, finding the maximum value in a list.

  • Answered by AI
  • Q6. Pandas and Numpy
  • Q7. Swap L1 and L5 in a list
  • Ans. 

    Swap L1 and L5 in a list

    • Create a temporary variable to store the value of L1

    • Assign the value of L5 to L1

    • Assign the value of the temporary variable to L5

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cleartrip Data Analyst interview:
  • Advanced Python
  • Advanced SQL
  • Advanced Excel
Interview preparation tips for other job seekers - The Job Description Listed Excel, SQL Data Visualization as key skills and python would be an add on. But all questions were asked on advanced python which may not be relevant for data analysis.

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 May 2024

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

(1 Question)

  • Q1. Sql, advance Excel formulas

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate ProblemGiven an array/list of integer numbers 'CHOCOLAT ... read more
asked in Wipro
Q3. Ninja and substringsNinja has been given a string 'STR' containin ... read more
Q4. Maximum In Sliding Windows Of Size KGiven an array/list of intege ... read more
asked in Tredence
Q5. First Repeated CharacterYou are given a string 'STR' of lowercase ... read more

Interview questions from similar companies

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

(1 Question)

  • Q1. Introduction of yourself
Round 2 - Assignment 

Assignment of Google sheets

Round 3 - One-on-one 

(2 Questions)

  • Q1. Self introduction
  • Q2. What do you know about analysis and logical reasoning
  • Ans. 

    Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.

    • Analysis involves breaking down complex information into smaller components for better understanding.

    • Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.

    • Analytical skills are essential for interpreting data accurately and making informed d...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hello guys this company provide good salary but not good appraisal
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
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
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

Data Analyst Interview Questions & Answers

Tracxn user image Jaganmohan Reddy

posted on 22 Feb 2022

I applied via Walk-in and was interviewed before Feb 2021. There were 3 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 
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 experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Normal general questions, NLP based.
  • Q2. Lammitization and all related questions is there.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. The question was given based on join. Join two tables how will the no. of rows will differ with different joins.

Interview Preparation Tips

Topics to prepare for Amber Junior Data Analyst interview:
  • SQL
  • Excel

I applied via Referral

Round 1 - One-on-one 

(2 Questions)

  • Q1. Asked about my previous experiences & work & previous system which I was used?
  • Q2. Excel expertise question
  • Ans. I said I m normal in excel but able to perform all task
  • Answered by Akash Pandey

Interview Preparation Tips

Interview preparation tips for other job seekers - Reliance Netmeds where I was worked was handled by the third-party company named LCL(Lifecare Logistic) having 25 years of wider experience in the logistics sector.

I was gone with the references and because of that I got plus points & past e-commerce experiences & my confidence helped me to get a seat.

Cleartrip Interview FAQs

How many rounds are there in Cleartrip Data Analyst interview?
Cleartrip interview process usually has 1 rounds. The most common rounds in the Cleartrip interview process are Technical and One-on-one Round.
How to prepare for Cleartrip Data 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 Cleartrip. The most common topics and skills that interviewers at Cleartrip expect are Analytics, Data Analysis, Excel, Power Bi and Product Marketing.
What are the top questions asked in Cleartrip Data Analyst interview?

Some of the top questions asked at the Cleartrip Data Analyst interview -

  1. Explain Object Oriented Programm...read more
  2. Swap L1 and L5 in a l...read more
  3. Explain Moving Aver...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Cleartrip interview
Referral
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Cleartrip Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

4.0

Salary & Benefits

3.0

Job Security

5.0

Company culture

3.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 1 Review and Rating
Software Engineer
39 salaries
unlock blur

₹7 L/yr - ₹18.9 L/yr

Senior Software Engineer
34 salaries
unlock blur

₹8 L/yr - ₹33 L/yr

Assistant Manager
28 salaries
unlock blur

₹5.5 L/yr - ₹14.5 L/yr

Senior Executive
23 salaries
unlock blur

₹4 L/yr - ₹10.5 L/yr

Travel Consultant
22 salaries
unlock blur

₹1.8 L/yr - ₹6.2 L/yr

Explore more salaries
Compare Cleartrip with

MakeMyTrip

3.7
Compare

Yatra

3.4
Compare

Goibibo

4.3
Compare

Ixigo.com

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview