Filter interviews by
I applied via Approached by Company
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
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
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 ...
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
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...
I applied via Referral and was interviewed in May 2024. There were 2 interview rounds.
- coin probability
- math problem
- business case on influencing partner hotel to give more discount on the platform
- I was given the data to crack and give recommendation base on those data. There're around 4 days to crack the case. The key is available in Google Search.
There was a questions related to Excel, sql
I applied via Referral and was interviewed before May 2022. There were 3 interview rounds.
Hacker rank aor direct interview
I applied via Recruitment Consulltant and was interviewed before Mar 2022. There were 5 interview rounds.
Mettle Test based on DP based approach
Design a distributed queue similar to Kafka.
Use a distributed architecture with multiple brokers and partitions.
Implement a publish-subscribe model for producers and consumers.
Ensure fault tolerance and high availability through replication and leader election.
Use a log-based storage system for messages and offsets.
Provide support for message ordering and retention policies.
Implement a scalable and efficient message de...
Design a Price Tagger System
Identify the products to be tagged with prices
Determine the pricing strategy (e.g. cost-plus, value-based, etc.)
Choose the appropriate tagging technology (e.g. barcode, RFID, etc.)
Develop a user-friendly interface for tagging and updating prices
Implement a database to store product and pricing information
Integrate with point-of-sale systems for accurate pricing at checkout
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
1 hour in testing problem solving and basic math
Coding round with graph and tree questions
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
The rain water problem involves calculating the amount of rainwater that can be trapped between buildings or structures.
Calculate the maximum height of water that can be trapped at each position
Subtract the height of the building at each position to get the water level
Sum up the water levels at each position to get the total amount of trapped rainwater
Designing search systems involves creating efficient algorithms and data structures to quickly retrieve relevant information.
Understand the data structure of the search system (e.g. inverted index, trie)
Implement efficient search algorithms (e.g. binary search, hash tables)
Consider scalability and performance optimization techniques (e.g. caching, indexing)
Include user-friendly features like autocomplete and spell corr...
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
Basic coding test from hackerearth.
Some of the top questions asked at the Agoda Market Analyst interview -
based on 3 interviews
Interview experience
Software Engineer
31
salaries
| ₹15 L/yr - ₹52 L/yr |
Senior Software Engineer
31
salaries
| ₹25 L/yr - ₹74 L/yr |
Senior Product Manager
10
salaries
| ₹50 L/yr - ₹102 L/yr |
Engineering Manager
9
salaries
| ₹68 L/yr - ₹102.5 L/yr |
Software Developer
6
salaries
| ₹15 L/yr - ₹31.8 L/yr |
Udaan
BigBasket
Swiggy
CARS24