Status: New grad
Position: unemployed
Location: Malaysia

Round 0
Casual Phone screen (30 min):
- Basic questions (to determine candidate job fit, role expectations)
- Questions on SQL, python work experience

Round 1
Interview with senior Data Analyst + technical screen (2.5 hours):
- Behavoural questions
- SQL and python coding test and case study question:
(python): https://leetcode.com/problems/first-missing-positive/
(SQL): basic query, aggregate functions (eg get average hour between first 2 orders in 2018)
(Case study): suggest possible kpi for either one (inventory management, inbound process, outbound process)
- coding all done on word doc, not expected to run/ debug

Round 2
Case Study question - revert solution by the following day.

• Given a dataset, suggest appropriate buffer time for instant cancellation request.
• Dataset consist of only ~4 columns, need to do analysis on datetime data.
• Requirement: report, ppt slides, excel output.

Round 3
Interview with Hiring Manager. (~ 40min)

• Casual. Focus more on candidate fit.