Three round of technical interview except HR round
1. Overall .NET and SQL Server
2. SQL Server
3. SQL Server (Telephonic from Kovair)
They are very dominating in the interview. They behave with you that you do not know anything. One of them (lady) asks you about some very tough words or terms of .NET and when you fail to answer those question, the facial expression of her is to be seen like that you are hopeless !!!
She asked me how many types of trigger. I answered four types of trigger. At that time she shocked. She only knew two types of trigger 1. After 2. Instead of. But she do not know actually there are four types of trigger and those two are sub-type of DML trigger. Someone of the interviewers supported me for that answer.
Interview questions [1]
Question 1
Maximum from SQL server.
1. Query optimization.
2. Indexing concept and why.
etc.
I applied through other source. The process took 1 day. I interviewed at Kovair Software
Interview
Very unprofessional way to have the interview process. Management should know about the proper hiring process. They should not waste time of any candidate if management does not want to take him/her.