pinterest logo
Pinterest· data analyst

Pinterest | Data Analyst Interview | Reject

Result
Rejected
Posted
8 Jul 2020
316 reads

Summary

I interviewed for a Data Analyst role at Pinterest, which involved a phone screen, a writing contest, and a coding interview focused on SQL and R. Ultimately, I was rejected for the position.

How it went

My interview process for the Data Analyst role at Pinterest began with a Phone Screening. During this round, I was asked to articulate my reasons for wanting to work at Pinterest and explain why I believed I would be a good fit for the company.

Following that, I participated in a Writing Contest. For this, I had been previously sent an article on Recommendation Systems. My task was to write a one-page article, intended for hypothetical non-technical stakeholders at Netflix, explaining what a recommendation system is and outlining the benefits of implementing such a system.

The final stage was a Coding Interview. This round featured two SQL questions and one R data manipulation question. The SQL questions were quite detailed, involving identifying non-spammer requests and calculating month-over-month download growth. Despite my efforts, I received a rejection after completing all the interview rounds.

Questions asked (5)

  1. 01

    Why Pinterest?

    Behavioral

    Explain your motivation for wanting to work at Pinterest.

  2. 02

    Why a Good Fit?

    Behavioral

    Describe why you believe you would be a good fit for Pinterest.

  3. 03

    Explain Recommendation System

    Other

    Read an article on Recommendation Systems (provided by the company) and write a one-page article explaining to non-technical stakeholders at Netflix (hypothetically) what a recommendation system is and why using such a system would be useful for them.

  4. 04

    Identify Non-Spammer Requests

    Data Structures & Algorithms

    Given two tables, a 'Spam Account Table' and a 'Spam Request Table', identify all requests made by non-spammers.

    Input Table Schema (Spam Request Table):
    Sending UserID | Receiving UserID | Date | IsAccept
    12 | 1 | 12.1.2019 | 1
    13 | 3 | 12.1.2019 | 0
    14 | 3 | 12.1.2019 | 1

    Input Table Schema (Spam Account Table):
    UserID | isSpam
    12 | 1
    03 | 1
    02 | 0

  5. 05

    Month Over Month Download Growth

    Data Structures & Algorithms

    Given a table with 'PhoneType', 'Month', and 'DownloadCount', add a new column calculating the 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

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Pinterest recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!