I applied online. The process took 1 week. I interviewed at Swiss Re (Bengaluru) in Sep 2022
Interview
First was the technical round. Questions were about SQL that was easy and Python code snippet. Other questions were also aksed from resume and past experience. Basically, they asked me if I can handle a project single handedly.
Interview questions [1]
Question 1
Questions were about SQL that was easy and Python code snippet. Other questions were also aksed from resume and past experience. Basically, they asked me if I can handle a project single handedly.
I sent my application via their online portal. After sending my curriculum, it took maximum a week to have an answer. They rejected with a standardized email, without any reasons mentioned on why.
Video Call was carried out with two employees of Swiss Re. It was about SQL programming skills to describe a database they've shared in an email beforehand. Three tables were shared and then asked about the relationship of these tables. How to get: unique (composite) keys, select the first record of a duplicated row.
Interview questions [1]
Question 1
- What is the unique key of certain tables?
- How to calculated aggregated metrics from certain tables?
- How to join two tables?