Recruiter Call, Mini Case and then a power day with 2 case studies and 1 product case study. Process was overall smooth. Appropriate documents and resources were provided to prep for the interview.
HR call for 30 minutes. Questions from background, bq, to basic sql concepts. Everything is easy, HR will question back some of the resume detail. But HR says whether to move forward depends on the hiring manager.
Interview questions [1]
Question 1
1. Explain the function of having in sql
2. What's the substitution of subquery in sql
The interview was based on 3 phases. First was screening on call then a video interview with mini case then a power day with 3 phases including product interview, case based and economics based.
First, Screening call: the HR simply walked you thru the interview process and schedule the next round of interview - mini-case. I haven't done the mini case yet. Mini case, just search online for potential cases and prepare for it.