Agoda Interview Questions, Process, and Tips

Three set of alooba tests: 1. Stats/Excel/Aptitude 2. Two SQL coding questions (basic query writing and one join query writing) 3. Talk about a topic: describe your favourite place? 3 mins

Q1. Tell me about yourself
Add your answer
Q2. I was asked about one of the projects i worked on
Add your answer
Q3. Motivation behind joining agoda
Add your answer
Q4. Salary compensation
Add your answer

Q1. Write a formula to calculate 1 year cashback offers cost to Agoda?
Ans. 
The formula to calculate 1 year cashback offers cost to Agoda.
• Calculate the total cashback amount for each offer

• Multiply the cashback amount by the number of customers who will avail the offer

• Sum up the total cashback costs for all offers
Answered by AI
View 1 more answer
Q2. 3 KPIs which impacts a customer to use Agoda rewards?
Ans. 
The three key performance indicators (KPIs) that impact a customer to use Agoda rewards are: savings, convenience, and loyalty.
• Savings: Customers are motivated to use Agoda rewards because it offers them the opportunity to save money on their bookings.

• Convenience: Agoda rewards provide customers with a seamless and hassle-free booking experience, making it convenient for them to use the platform.

• Loyalty: Agoda rewards ...read more
Answered by AI
Add your answer
Q3. 3 strategies to improve Agoda's customer base via offers
Ans. 
Three strategies to improve Agoda's customer base via offers
• 1. Personalized offers based on customer preferences and past bookings

• 2. Exclusive discounts and promotions for loyal customers

• 3. Collaborations with travel influencers and bloggers to promote Agoda offers
Answered by AI
Add your answer
Q4. A/B testing: given two test cases each with 50% customers, A: 1000 bookings and B 20% more bookings than A, cashback for A: 4 dollars per booking, redemption rate: 50% Cashback for B: 6 dollars per booking...read more
Ans. 
Calculate profit per day for A and B given A/B testing results and cashback details.
• Calculate the profit for test case A by subtracting the commission and cashback from the total bookings.

• Calculate the profit for test case B by considering the increased bookings and higher cashback.

• Multiply the cashback by the redemption rate to get the effective cashback per booking.

• Multiply the effective cashback by the number of boo...read more
Answered by AI
Add your answer

DSA: Longest substring with unique char

Q1. Longest substring with unique char
Ans. 
Find the longest substring with unique characters in an array of strings.
• Iterate through each string in the array

• Use a set to keep track of unique characters in the current substring

• Update the longest substring length when encountering a duplicate character
Answered by AI
Add your answer
Q2. HLD for showing history of web page
Ans. 
Design a High Level Diagram (HLD) for displaying the history of a web page.
• Use a database to store historical data of the web page

• Implement a version control system to track changes

• Display historical versions with timestamps on the web page

• Allow users to revert to previous versions if needed
Answered by AI
Add your answer

A test was given to complete

Q1. Details about experience
Add your answer
Q2. Product management experience
Add your answer

Q1. Intro about yourself
Add your answer
Q2. Case study for ecommerce
Add your answer

Q1. Questions on Array and binary search
Add your answer
Q2. General frontend specific questions
Add your answer
Q3. HR related questions
Add your answer

SQL coding round of 60 mins

Q1. Case study about product company
Add your answer
Q2. Discussion around experience in previous roles
Add your answer

Sliding window problem

Q1. Design leaderboard
Add your answer