I applied through a recruiter. The process took 2 weeks. I interviewed at RECRO-NET (Pune) in Jun 2012
Interview
2 rounds - Technical Round by Senior Manager ( telephonic interview)
Topics:SQL Server, ETL, Data warehousing, Data bases security, Encryption, Data base design, Indexing,Query Optimization and Performance, Source to target mapping. SSIS Tranformations,
Technical issues faced.
After 1 week i got call from HR that I have been shortlisted
HR Round( telephonic interview)- Notice period, Salary negotiation
Interview questions [1]
Question 1
1. What is clustered index?
2. How many clustered indexes can a table have?
3.What is difference between merge and union all transformations?
4.How did you implement slowly changing dimensions?
5.What were the technical challenges you faced during your project?
