The HR reached out to me via email. Initially, I thought it was spam, so I double-checked the HR's details before contacting her back. Soon after, we had a brief 15-20 minute call where we got to know each other. She was particularly interested in knowing if I used SQL daily. Since I didn't, I informed her, and she advised me to prepare for it for the interview. Subsequently, she emailed me a collection of study materials for both SQL and Python.

I didn't make it to an onsite interview because I was slow. There were three 30-minute sessions for Python/SQL, and the interviewer was quite particular about time.

I managed to solve two Python and two SQL questions within the given time. Although, I struggled slightly with the second SQL question.

The overall experience was good, as the interviewer assisted me with my thought process throughout.

Tips:

• Communicate your thoughts to the interviewer.
• Once you have a rough algorithm, start executing it without overthinking. You'll identify errors in the compiler and can adjust syntax or logic accordingly. This saves significant time.
• Aim to complete more questions in less time, ensuring they produce correct output.
• Be confident in your actions. If you can't devise a solution independently, ask the interviewer quickly; they will certainly help.

Python

• Given an IP address as an input string, validate it and return True/False.
• Count the neighbors of each node in a graph. The input graph is a multi-dimensional list.

SQL

• Display the most common name in the table.
• A CASE statement-related question; pretty straightforward.