There is an initial interview. And if successful you move to an in person. The in person interview contains a logic part and sql part. You are graded on that and then either given an offer or not.