Fareportal Senior Product Analyst Interview Questions and Answers

Sql questions- mainly around window functions and joins

How would you understand if suddenly order dropped by 20% for flipkart
Statistics questions as well

Q1. Basic and medium SQL
Add your answer

Q1. Product Case study with a check on business understanding
Add your answer

Q1. Multiple product case studies and puzzles. Resume walkthrough as well.
Add your answer

Q1. We observe that a small chunk of users get a majority of orders on meesho. Is this a problem and how would you go about solving this?
Add your answer

Q1. There is a problem of duplicate listings on meesho where multiple sellers list the same item. This causes a problem as users' search results have the same item listed multiple times. How would you go about...read more
Ans. 
Implement a system to detect and merge duplicate listings on Meesho platform.
• Utilize machine learning algorithms to identify similar listings based on product attributes and images.

• Implement a manual review process to verify potential duplicates before merging them.

• Provide incentives for sellers to report and merge duplicate listings.

• Regularly monitor and update the system to adapt to new duplicate listing patterns.

• Com...read more
Answered by AI
Add your answer

Q1. You are the PM at meta. How would you decrease the number of fraud posts?
Ans. 
Implement stricter verification processes, utilize AI for detection, and increase penalties for fraudsters.
• Implement stricter verification processes for account creation

• Utilize AI algorithms to detect patterns of fraudulent behavior

• Increase penalties for users found to be posting fraudulent content
Answered by AI
Add your answer

Increase Gpay txns by 5x

Q1. RCA of 5% drop in google docs
Ans. 
The Root Cause Analysis (RCA) of a 5% drop in Google Docs usage.
• Investigate recent changes or updates to Google Docs that may have caused user dissatisfaction.

• Analyze user feedback and reviews to identify any common issues or complaints.

• Check for any technical issues or bugs that may be affecting the performance of Google Docs.

• Review competitor products to see if there are any new features or improvements that may have...read more
Answered by AI
Add your answer

Q1. How will you improve uber ride experience
Ans. 
By implementing features such as real-time driver ratings, personalized recommendations, and improved driver training programs.
• Implement real-time driver ratings to ensure quality service

• Offer personalized recommendations based on user preferences and past rides

• Enhance driver training programs to improve professionalism and customer service

• Introduce in-app feedback system for continuous improvement
Answered by AI
Add your answer

Q1. Why do you want to join expedia
Add your answer

Group discussion: A collaborative conversation among individuals sharing ideas, opinions, and perspectives to explore topics, solve problems, or reach consensus.

Aptitude test: A standardized evaluation assessing an individual's innate abilities, skills, and talents to predict performance in a specific domain or profession.

Q1. What is distributed system
Ans. 
A distributed system is a collection of independent computers that appear to the users as a single coherent system.
• Consists of multiple computers connected through a network

• Allows for parallel processing and fault tolerance

• Examples include cloud computing, peer-to-peer networks, and distributed databases
Answered by AI
Add your answer
Q2. Jenkins to deploy the automation from git repo, procedure
Ans. 
Use Jenkins pipeline to deploy automation from git repo
• Create a Jenkins pipeline job

• Configure the job to pull code from the git repository

• Define the deployment steps in the Jenkinsfile

• Use Jenkins plugins like Git plugin and Pipeline plugin for automation

• Ensure proper permissions and credentials are set up for accessing the git repo
Answered by AI
Add your answer