I applied online. The process took 4 weeks. I interviewed at Iterable in Sep 2021
Interview
Very smooth. Whole interview process happened over 4 weeks. Hiring team was very prompt with scheduling and following up with regular updates after each round.
4 rounds in total. 2 phone interviews - 1st with the recruiter and 2nd with the hiring manager. Followed by a technical screen (mainly SQL) and a virtual onsite which was four 45 minute zoom calls.
Enjoyed the onsite as I got to converse with every member of the team about the challenges and responsibilities involved with the job. They also went into detail about my past experience and asked different technical questions related to the job as well.
Pretty smooth sailing overall, everyone on the team was amazing, all the interview rounds were very collaborative and conversational. They gave me plenty of time to talk to them about all my concerns and ask all my questions.
Interview questions [1]
Question 1
SQL - Learn your aggregations and how to use CTEs
Onsite - Gave me a use case and asked me to design an analytical warehouse, different considerations.
Different SQL questions (describe a time when you used a stored procedure, etc)