AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Apollo 247 Interview Questions and Answers
7 Interview questions
Quick commerce system design involves creating a platform for fast delivery of goods and services.
Focus on real-time order processing and delivery logistics
Implement efficient inventory management system
Integrate with payment gateways for seamless transactions
Utilize geolocation services for accurate delivery tracking
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.
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 sc...
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
I would invest in real estate, start a business, travel the world, and donate to charity.
Invest in real estate to generate passive income
Start a business to create job opportunities
Travel the world to experience different cultures
Donate to charity to give back to the community
A supportive work environment, growth opportunities, and alignment with company values will keep me engaged for five years.
Opportunities for professional development, such as training programs or certifications, to enhance my skills.
A clear career progression path that allows me to take on more responsibilities and advance within the organization.
A positive work culture that promotes teamwork, collaboration, and o...
Create a media plan for a new skincare product launch with a budget of $100,000.
Identify target audience (women aged 25-45)
Select relevant media channels (social media, beauty magazines)
Allocate budget accordingly (50% on social media ads, 30% on magazine ads, 20% on influencer partnerships)
Create engaging content and visuals to attract attention
Monitor and analyze campaign performance for optimization
Apollo 247 Interview Experiences
20 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
Selected
I applied via Naukri.com
(1 Question)
- Q1. About previous work experience, CTC, Why do I want to switch etc
Confendential cannot be disclosed have signed NDA
(2 Questions)
- Q1. Questions based on case study
- Q2. Questions based on excel
(1 Question)
- Q1. Telephonic round with HOD. What will it take to keep you here for 5 years
- Ans.
A supportive work environment, growth opportunities, and alignment with company values will keep me engaged for five years.
Opportunities for professional development, such as training programs or certifications, to enhance my skills.
A clear career progression path that allows me to take on more responsibilities and advance within the organization.
A positive work culture that promotes teamwork, collaboration, and open c...
Interview Preparation Tips
LC Easy type mostly on linear data structures.
(2 Questions)
- Q1. System design a quick commerce. (HLD)
- Ans.
Quick commerce system design involves creating a platform for fast delivery of goods and services.
Focus on real-time order processing and delivery logistics
Implement efficient inventory management system
Integrate with payment gateways for seamless transactions
Utilize geolocation services for accurate delivery tracking
- Q2. In Depth Node.js questions
Interview Preparation Tips
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
I appeared for an interview in Oct 2024, where I was asked the following questions.
- Q1. Resume based questions
- Q2. Category based growth questions
Interview Preparation Tips
Atul Tiwari
Selected
I appeared for an interview in Oct 2024, where I was asked the following questions.
- Q1. Previous organisations details
- Q2. Communications and business
I applied via Referral and was interviewed in Dec 2023. There were 2 interview rounds.
(1 Question)
- Q1. CV Based questions were asked
(1 Question)
- Q1. Behavioral Questions were asked
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
They give a topic and start the discussion
(2 Questions)
- Q1. What if u get 1million dollars
- Ans.
I would invest in real estate, start a business, travel the world, and donate to charity.
Invest in real estate to generate passive income
Start a business to create job opportunities
Travel the world to experience different cultures
Donate to charity to give back to the community
- Q2. What do u do when u became celebrity
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Apr 2023. There were 4 interview rounds.
A detailed assignment with a very short turnaround time
(3 Questions)
- Q1. With team lead mostly informing about no work life balance, and asking very unprofessional questions like: Do you plan to get married in the next 1,2 and 3 year?
- Q2. Do you have any fixed time when you have to be home?
- Ans.
No, I do not have any fixed time to be home.
As a content manager, my work requires me to be flexible with my time.
I prioritize completing my tasks and meeting deadlines over fixed timings.
However, I ensure to communicate with my team and make necessary arrangements if I need to be away for an extended period.
I am committed to delivering quality work and meeting the expectations of my employer.
- Q3. Do you have a problem working on weekends?
- Ans.
No, I don't have a problem working on weekends.
I understand that sometimes work demands require working on weekends
I am willing to put in extra effort to meet deadlines
I am flexible with my schedule and can adjust accordingly
(1 Question)
- Q1. Most unprofessional round, where before rolling out an offer, HR is asking for previous company's offer letter or asking for HR/MANAGER contact details. A company can ask for reference - this isn't standar...
Interview Preparation Tips
(2 Questions)
- Q1. What was last assignment and achievement
- Q2. Impact you will bring to Indian healthcare
Top trending discussions
Apollo 247 Interview FAQs
The duration of Apollo 247 interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Apollo 247 Interviews By Designations
- Apollo 247 Product Manager Interview Questions
- Apollo 247 Business Development 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 Team Manager Interview Questions
- Apollo 247 Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 24 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Apollo 247 Reviews and Ratings
based on 206 reviews
Rating in categories
10-13 Yrs
Not Disclosed
12-15 Yrs
Not Disclosed
6-8 Yrs
Not Disclosed
|
Senior Software Engineer
53
salaries
|  ₹20 L/yr - ₹35.5 L/yr |
|
Pharmacist
44
salaries
| ₹2 L/yr - ₹4 L/yr |
|
Associate Product Manager
40
salaries
| ₹8.8 L/yr - ₹35 L/yr |
|
Product Manager
40
salaries
| ₹24.8 L/yr - ₹43 L/yr |
|
Business Development Manager
35
salaries
| ₹5 L/yr - ₹10.2 L/yr |
State Street Syntel
AXA Business Services
MagicBricks
Chegg
- Home >
- Interviews >
- Apollo 247 Interview Questions
