I applied online. The process took 3 days. I interviewed at Neoquant Solutions (Mumbai) in Jan 2025
Interview
The posted questions are of round two. Round 1 is technical but everything verbal. Round two involves query solving of which two questions are posted below. Overall it was a good experince,
Interview questions [2]
Question 1
You manage a retail database that includes Customers, Orders, and OrderDetails tables.
Question: Find the top 5 customers who have spent the most on orders in the last year.
Details
Columns:
Customers: CustomerID, CustomerName
Orders: OrderID, CustomerID, OrderDate
OrderDetails: OrderID, ProductID, Quantity, Price
you have an Attendance table tracking employee attendance, including EmployeeID, Date,
and Status (e.g., "Present", "Absent", "On Leave").
Question: List employees who have been absent for more than 5 days in the last month.
Details:
Attendance: EmployeeID, Date, Status