1 hour interview broken into two parts. First part was all behavioral with a senior team member; the interviewer was friendly. Second part was somewhat behavioral, but primarily involved a case study; more "intense" and less conversational than the first part.
I applied online. The process took 4 weeks. I interviewed at Optum in Mar 2022
Interview
1) Applied online
2) Got an email to do an online/pre-recorded interview
3) A recruiter reached out to me to set up a phone interview with some team members (virtually)
4) Got another email for final rounds of virtual interviews with hiring managers and other team members
Interview questions [1]
Question 1
Why you want this job, if you have any experience with SQL, any experience with pivot tables in Excel
First-round interview with a woman over Microsoft Teams. Asked behavioral questions with many parts. The questions were multi-part and long so it was hard to organize my thoughts to answer all questions parts.
Interview questions [1]
Question 1
Name a time that you didn't have enough time or resources to complete a job or task? What did you do and how did you do it?