Agoda Senior+ Data Engineer Interview Experience — Reschedule Red Flag, Then Five Questions in Under 20 Minutes

I applied cold just to see what would happen, and got an OA the very next day (I think it was one SQL question and one Java question, don't quite remember).

The phone interview was originally scheduled for last week evening to match their daytime hours, but when it came time, the interviewer's HackerRank was broken and wouldn't open.

It got rescheduled last-minute to this week, which felt like a huge red flag — was nobody getting interviewed before this?

Bottom line first: the questions were super easy. 3 SQL and 2 Python, done in under 20 minutes, then I just chatted with the interviewer.

He said the job is very relaxed, WLB is great, and you can work from anywhere for 30 days a year. The interviewer said flat out that this isn't the US, so people here are more chill.

I heard that later rounds ask a lot of AI-related questions.

3 SQL questions:

1. Given an employee table and an employee unique-ID mapping table, return every employee with their corresponding unique ID. Handle employees without a matching ID using the requested default value. (LEFT JOIN, COALESCE)
2. Calculate each customer's total revenue by month, then rank customers within each month to identify the top customers. (GROUP BY, SUM, RANK() OVER (PARTITION BY month ...))
3. Given employee check-in and check-out events, calculate each employee's working duration by pairing each check-out with its preceding check-in. (LAG(), timestamp subtraction; SUM if total duration is required)

2 Python questions:

1. Given employees' daily attendance records (Y = present, N = absent), find the longest consecutive streak of days when all employees were present. (Iteration, consecutive-streak tracking)
2. Given a list of integers, count how many numbers appear exactly once. For example, [4, 2, 1, 4, 4, 1, 3] returns 2 (the numbers 2 and 3 occur once). (Dictionary/Counter, frequency counting)