Applied through LinkedIn Easy Apply, then I received a HackerEarth coding assessment link, it was easy - medium, 3 Coding Questions including one SQL query, and other 2 were DSA. 2nd Round: Managerial -Difference b/w GET and POST in terms of data security. -SQL query to fetch the second most paid employee in each department, given employee and department tables. Mostly he was checking if I can use window functions like ROW_NUMBER or RANK. 3rd Round: Director -Intro with briefly explaining each projects worked. -How I write effective prompts for copilot, and what was the recent problem i solved using this AI Tools. -3 Coding Questions:   -- Multithreading and Race Condition Handling-> Increment a counter synchronously and asynchronously to 1000. Explain why asynchronous incremented counter < 1000. And how to avoid in C#. -- LINQ Queries - Given two lists of KeyValuePair. provide a list of elements which are there in List 1 not in list 2 and vice versa, and a list of elements having same id but different values. -- SQL Query Optimisation:  Given a Orders Table and a Customer Table. A SQL query was provided which was just fetching all the orders in decreasing order given the customer id. SELECT * FROM Orders O JOIN Customer C ON O.CustomerRef = C.CustomerID WHERE CustomerID = @CustomerId ORDER BY OrderDate DESC; For some customer query was causing timeout issues. Why and How would you optimise this. He was expecting explanation around Pagination.

I applied through LinkedIn Easy Apply, and after approximately two weeks, HR contacted me to initiate the interview process. Interview Process: HackerEarth Online Test: A proctored assessment consisting of MCQs and three coding questions. The MCQs were easy, while the coding questions ranged from easy to medium difficulty. It is advisable to attempt a sample HackerEarth test beforehand to become familiar with the environment, as IntelliSense support is limited. 1st Technical Round (Senior Software Engineer): Covered easy to medium DSA problems, .NET fundamentals, and DBMS concepts. I was also asked to write and optimize SQL queries of medium complexity. The discussion was well-structured, with clear and effective communication throughout. 2nd Technical Round (Director): Focused on designing and implementing a Social Media Aggregator API. After clarifying requirements, I began with pseudocode, but was asked to proceed with a .NET-specific implementation. Adequate time was provided for coding, followed by discussions on low-level design decisions and a high-level design review considering a high-throughput system. Note: HackerEarth was used for communication, coding, and HLD discussions, including its flowchart designer. 3rd Techno-Managerial Round (VP): Involved discussions about my current role and projects, challenges faced, and how they were addressed, along with general managerial questions. The interaction was open and cordial. Following these rounds, HR shared the offer letter. Overall, the interview process was well-structured and professionally managed. In my case, the entire process—from the online test to offer release—took about one month. Communication with HR was primarily via email, with no phone calls, which I appreciated.