AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Apollo 247 Production Analyst Interview Questions and Answers
Apollo 247 Production Analyst Interview Experiences
2 interviews found
Anonymous
I applied via Referral and was interviewed in May 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Basic SQL 2 table join question
- Q2. Probability of bullet firing if 3 bullets are placed consecutively in a gun
- Ans.
The probability of a bullet firing when 3 bullets are placed consecutively in a gun is 1/3.
The probability of each bullet firing is independent of the others, assuming the gun is functioning properly.
Each bullet has a 1/3 chance of firing when the trigger is pulled.
This is assuming all bullets are loaded and the gun is in working condition.
(2 Questions)
- Q1. Difference between rank, dense rank and row number
- Ans.
Rank assigns a unique number to each row based on a specified column, Dense Rank assigns consecutive numbers without gaps, Row Number assigns a unique number to each row in the result set.
Rank function may have gaps in the ranking sequence if there are ties.
Dense Rank function does not have gaps in the ranking sequence.
Row Number function assigns a unique number to each row in the result set.
Example: If we have scores ...
- Q2. 3 SQL window function questions
How would you explain XYZ to a layman?
then a guesstimate on no. of orders delivered by Swiggy in bangalore in a month
What are your strengths as a product analyst
Interview Preparation Tips
- SQL
- Product Strategy
- Guesstimate
- Aptitude
Skills evaluated in this interview
Shuvam Jaiswal
(3 Questions)
- Q1. Probality Questions and SQL difference between left join and join
- Q2. Guesstimate: Number of orders on swiggy in day
- Ans.
Approximately 1 million orders per day on Swiggy
Consider the population of the city where Swiggy operates
Look at the average number of orders per person per day
Factor in peak hours and weekends for higher order volumes
- Q3. Past experiences
Interview questions from similar companies
Product Manager Interview Questions & Answers
Airtel Payments Bank
Veenal Bansal
posted on 4 Sep 2024
(1 Question)
- Q1. How would you improve recharge metrics for airtel thanks app
- Ans.
To improve recharge metrics for airtel thanks app, focus on user experience, personalized recommendations, and seamless payment options.
Enhance user experience by simplifying the recharge process and reducing the number of steps required.
Implement personalized recommendations based on user's recharge history and preferences.
Offer seamless payment options such as saved payment methods, digital wallets, and UPI integrati...
Selected
I applied via Referral and was interviewed before Jan 2022. There were 4 interview rounds.
Related to the domain for which I applied.
(1 Question)
- Q1. Product related questions and scenario base discussion.
(1 Question)
- Q1. Salary and grade discussion
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Mar 2023. There was 1 interview round.
Launch a new vertical for Blinkit
Interview Preparation Tips
Improve revenue for MB platform
(2 Questions)
- Q1. Guesstimate - Number of shampoo sold in India
- Ans.
Approximately 1.5 billion bottles of shampoo are sold in India annually.
India has a population of over 1.3 billion people, with a large percentage using shampoo regularly.
Assuming an average person uses one bottle of shampoo per month, the estimated number of bottles sold annually is around 1.5 billion.
Factors such as income levels, hair type, and cultural practices may affect the usage of shampoo in different regions
- Q2. Product Design - Netflix for kids
Interview Preparation Tips
Deepika J
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
It is about maths, logical question and grammar.
Divya D
Selected
I appeared for an interview in Sep 2024, where I was asked the following questions.
- Q1. Tell me about yourself
- Q2. What do you know about insurance
- Q3. Tell me about your education and qualifications
- Ans.
I hold a degree in Economics and have completed various certifications in data analysis and financial modeling.
Bachelor's degree in Economics from XYZ University, where I graduated with honors.
Completed a certification in Data Analysis from ABC Institute, focusing on statistical methods and software tools.
Participated in a financial modeling workshop, applying theoretical knowledge to real-world scenarios.
Interned at D...
Interview Preparation Tips
Anupam Choubey
Basic questions of accounts and capital markets
(1 Question)
- Q1. Basic details of myself
(4 Questions)
- Q1. Question on capital market.
- Q2. What are option derivative.
- Ans.
Option derivatives are financial instruments that derive their value from an underlying asset, such as stocks or commodities.
Option derivatives give the holder the right, but not the obligation, to buy or sell the underlying asset at a specified price within a certain time frame.
There are two types of option derivatives: call options, which give the holder the right to buy the underlying asset, and put options, which g...
- Q3. What are types of derivative.
- Ans.
Types of derivatives include options, futures, forwards, and swaps.
Options: contracts that give the holder the right, but not the obligation, to buy or sell an asset at a specified price before or on a specified date.
Futures: contracts that obligate the buyer to purchase an asset or the seller to sell an asset at a predetermined future date and price.
Forwards: agreements between two parties to buy or sell an asset at a...
- Q4. What is call and put in options
- Ans.
Call and put options are types of financial contracts that give the holder the right, but not the obligation, to buy or sell an asset at a specified price before a certain date.
A call option gives the holder the right to buy an asset at a specified price within a certain timeframe.
A put option gives the holder the right to sell an asset at a specified price within a certain timeframe.
Call options are used by investors ...
I applied via Referral and was interviewed in Oct 2023. There were 2 interview rounds.
Maths, english, logical resoning was tested
(1 Question)
- Q1. Basic question about company
Interview Preparation Tips
Apollo 247 Interview FAQs
Tell us how to improve this page.
Apollo 247 Interviews By Designations
- Apollo 247 Product Manager Interview Questions
- Apollo 247 Production Analyst Interview Questions
- Apollo 247 Senior Marketing Manager Interview Questions
- Apollo 247 Manager Interview Questions
- Apollo 247 Sales Officer Interview Questions
- Apollo 247 Senior Software Engineer Interview Questions
- Apollo 247 Team Manager Interview Questions
- Apollo 247 Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Production Engineer Interview Questions
- Production Supervisor Interview Questions
- Production Manager Interview Questions
- Production Officer Interview Questions
- Executive Production Interview Questions
- Production Interview Questions
- Senior Production Engineer Interview Questions
- Production Graduate Engineer Trainee Interview Questions
- Show more
Apollo 247 Production Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
|
Senior Software Engineer
50
salaries
|  ₹16.5 L/yr - ₹43 L/yr |
|
Pharmacist
43
salaries
| ₹2 L/yr - ₹4 L/yr |
|
Associate Product Manager
37
salaries
| ₹8.6 L/yr - ₹35 L/yr |
|
Product Manager
35
salaries
| ₹17 L/yr - ₹48 L/yr |
|
Business Development Manager
34
salaries
| ₹5 L/yr - ₹11 L/yr |
MagicBricks
State Street Syntel
Sterling & Wilson
AXA Business Services
- Home >
- Interviews >
- Apollo 247 Interview Questions >
- Apollo 247 Production Analyst Interview Questions
