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
