Phone: SQL qs are pretty basic on equi joins, outer joins, and self joins. Coding exercises are pretty basic like word search, etc. Time is a crunch (1hr). You have to keep explaining while coding so that the interviewer online understands your thought process. In Person: Some live coding exercise, tougher than phone qs, product sense, visualization.
Design a relational database for a ride-sharing app.
(After being shown a graph with some data) Can you think of reasons why the data would appear this way?
Easy/medium SQL and coding
Didn't pass the tech screening. 60 min of SQL and Python (30 min and 3 tasks each). SQL is intermediate with given schema, Python rather foundational data structures and algorithms.
Python 1.given an ip address as an input string, validate it and return True/False 2.count the neighbors of each node in a graph. input graph is a multi dimensional list SQL 1. Display the most common name in the table 2. a case statement related question. pretty straightforward
Object Oriented Design for a data set, Data Structures : Questions on Trees. No Questions on Product Sense, Data Modeling or SQL
Python- list of tuple with book category and points. Find max number of points student can score for up to 3 books. Book must belong to different category
Sql - how many books are in good condition and not returned, what percentage of book copies for above statement have renewed more than 2 times
Tell us about something that interests you and why it interests you?
Viewing 551 - 560 interview questions