I applied online. The process took 4 weeks. I interviewed at MindGeek (Montreal, QC) in Nov 2020
Interview
The interview process was 3 steps
1. Resume selection
2. HR interview ( Normal HR questions with managerial questions and different scenario based question just to see if you are fit to work in the team and How you will handle certain situations)
3. Managerial interview which was conducted by the manager another data analyst and the team lead. (Technical round)
Interview questions [1]
Question 1
The questions were scenario based. they give you case studies to solve or will give you a scenario and you will have to write SQL query and describe your solution.
I was also asked to show my previous work or sample.