Hi,

I attended an interview on 09-Jan-2016 for a Senior Software Engineer position. I failed to clear the second round because I am not well-experienced in SSIS.

Interview process:

1. Technical round 1 (basic questions)
2. Technical round 2 (in-depth questions)
3. Client interview (on-call)
4. HR - salary negotiations

The first two rounds will be held on the same day, one followed by another. The third round will be held on any weekday with the client, followed by HR.

PS: Prepare SSIS, SQL in-depth, and basic .NET.

Can we apply a primary key on an existing column containing 1000 records?

How many primary keys can we have in a table?

Difference between a clustered vs. non-clustered index.

Give an example of a self-join.

Get the second-highest salary from the employee table.