There were two interviewers consist with one team member and team manager. Started straight forward to interview process, one coding problem (algo, leeetcode style problem, medium), one sql (hard), one stats problem.

I applied online. The first round was a 30-minute conversation with a recruiter, who asked about my background and one or two high-level technical questions. The second round was a 30-minute technical interview with the hiring manager. The final round was in-person at their Toronto office, where I met with three team members. This included live coding exercises followed by technical questions.

1. The interviewee was required to complete a GenAI solution design assignment, which consumed their entire weekend. The task was vague in both content and objectives, suggesting that the interviewer either lacked a real understanding of GenAI or overestimated their own expertise. 2. Before the technical interview, the candidate suddenly received an email informing them that the interview had been changed from online to in-person, which was an unnecessary hassle for the applicant. 3. During the technical interview, the interviewer did not allow the candidate to fully present the entire solution, showing a lack of respect for the candidate’s work. 4. After the interview, inquiries about the interview results went unanswered, demonstrating unprofessionalism and discourtesy on the part of the company's HR. 5. Based on the interview, it became clear that their work on data modeling was relatively simple. It's puzzling where their arrogance comes from. 6. Overall, the HK Advanced Analytics team of this company comes across as arrogant, disrespectful to candidates, and overly self-important. There is even a suspicion of exploiting candidates for their ideas. This was an extremely disappointing interview experience.