Interview 1 (Telephone)- With Senior Manager Actuary
Explained the role and responsibilities
Can you go through your resume?
Then the interviewer asked to explain each experience.
Then asked, do have any questions for me
Interview 2 (Video) Panel Interview – With 2 Associate Data Analysts and 1 Senior Data Analyst
Tell me about yourself
How have you worked in a cross-functional team, how you conveyed the technical result/part to non-technical people? Give an example.
You have mentioned tableau in your resume, how was your experience with tableau?
Can you please explain why do you want to work in healthcare?
Can you explain why this position?
What is your biggest strength?
What is your biggest weakness?
Do you have any questions for us?
What are your hobbies?
Interview 3 (Video)– With Senior Directory Actuary
Explained about the company, how it works, business case
Tell me about yourself and how you relate your background, experience with this position?
Which geographical locations your previous workplaces were?
I see that you have knowledge of Machine Learning and Data Mining. I know you are not aware of the model that we are having/working on. I want to know how much time you might require to fully understand the model and become an expert on that, I mean how confidant are you on that?
Tell me are you confident that you can do it?
Then tell me why you are confident, give me an example?
Interview 4: With Senior Manager Actuary
Technical Interview(Video)
Task 1- Asked to write a SQL query on their internal data set.
Query involved aggregation - sum and writing cases in select.
Task 2- Showed a VBA script and asked to explain it.
Interview 5 (Video)- With Manager from another team.
Asked to tell about myself
Asked to rate my skills - SQL & Python
Asked whether I was having any questions about the role, process, or anything.
Interview 6 (Video)- WIth the Team Lead.
Asked to tell about myself
Technical Task 1- SQL query to get people from all the departments with top 3 salaries.
Technical Task 2 - How to get a large amount of data from excel to SQL server.
Explained about the role and requirements.