I applied online. The process took 2 months. I interviewed at CVS Health (Dallas, TX) in Jan 2023
Interview
1. HireVue Assessment - consisted of video questions about myself and the work that i have done. Some questions on SQL were also there. 2. Technical Round - Lasted for 30 minutes, it was more on my previous work, my projects and my coursework in my university. 3. Managerial Round - STAR questions were asked.
Interview questions [1]
Question 1
1. What is ETL ? 2. What is one thing you wish you had done differently at work? Etc.
One interview that combined both technical and behavioral questions. Some of the technical questions were case like and I had to explain my thought process behind it. The behavioral questions were classic behavioral questions.
Interview questions [1]
Question 1
Give me an example of a team where you had to work in a team.
First got a hirevue that asked questions related to data engineering, python, and sql. Then had a technical coding round on SQL and Python Pandas. After it was a final interview with a Lead Director Data Engineer chatting about data engineering practices, scenario questions, and some resume questions.
Interview questions [1]
Question 1
Outline a plan for migrating data from on-premises database to cloud.
I took the hivevue test, and didn't move forward to further interview. the duration is around 1-2 months. The questions are not very hard and tested general SQL and data structure questions.