Since its been long that I gave interviews, I dint knew what questions will be asked in interviews and which topic will be of focus. Though as per my previous interview experience I had gone through the ShivPrasad koirals book: Interview Questions for .NET but since I was an experienced candidate I had to look beyond this. Below is my interview experience with some of the companies.
Deloitte: Reference from Naukri.com
Requirement: 3+ years experience in .Net, WCF, Web Services, sql server 2008.
2 Technical Rounds
1.First I got call letter for interview from the HR, I sent them my updated CV. Then HR sent me an email with interview date and timings.
2.First round of interview was in Deloitte Office in Mindspace IT Raheja Park. There were 2 people who conducted my interview. One of them was at onsite location and other person took my interview face to face.
3.In this first round, I was asked to introduce myself and then about the technologies I worked on then .NET basic questions were asked. Below are the questions asked.
What is the difference between Web Services and WCF.
What are the different ways of hosting a WCF service.
Explain the different types of triggers in SQL Server.
Difference between BasicHttpBinding and WSHttpBinding.
What are the different types of assemblies available in .NET?
What is a strong name and how do you give a strong name to an assembly?
What is InsteadOf trigger.
Can we use Insert/Update statements in views in SQL Server
4.I was selected in the first round and after two days I got call for second round of interview at the same location.
5.In my second round of interview I had the Technical round with two highly technical people. Below are the questions asked.
Introduce yourself and which technologies you have worked on?
First they asked about .net and then moved to WCF questions.
What are abstract classes and Interface and what is the difference between the two.
What are the advantages of Interface over abstract classes. I was unable to answer this and they needed the answer in detail. So they gave me some clues in order to arrive at the proper answer from me.
What is a sealed class?
What kind of authentication mechanism you have used in your WCF project.
What is the difference between BasicHttpBinding and WSHttpBinding(repeated question).
How do you configure a WCF Service to use Network Authentication.
Though I was not selected in cognizant in the second round, It was a very good interview experience.
Cognizant Interview Experience:
My resume was shortlisted from Naukri website and I got an email for interview which was held on saturday. There was only one Technical Round and one HR round.
a. Different types of Triggers in SQL Server.
b. I had to write a SQL query where in the database table the records were previously updated from Male to Female and Female to Male by mistake. Now I have to write a query to update the records back from Female to Male and Male to Female.
c. What is the difference between BasicHttpBinding and WSHttpBinding(repeated question).
d. Have you ever used TCP binding in your WCF project. If yes how you have hosted the WCF project(Ans: Windows Application).
I was selected in the Technical Round. I had to wait for 30 minutes before they called me for HR round. In the HR round they asked for my introduction and then they asked about my previous experience. They wanted to make sure if the experience was genuine. They asked about my performance in my previous company. Then they asked Five years from now where do you want to see yourself. Finally the most awaited question: What is your salary expectation. I asked for 8 lakhs per annum. HR said as per the market and my current experience they will offer me 7 lakhs per annum. They told we will give you one week of time to decide and then they called me up after one week and asked me how much is my salary expectation: I said 7.25 and the HR said I will check and call you back. After that I never got call from the HR. The mistake I did was I forgot the HR name and so I was unable to follow up with the HR. So always make sure you get the HR name and contact details(if provided). If you feel that the company is good and if u aspire to be in that company then accept the offer they provide.
Syntel Interview Experience:
Syntel does not have development centre in hyderabad. So I got call from Syntel HeadOffice-Pune for .NET job requirement.
1.Technical Telephonic round.
2.Face to Face HR round in Hyderabad (CCD).
Technical Round questions:
> Difference between interface and abstract classes. What are the advantages of interfaces over abstract classes.
> What is Garbage Collection. How is Garbage Collector invoked in .NET.
> Can you force Garbage Collector to be invoked from c# code.
> how is var keyword used in .NET
> difference between var and dynamic keywords.
> Difference between Stored Procedures and Functions.
> What is the difference between BasicHttpBinding and WSHttpBinding(repeated question).
> What are the different types of contracts available in WCF(DataContract,MessageContract,ServiceContract,MessageContract,OperationContract).
> I was called at CCD in Hyderabad for face to face HR round. Initially I was concerned If interviews do happen in Cafe Coffee Day. But yes they did conduct interview in CCD.
> In this round I was asked to introduce myself and then they told me about the company.
> They told after one year of employment with syntel I would be sent to onsite for other job opportunities.
> After some time the interviewer asked me if I would like to have coffee in CCD. As I don't drink coffee. I dint take it.
> Then they told the current job opening is in Wells Fargo hyderabad office and already some 60 members are working at the client location and I would be working in the client location.
> I asked if they have any office in hyderabad and he said there are no syntel office in hyderabad. I was happy to get selected in syntel but as they dint had any branch in hyderabad I dint opt for syntel.
Superb Experience,thanks for sharing with us,