I applied online. I interviewed at AmTrust (Cleveland, OH) in Jul 2017
Interview
The first interview was a more relaxed interview with a few technical questions -- mostly basic Object-Oriented Programming questions, the second interview was entirely tech based with live coding.
Interview questions [1]
Question 1
They give multiple SQL queries that you must determine what the result would be.
Basic OOP/SQL questions, ask you to debug some code and explain what your process would be to fix it. Then they show give you some SQL tables (on paper or whiteboard) and ask you how you would join them etc.
Interview questions [1]
Question 1
-How do these two SQL statements affect the above tables? (Given sample tables)
-Using those sample tables, how does a “select/from/left join where x = y” and
“select/from/inner join where x = y” differ?