The 3 rounds interview process: Recruiter Phone Call (30 min) Hiring manager interview (45 min) Stakeholder & technical interviews (3 x 30 min)

• SQL Optimization Questions
• Python Pipeline Questions

The hiring manager and stakeholder interviews' questions were all behavioural type.

SQL Optimization Questions:

1. Rewrite the existing query
2. Write the query based on the scenario
3. Find the problem in the query

Python Pipeline Questions:

1. Analyze the current Python pipeline code and provide an alternative solution using the API
2. How to make the existing script scalable for larger datasets
3. How to prevent API rate limits for bigger volume
4. How to handle errors during load failures to avoid any duplicate data ingestion