I applied online. The process took 1 week. I interviewed at ResponseTek (Vancouver, BC) in Aug 2013
Interview
3 interviews. 1st - brief phone screening. 2nd - 2 hour extensive interview in the office. It starts with going through the resume, then goes the part with programming questions. The focus is on database programming skills and on analyzing text in text files (find this, change that), questions on optimization. DB questions are extensive and include ones about the use of inner/outer joins, transactions in SQL Server. The last part was behavioral questions. After 2nd interview goes the third and the last one, in the office or by phone interview with a software architect mostly about previous work experience (and what exactly you were doing), some behavioral questions and talk about career opportunities in the company.
Interview questions [1]
Question 1
What would be the result of sql query if it hangs before it reaches the end of the transaction