I applied online. I interviewed at Avanade (Milan) in Jun 2017
Interview
Phone interview for some quick questions and company description. So a technical interview with questions about SQL up to how the CLI / .NET framework works (also talking about working experience and current functions). Lastly, HR interview, aimed at understanding the candidate's approach to problems, interaction with people, and interest in the position.
Interview questions [5]
Question 1
Given the table: Name (varchar) | Surname (varchar) | Gender (varchar)
write a query that returns name and surname chained together and: '1' when the gender equals to 'M' and '0' when it equals to 'F'