Technical Coding Interview after Phone Screening.

Using Coderpad:

• SQL (15 minutes, 5 questions)
• Python (15 minutes, 5 questions)
• Data Model (15 minutes, 5 questions)

There was enough time!

The interviewer was very friendly, and expectations were set clearly ahead of time.

If you prepare using Glassdoor questions, you can crack it for sure.

Data Model: LinkedIn data model - model for 1st-degree connection.

Python:

1. Deduplicate items in a list, retaining their order. (Cannot use dict or set since order will not be retained.) Follow-up question: How would you handle nested lists? (They are looking for recursion.)
2. Find the number of words in a sentence and the average length of a word.

SQL: On the product-sales-customers data model preloaded in coderpad.io, write the following queries:

1. Count of stores in the OR state with area_sqft > 25000.
2. Average number of female customers, grouped by state.
3. Customer first name, last name, and the count of unique products purchased by state. Follow-up question: Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id)).