Pinterest | Data Analyst Interview | Reject
Anonymous User
2696

#1 Phone Screening - Why do you want to work for Pinterest? Why would you be a good fit?

#2 Writing Contest - Read this (they had mailed me) article on Recommendation System and write an article explaining non-tech stakeholders at Netflix (hypothetically) - what it is and why using such a system will be useful for them. 1 page only.

#3 Coding Interview - 2 SQL Questions, 1 R Data Manipulation Question?
Q1. Given a spam account table and spam request table - identify all non-spammers requests?
Input Table Schema:
Sending UserID | Receiving UserID | Date | IsAccept
12 | 1 | 12.1.2019 | 1
13 | 3 | 12.1.2019 | 0
14 | 3 | 12.1.2019 | 1

UserID | isSpam
12 | 1
03 | 1
02 | 0

Q3. Given phone type, month, download count, add a new column calculating month over month growth rate in downloads.
Input :
PhoneType | Month | DownloadCount
Android | Jan | 1000
Android | Feb | 1001
Android | Mar | 1002
Output Desired:
PhoneType | Month | DownloadCount | MoM
Android | Jan | 1000 | 0
Android | Feb | 1001 | 1
Android | Mar | 1012 | 13

Comments (4)