Delhivery

The interview asked easy SQL questions , guessing question, reasoning. And later discussion based on my projects. The questions were like difference between rank and dense rank, inner join related questions.

He'll give you a business problem — most likely a margin decline scenario or a client P&L task. He may share a dataset in Excel. Think out loud, use the 5-step framework, and always end with a recommendation.

Initially, I got an call from the HR about the opening. In the call the HR, discussed the basic details of this role and explained me about the requirements and everything. The interview process had three rounds: 1) An online assessment, where I was supposed to solve an dsa question and submit. 2) Second round was totally focused on DSA questions 3) Third round focused mostly on my resume projects and present work experiences

2 rounds of interviews, first was technical with intermediate sql questions with cte, subqueries, window function and aggregation. Excel questions vlookup, xlookup. Second was situation based questions. Business case problems.

Solved a DSA problem shared via Google Docs by implementing the solution in an IDE. Started with a brute-force approach, explained its complexity, then optimized it step by step with improved time and space complexity.