I applied through a staffing agency. I interviewed at Allscripts (London, England) in Aug 2018
Interview
After spending 2 hours with the panel ( one person), he said leave for the day. I guess he is refreshing his knowledge while discussing with me. We had a discussion on c#,MVC, oops, java script, SQL and SSRS, at least 30 minutes on each.
Interview questions [1]
Question 1
all skill set required for complete .net developer
I applied in-person. The process took 6 weeks. I interviewed at Allscripts
Interview
We need to use a select statment to retrieve data from SQL. We need to select the database name (Use 'database name'). Once the database is selected, we then need to specify the schema (HPSITE) and along with that we need to specify the name of the table from which we need to pull the data.
Interview questions [1]
Question 1
Explain, in your own words, how SQL server catalogs and retrieves data
Smooth hiring process. HR people were nice and polite. It includes 4 interview rounds first was basic English grammar test of 20 mins . You have to answer 40 questions in 20 mins very easy questions.
Second round was technical face to face interview.
Interviewer has good technical knowledge .
Asked all oops related questions , SQL , scenario based question and 1 puzzle.