Tech Round (Python Coding for API Integration): Write Python code to fetch data from an API endpoint and process it. How would you handle pagination when fetching data from an API? System Design (Data Warehouse - DWH): Design a Data Warehouse (DWH) architecture for a large-scale dataset. What are the key components you would include in a DWH design and why? How would you ensure data quality and integrity in a DWH? SQL Question (5-part question): Write complex SQL queries for data manipulation or retrieval. Hiring Manager Interview (Experience-focused): Can you describe your experience with [specific technology or project]? How did you handle challenges in your previous roles? How do you prioritize tasks and manage time when working on complex projects? Director of Analytics (Behavioral Interview): Tell me about a time you worked under pressure and how you managed the situation. How do you handle conflict in a team? Can you describe a situation where you had to make a tough decision at work?