Zynga Data Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 13 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Zynga.
Zynga
Data Analyst
Senior Average Positive experience No offer 1 round
Interview process
Phone screen
Interview formats
Behavioral
I had a phone screening call where they asked me about myself, a project from my current company, my salary expectations, and my top three favorite games.
Confirmed questions4 questions
- Can you tell me about yourself?
- Could you describe a project you've worked on at your current company?
- What are your salary expectations?
Zynga
Data Analyst
Entry Average Negative experience No offer 1 round
Interview process
Take home Technical screen
Interview formats
Coding Technical
The interview was conducted on a Coderpad platform, involving 2 SQL questions and approximately 6-7 product analytics questions. However, the Coderpad platform had numerous bugs. For instance, an implicit ordering issue occurred because the platform expected a specific output order despite the absence of an ORDER BY clause. A CASE WHEN statement caused the query to fail, but its removal allowed the query to run, pointing to a platform bug with conditional logic. Additionally, a division operation that should have resulted in a float returned an integer, indicating a data type handling problem. It's surprising that in the age of LLMs, syntax matching is still used for SQL testing.
Confirmed questions4 questions
- A new feature launch saw GMV reach 5000 in 2 days; how would you project if GMV will hit 50K in 10 days?
- With a win rate of 35% before a feature release and 39% after (target 40%), what steps would you take to confirm if 39% is actually below 40% and to validate that this win rate is significant?
- What's an effective strategy for a game release, and what would you propose to the CXO?
Zynga
Data Analyst
Mid Difficult Neutral experience Decline offer 6 rounds
Interview process
Recruiter call Technical screen Technical screen Onsite Panel Background check Offer
Interview formats
Technical Coding Case Behavioral Presentation
The whole interview thing for a Data Analyst role is about 5-6 rounds, each taking at least an hour. It starts with a screening technical round led by the Analytics Lead, covering SQL, your preferred programming language (R/Python), and a business case study. Then there's a core technical round with a Senior Data Analyst/Data Scientist, focusing on SQL and R/Python. Next up is a Product round to check business and problem-solving skills. After that, a Director round for general discussion and business understanding. Then a Culture Fitment round with the Analytics Lead/Director. Finally, an optional HR round for stuff like compensation and behavioral questions.
Confirmed questions8 questions
- Can you walk me through your CV and explain one project in detail, including how you identified the business problem, your solution approach, any challenges, and the impact?
- Following up on your project, why did you choose that specific approach, and what if we had considered an alternative?
- Given the Employee and Department tables, can you show me the employees with the highest salary in each department?
Zynga Data Analyst Interview Questions
Quoted word for word from Zynga interview reports.
“Write a Python function to determine if a given string is a palindrome.”
Read reports →“Write a Python function to find prime numbers in a given list.”
Read reports →“Write a SQL query to find all rows in table A that are not in table B.”
Read reports →“How would you write a Python function to produce the cross-join and inner join of two lists of strings?”
Read reports →“What's the formula for Average DAU per Month?”
Read report →“Could you write a Python function to create a dataframe from a given list of fields and column names?”
Read report →“Create a straightforward SQL query involving joins and group by.”
Read report →“How would you calculate DAU?”
Read report →“With the Level Ups table (Player ID, Player level, DateTimestamp), for all active users, what's the daily percentage distribution of players across three level bins (0-100, 100-200, >200)?”
Read report →Formats, difficulty and experience
Across all 13 Zynga interview reports.