1. Based on a table definition query the COUNT per category. Easy! 2. Based on a table definition query the max number of accepted friendship request by user under a specific timeframe. Easy! 3. Based on a business case about how to increase engagement in the mobile app propose a set of KPI’s to monitor and what data to use.
What do you think it takes to build a great Date Engineering team / Platform
write a python program to count words?
What do you do in your spare time with friends and family?
Build and scale twitter. Specifically, create required tables, identify referential integrity constraints, create a query to find latest tweets for a person from all the persons she is following latest first, how will you manage paging (infinite scroll); How will you scale it?
Design a table to track potential medication interactions for customers.
Are you open to working a hybrid schedule?
Questions about trust and safety, what kind of bad content did you see on our platform. How would you improve them.
Easy to Medium coding question to assess basic understanding of coding.
Both interviewers were concerned that with my experience that I wouldn't like being an individual contributor when I had been a manager in my previous company.
Viewing 391 - 400 interview questions