I applied through a recruiter. I interviewed at Select Medical (Harrisburg, PA)
Interview
Shared the environment and tools used for this role and Ask to talk about your experience and then followed with bunch of SQL questions and then ask whether I have any developing experience in writing new ETL packages and whether I have done stored procedures and whether I have done SQL profiling .
Interview questions [1]
Question 1
what is a cursor and what's the benefits and disadvantages; what's the difference between truncate statement and delete statement; what's clustered index and non-clustered index