explain the difference between window functions such as dense rank, rank and number rank,
Sr Data Analyst Interview Questions
2,956 sr data analyst interview questions shared by candidates
How do you used AWS services in data analysis lifecycle?
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?
How would you interact with the dev team, who do you talk to and why? Have you worked with big data sets before? Where do you see yourself in 5 years time?
How do you complete a team task?
Take home assignment is really the only thing they seem to care about, which is just a horrible way to screen candidates. You're just only allowing folks who have the ability to spend many hours on the project, who dont have family, illness, or learning disabilities that would prevent them from being able to complete the assignment in "three hours". Unfortunate decision on their part to structure the interview process this way.
Questions related to data migration
Do you have experience working in the finance industry?
How would your colleagues describe you?
Usual HR Screen, Intro, role fit analysis. The hiring manager round was intro and 2 case studies. One based on their internal tool, and another general analyst to report metrics.
Viewing 2181 - 2190 interview questions