Contacted by the recruiter after applying online.

After an initial phone screen, I had a technical phone interview. This included some SQL questions on joins and primary keys, followed by a programming exercise to check if a string is a palindrome and print non-duplicate elements in a given array.

Was called onsite, and the questions were a mix of data structures, ER diagrams, and some web concepts.

1. Given an array of duplicate elements, remove duplicates while maintaining the order of elements.

2. Design a system for the most shared stories on Facebook and design queries to get the top 5 most shared stories in the last 5 minutes.

3. Design ER diagrams for a parking lot and design queries.

4. Randomly pick n elements from a given array of m elements.