Shiprocket Private Limited Associate Product Manager Interview Questions and Answers

There was question on RCA

Sql hackereank test, moderate level including window function

Q1. Rca , strategy , product improvement
Add your answer

Same set of questions get repeated.

Q1. Asked 2-3 sql questions
Add your answer
Q2. Rank , dense rank and row number differnece
Ans. 
Rank, dense rank, and row number are different ways to assign a ranking to rows in a dataset.
• Rank assigns unique ranks to rows, leaving gaps if there are ties.

• Dense rank assigns unique ranks to rows without any gaps, even if there are ties.

• Row number simply assigns a unique sequential number to each row in the dataset.
Answered by AI
Add your answer

RCA How will you diagnose a dip in number of orders for an e-commerce company.

How will you introduce a search bar in a mobile application. open bar or a magnifier lense

Q1. Why Tata 1mg? What are your long term goals? Why Product Management
Add your answer

Q1. Salary discussion
Add your answer

SQL test of join type questions

Whats your favourite app

They asked about all the metrics that I'd track for whatsapp

Q1. Asked about how I'd improve Swiggy revenue
Add your answer

Round duration - 60 Minutes
The product round tested me on problem-solving, product, and guesstimate.

Q1. Understanding of A/B testing and hypothesis framing.
Add your answer
Q2. Design a camera for the elderly.
Ans. 
A camera designed for the elderly with easy-to-use features and large buttons.
• Large buttons for easy navigation

• Simple interface with limited options

• Lightweight and easy to hold

• Built-in flash for low-light situations

• Option to print photos directly from the camera
Answered by AI
Add your answer
Q3. Estimate the number of airplanes in the Indian sky at noon?
Ans. 
It is impossible to estimate the exact number of airplanes in the Indian sky at noon.
• The number of airplanes in the sky at any given time is constantly changing.

• Factors such as flight schedules, delays, cancellations, and weather conditions can affect the number of airplanes in the sky.

• There are also different types of airplanes, such as commercial, private, and military, which may have different flight patterns and sc...read more
Answered by AI
Add your answer
Q4. How could you use hashtags on Sharechat to drive engagement?
Ans. 
Hashtags can be used on Sharechat to drive engagement by categorizing content, increasing discoverability, and encouraging user participation.
• Create branded hashtags to promote campaigns and encourage user-generated content

• Use popular and relevant hashtags to increase discoverability and reach

• Encourage users to use hashtags in their posts and engage with others using the same hashtags

• Monitor hashtag performance and adj
Answered by AI
Add your answer