1. Call with Recruiter - very pushy, unprofessional and rude recruiter (see below)
2. SQL test, make sure you know window functions. Dataset is retail data. Analyst role.
3. Call with manager (some case study stuff)
4. Call with other manager
Good: Overall the interviewers were very nice. Helpful and wanted you to succeed.
Bad: The recruiter was horrible. Very poor communication throughout the whole process. Will not give you a written offer until you verbally accept it and barely explained anything in the offer. I tried to negotiate with competing offers and they recinded the offer over email in an hour saying "oh no can do, good luck with the other offer" recinding the offer. Absolutely horrendous hiring practices.