It is good and not full on tension .it is just like a normal conversation and made us feel comfortable. some technical and some non-technical questions were asked which can be answered easily.
This call lasted about 30 minutes. The recruiter asked about my background, technical experience, and why I was interested in the role. They also gave me an overview of the company’s culture and the expectations for the position. It was a straightforward conversation, and the recruiter was friendly and informative
I applied online. The process took 3 weeks. I interviewed at CVS Health (Irving, TX)
Interview
3 Rounds
1. Technical Recruiter - Ask questions about my background, provided me with an overview of job duties and responsibilities.
2. Hiring Manager - Asked 5-6 Behavioural questions, went about an hour.
3. Coding - SQL(2 Questions) and some basic technical questions about Python data types, optimizization SQL queries, data warehousign/data modeling
Interview questions [1]
Question 1
SQL - Aggregrations/Window functions/ CTE's/Ranks
Python - Only technical questions (differ. b/w Lists and Tuples) etc