I received the call via employee referral. HR contacted me by phone for an initial screening, which included general interview questions about my background and interests. A few weeks later, SQL coding and Python coding rounds were conducted. Each coding round lasted 45 minutes, back to back, with a 15-minute break in between. The coding was conducted on CoderPad. I was able to complete all 5 SQL coding questions, but could only complete 1 Python coding question. I found the Python questions difficult.

SQL Coding:

5 questions were asked. 4 tables were given, and questions mostly focused on joins, aggregate functions, and subqueries.

Python Coding:

There were approximately 5 questions, but I only managed to complete the first two.

• Count the number of words in a sentence.
• Count the frequency of words from a list and store the results in a hash map.