Recruiter round:

It's like an online assessment via phone. The recruiter quickly asked 10-12 questions:

• 2 data modeling
• 4-5 data structures
• 4-5 SQL

All of them were one-word answer type.

Phone screen:

This was also an online assessment via Zoom. It included 5 Python and 5 SQL coding questions. The minimum bar was 3 correct in each category. It's all about speed and your clear explanation if they ask any follow-up questions. All the questions I received were from Glassdoor review questions. The complexity level increased as the interview progressed.

SQL - Bookstore Schema:

• Percents, joins, aggregate & window functions, CTEs

Python - Lists, Dictionaries, Sets, etc.:

• Easy level data structures