Zynga Interview Questions

Zynga Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(14)
Product Sense & Metrics
(9)
Statistics
(8)
Data Structures & Algorithms
(7)
Analytics
(4)

Zynga Interview Questions

Practice for the Zynga interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

We’re given a table of bank transactions with three columns, user_id, a deposit or withdrawal value (determined if the value is positive or negative), and created_at time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format '%Y-%m-%d' for the date in the outout

Example:

Input:

bank_transactions table

Column Type
user_id INTEGER
created_at DATETIME
transaction_value FLOAT

Output:

Column Type
dt VARCHAR
rolling_three_day FLOAT
Machine Learning
Easy
Behavioral
Medium
Loading pricing options

View all Zynga questions

Challenge

Check your skills...
How prepared are you for working at Zynga?

Zynga Salaries by Position

$102K
$204K
Product Manager
Median: $155K
Mean (Average): $154K
Data points: 23
$100K
$150K
Data Scientist
Median: $126K
Mean (Average): $128K
Data points: 13
$45K
$190K
Software Engineer
Median: $120K
Mean (Average): $119K
Data points: 35
$80K
$132K
Data Analyst
Median: $120K
Mean (Average): $113K
Data points: 25
Marketing Analyst*
$90K
Marketing Analyst
Median: $90K
Mean (Average): $90K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $154,043 base salary while the Marketing Analyst role on average pays the least with a $90,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.