First was HR interview which was standard. Then a team of 2 people, a senior consultant and a manager. Asked basic situational and background questions. Next was Account Executive, asked more challenging questions. Last was hiring manager, asked me to write TSQL queries on the spot among other technical questions.