Initial phone screen included a couple of screening questions (e.g., "How would you design a table?") followed by a technical phone screen.

They cancelled the phone screen four hours before the call and rescheduled for the following day with a junior member of the team (less than two years of experience; I looked them up on LinkedIn).

I was asked two questions:

• SQL
• Data manipulation using Pandas

They used HackerRank but informed me I wouldn't be able to execute SQL queries, which was a bummer.

To my understanding, I answered both questions correctly, and the interviewer confirmed this.

SQL:

Given 3 tables (users, pins, engagement), find the click-through rate by pin type and date for new users.

Python/Pandas:

Given a DataFrame, find the category with the highest average time spent.