I applied through a recruiter. The process took 4 weeks. I interviewed at Rivian in Jul 2024
Interview
I had total of 8 rounds , first the screening round with the recruiter where he described job role., salary and other benefits. Next was hiring manager round where I was asked basic questions like why data analyst. Next was technical screening, was given SQL questions to solve in hackerrank, live coding. Next was panel presentation with 4 people in team. next 4 interviews were with people from the presentation. First with director who asked lot of behavioral questions. Next three mostly on my technical background.
Entire process took a month, The recruiter was very supportive and helped with relevant information at all stages.
Interview questions [1]
Question 1
SQL window functions, joins, groups
Behavioral questions like where do you see yourself in 5 years, what is success to you
Total of 6 interviews. Hiring manager, technical, stakeholder, and a panel interview (3 interviews over the course of multiple days). The final panel interview required a presentation based on a data set.
After completing the full interview process I did not hear back from the recruiter with any update or feedback - I followed up twice. Hiring manager was really nice, but mostly negative experience overall.
Interview questions [1]
Question 1
Standard STAR questions.
What are your salary expectations?
Are you applying for other jobs?