The process took 2 weeks; there were a total of 4 rounds. An HR phone screening round was followed by 3 45-minute interviews that were held back-to-back on the same day. The decision was also given on the same day.

1. HR phone screening - Basic theory questions in Python and SQL.

2. Technical Coding round in CoderPad. Two SQL questions based on CTE, joins, union, aggregate functions, and window functions (LeetCode medium level). Two Python questions (logic-based, loops, lists).

3. Analytical/Technical case study. Technical: Design a pipeline based on the scenario, adhering to best DE standards. Analytical: Scenario was explained, and stats were given (logical and statistical calculations to get answers).

4. Behavioral - Tell me about a time when questions (9 to 10 questions). Most important project, feedback, conflict, difficult client, security issues.