I applied through a staffing agency. I interviewed at Allscripts (Ben)
Interview
Written test on English and Database
1 technical round on BI, Dataware house, SQL, SSIS and reporting
2 manager rounds to discuss my strenths and weekness etc
2 HR rounds
Took 2 weeks to release offer