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.
