First they conduct written test which covers questions regarding sql queries,cursor codes,SSIS,SSRS,SSAS. If candidate passed in written test he can have system test which consisting of generating SSIS packages,Reports with different scenarios,and Sql queries.Finally in HR round, they will describe company polocies