The process took 4 weeks. I interviewed at TEKsystems (New Delhi)
Interview
The interview had 4 rounds. First 3 rounds are technical and finally HR discussion. Each technical discussion lasts for about 30 to 40 minutes.The HR is very sweet and scheduled interviews on time. The panel members are very helpful and encouraging. Overall a very positive experience with Teksystems.
Interview questions [1]
Question 1
1. write a SQL query to identify the employee with second largest salary
2. write a query to remove duplicate records in a table
3. explain SCD type 2 mapping