Round 1
Questions: Two medium level questions were asked, one related to arrays and the other related to Sliding Window.
Candidate's Approach
The candidate was able to solve the questions quickly and code them out. The interviewer appeared satisfied with the approach, and the interview finished before the allotted time.
Interviewer's Feedback
No feedback provided.
Round 2
Questions: The interview question was based on a reconciliation system. The scenario was as follows:
Agoda provides APIs to external platforms to use Agoda's backend for hotel booking. The data is stored at both Agoda's end and the external platform's end.
Schema:
Activity Table (Agoda):
- activity_id
- activity (room bought, bed bought)
- currency
- price
- timestamp
Example:
123, room, USD, 120, 26th Dec 123, bed, USD, 20, 26th Dec
External Platform Activity Table:
- offer_id
- activity_id
- activity (room bought, bed bought)
- currency
- price
- timestamp
The activity_id has referential integrity in the second table.
The task was to reconcile the price at a specific interval and detect any anomalies, showing them to relevant stakeholders.
Candidate's Approach
The candidate provided a design for the reconciliation system but struggled to solve many edge cases due to limited knowledge of reconciliation systems.
Interviewer's Feedback
No feedback provided.
Verdict: The candidate received a rejection after a few days, as expected, because the design did not go very well.
Additional Notes: It is important to note that while the DSA rounds are easy medium level, the other rounds are of a higher difficulty. Communication is crucial due to the different accent of the interviewers, but they are helpful, which is a positive aspect.