Upload Button Icon Add office photos

Yatra

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Yatra Production Analyst Interview Questions and Answers

Updated 9 Sep 2024

Yatra Production Analyst Interview Experiences

1 interview found

Production Analyst Interview Questions & Answers

user image VENUS DHARMIK

posted on 9 Sep 2024

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

(5 Questions)

  • Q1. What is your name?
  • Ans. 

    My name is John Smith.

    • My first name is John.

    • My last name is Smith.

    • I go by the name John Smith.

  • Answered by AI
  • Q2. Your branch in college?
  • Ans. 

    I majored in Business Administration with a focus on Operations Management.

    • Studied courses like Supply Chain Management, Production Planning, and Inventory Control

    • Participated in case competitions related to optimizing production processes

    • Completed internships at manufacturing companies to gain hands-on experience

  • Answered by AI
  • Q3. What is your fathers name?
  • Ans. 

    My father's name is John Smith.

    • His first name is John.

    • His last name is Smith.

    • He goes by the name John Smith.

    • He is known as Mr. Smith in his workplace.

  • Answered by AI
  • Q4. Write a sql code for having
  • Ans. 

    SQL code for having clause

    • Use the HAVING clause to filter groups based on aggregate functions

    • It is used with the GROUP BY clause

    • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

  • Answered by AI
  • Q5. What is the difference between where and having
  • Ans. 

    WHERE is used to filter rows before grouping or aggregating, while HAVING is used to filter groups after grouping or aggregating.

    • WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

    • HAVING is used with GROUP BY clause to filter groups based on a condition

    • WHERE is applied before the grouping operation, while HAVING is applied after the grouping operation

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - notting very simple to join this company

Skills evaluated in this interview

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 Resume 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.

Analyst Interview Questions & Answers

Airbnb user image Pornima Kolte

posted on 4 Mar 2024

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How to sort ararat
  • Ans. 

    Ararat can be sorted alphabetically or numerically.

    • Sort alphabetically: Arrange in ascending order based on the letters in the word.

    • Sort numerically: Arrange in ascending order based on the numerical value of each character.

  • Answered by AI

Skills evaluated in this interview

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
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql, advance Excel formulas
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

Analyst Interview Questions & Answers

Oyo Rooms user image Sushant Dogra

posted on 2 Nov 2015

I applied via Campus Placement

Interview Preparation Tips

Round: Puzzle Interview
Experience: basic Guesstimation questtions,
for eg. estimate the no of sleeping all over the world right now.

Tips: Walk the interviewer through your thinking process.
donot make vague guesses.

Round: HR Interview
Experience: 1 Tell us 5 reasons why we should hire you.
2 being an electrical engineering student, why have you applied for a analytic s/operations job profile.

Skills: Ability To Cope Up With Stress, Guesstimation Cases
Duration: 2
College Name: IIT Madras

Analyst Interview Questions & Answers

Oyo Rooms user image Shobhit Shrivas

posted on 1 Nov 2015

I applied via Campus Placement

Interview Questionnaire 

7 Questions

  • Q1. I was asked 2 questions from a course called principle of economics, such as what is elasticity etc
  • Q2. It was again from my course work they asked me how to solve linear programming problem graphically
  • Q3. Then they asked me to tell me about my self
  • Q4. They asked me to estimate number of microwaves manufactured in india per year
  • Q5. Then I was asked what is my biggest achivement till now
  • Q6. Then I was asked if I have any question for them
  • Q7. He gave me 15 min to convence him so that he hirs me for his company

Interview Preparation Tips

Round: Resume Shortlist
Experience: They were mainly looking for people who has or worked in Start ups or who has some good PORs. They also shortlisted students with CGPA of more than 7.5.
Tips: Try taking good PORs and maintain a healthy CGPA. Make a one page resume.

Round: Technical Interview
Experience: It was good. This was my first interview, I was bit nurvous for obvious reasons but controlled my emotions perfectly. As interview progressed things started becoming normal.
Tips: Be confidant of what ever you speak. Try hidding you nervousness, its okay if you are not able to answer any question but make strong comeback in next.

Round: HR Interview
Experience: I was very confidant of myself and told some 8-9 qualities that I have and gave examples of where I used them in past.
Tips: Again be very confidant. Its okay if you fumble in between but make strong comeback. look into the eyes of interviewer it shows you are confidant. Don't lie, be yourself.

General Tips: Keep working hard, there is no subsitute of hardwork, even in IITs. And don't forget sometimes you have to loose small battels to win Wars.
All the best:)
Skills:
Duration: 8-10weeks
College Name: IIT Madras
Motivation: Oyo is progressing very fast and I wanted to be the part of there amazing journey.
Funny Moments: I kept looking into the eyes of both of my interviewer just to show them I was very confidant but the reality is I was very nervous and I was bluffing them:). After interview I had a headache.

I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. How your work will increase our revenue? By sharing the data we can improve our services.
  • Ans. 

    Sharing data insights can help improve services and identify revenue opportunities.

    • Analyzing customer behavior can help identify areas for improvement

    • Identifying trends in sales data can help optimize pricing strategies

    • Using data to personalize marketing efforts can increase customer engagement

    • Predictive modeling can help identify potential revenue opportunities

    • Tracking key performance indicators can help optimize busi

  • Answered by AI
  • Q2. Do you believe in the overtime if yes then why? I don believe in the rare cases we should help our team mates

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay cool and be optimistic.

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Extract the oyo from domain name in google sheets.
  • Ans. 

    Extract 'oyo' from domain name in Google Sheets.

    • Use the formula =REGEXEXTRACT(A1, "oyo") where A1 is the cell containing the domain name.

    • This will extract the first occurrence of 'oyo' in the domain name.

    • If 'oyo' appears multiple times, use =REGEXEXTRACT(A1, "oyo", 2) for the second occurrence, and so on.

  • Answered by AI
  • Q2. Time. Time() in sql
  • Ans. 

    Time() is a SQL function that returns the current system date and time.

    • Time() can be used in SELECT, INSERT, UPDATE, and DELETE statements.

    • The returned value is in the format 'YYYY-MM-DD HH:MI:SS'.

    • Timezone can affect the returned value.

    • Example: SELECT Time() AS CurrentTime;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be spotenous.

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Yatra Interview FAQs

How many rounds are there in Yatra Production Analyst interview?
Yatra interview process usually has 1 rounds. The most common rounds in the Yatra interview process are HR.
What are the top questions asked in Yatra Production Analyst interview?

Some of the top questions asked at the Yatra Production Analyst interview -

  1. what is the difference between where and hav...read more
  2. write a sql code for hav...read more

Recently Viewed

PHOTOS

Medanta the Medicity

4 office photos

INTERVIEWS

Novascotia Boutique Homes

No Interviews

LIST OF COMPANIES

Oyo Rooms

Locations

INTERVIEWS

Yatra

No Interviews

JOBS

Goibibo

No Jobs

REVIEWS

RedBus

No Reviews

SALARIES

Goibibo

INTERVIEWS

Yatra

No Interviews

INTERVIEWS

RedBus

No Interviews

SALARIES

Goibibo

Tell us how to improve this page.

Yatra Production Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Oyo Rooms Interview Questions
3.3
 • 217 Interviews
MakeMyTrip Interview Questions
3.7
 • 122 Interviews
BCD Travel Interview Questions
4.3
 • 111 Interviews
Expedia Group Interview Questions
3.8
 • 75 Interviews
Thomas Cook Interview Questions
3.7
 • 44 Interviews
Airbnb Interview Questions
3.8
 • 23 Interviews
Thrillophilia Interview Questions
3.8
 • 22 Interviews
Cleartrip Interview Questions
3.4
 • 18 Interviews
View all
Yatra Production Analyst Salary
based on 4 salaries
₹4 L/yr - ₹7.8 L/yr
49% less than the average Production Analyst Salary in India
View more details
Senior Travel Consultant
226 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
219 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Travel Consultant
115 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
111 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Yatra with

MakeMyTrip

3.6
Compare

Cleartrip

3.4
Compare

Goibibo

4.3
Compare

Oyo Rooms

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