Phone Screen first, then call with Hiring Manager, followed by Technical Screen.
Was honestly baffled at the process. A recruiter reached out to me to schedule the first interview. After that initial call, I was bounced around to 3 other folks in recruiting for scheduling the technical screen.
The hiring manager had let me know that there was a technical screen, but didn't provide much detail on what material would be covered, and to what extent. I knew that I should know my basic SQL concepts so I prepared for that.
I sent 5 emails asking for further details from all three recruiters about what material would be covered in the screen, and to what depth. Was it just conceptual? Should I be prepared to explain the different types of joins, best practices for database design? Or be prepared to write complex queries? No response. The only response I did get was a reply forwarding my question to a 4th individual, who never replied despite another follow-up from me.
At this point, I was leaving to go out of town for 2 weeks so decided to just take the interview having reviewed the core concepts of SQL. The technical screen consisted of an interview, and then a hands-on-keyboard session. I wasn't prepared for some of the queries and was not allowed to reference or look up syntax, so did not do well, after not working closely with SQL for a number of years.
Wish the recruiters had provided some more detail, or just replied to me, so I could've cancelled and not wasted either parties time. The interviewer was a nice individual, so I feel bad for spending his time when it wasn't a good fit.