Sql test with mid level complexity like analytics functions and looking for evidence of query optimisations.
Game passion and experienced valued.
First hr interview then tech test then phone screen with data team.
I applied through an employee referral. I interviewed at Rockstar Games in Mar 2021
Interview
I was referred by a friend. I had a 30 minute phone screen with the internal technical recruiter, 1 hour interview with a tech lead, a 2 hour take home SQL test on Codility, and a final virtual onsite (3 rounds, 1 hour each), with 5 interviewers, including other data analysts, the team lead, and the hiring manager. Although the recruiter was very nice, the process was very frustrating, prolonged, and felt opaque/unprofessional. It also seemed like they were very disorganized. Sometimes the recruiter would not respond to my inquiries for days or he would tell me that I should be receiving the take home test and I would not receive it. It was frustrating that the recruiter only communicated by phone calls and then would not pick up if I tried to call him back. It felt like they were still figuring things out on their end and not respecting my time. The process took 2 months.
Interview questions [1]
Question 1
First interview was pretty behavioral: What would you research at Rockstar if data weren't an issue? What's a time when you had to do XYZ or deal with ABC? What potential issues do you see with telemetry data?
Final round was a mix of walking through your resume, projects, and case study type questions. You are about to launch an online AAA game, what KPIs are you following? One year after launch, what KPIs are you following? How would you increase monetization on your newly launched AAA game in a targeted way? What segment of the population do you target, how do you measure the success? There was a random question where the interviewer asked me to pull up a code editor - let's say there's a wheel in the casino that players can spin and the top prize happens 5% of the time; write a function that returns the likelihood of the player winning given some number of tries. How would you determine the impact of something like an Amazon Prime partnership on the user base? If we're launching some new content, what metrics would you want to collect that we're not already tracking? How would you conduct an AB test and how would you get buy-in from stakeholders and explain the results to them and why they're important?