There was a preliminary interview, interview, technical interview (it was more like a conversation). They asked the standard questions (tell me about yourself, salary expectations, reason for leaving current company).

1st round technical round .. ref out, mvc,webapi valuetype vs ref type. DI Write a stored procedure in SQL Server that accepts a department name as input and returns the list of employees (EmployeeId, Name, Salary) who belong to that department and have a salary greater than the department’s average salary. Write a query to fetch the top 5 customers by total purchase amount from Orders table. Table: Order Columns: CustId, OrderId, Amount