I applied through an employee referral. I interviewed at CVS Health (Boston, MA) in Jan 2022
Interview
I applied for a Summer'22 internship as a data engineer. The interview process was pretty smooth and quick. Process included one HR call, one conceptual technical round, two live coding rounds (python and sql)
Interview questions [1]
Question 1
1. Anagrams-Leetcode 2. List Question-Leetcode 3. One SQL Question
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.