
Swiss Re Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 14 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Swiss Re.
Data Engineer
The entire interview process was really drawn out. In August, I had my first interview. Over a week later, I was told I passed and got an assignment. After I submitted it, it took another week to schedule the next round, which was a System Design interview about my project and approach. By that evening, I saw my application status was closed. The next day, I was asked to fix my project because they found issues, and the portal showed 'Interview Process' again. Two weeks later, I got a new interview link, which was then rescheduled for another week later. The whole thing took about 42 days, only to end with a silent rejection. Honestly, it was one of the worst interview experiences I've had, quite traumatic and a huge waste of time for anyone serious about the job.
- Technical questions focused on Pyspark, Cloud platforms, SQL, and Python.
Data Engineer
I had a video call with two people from Swiss Re. It was focused on my SQL skills. They sent me a database with three tables beforehand. They asked me about the relationships between these tables and how to get the unique keys, and how to select the first record of a duplicated row.
- Can you identify the unique key for specific tables?
- How would you calculate aggregated metrics using the provided tables?
- Describe the process of joining two tables.
Data Analytics Engineer
After the HR screening, I had my technical round. They asked me about the project on my resume, focusing on how I handled obstacles. Then, they inquired about my Palantir workshop application and asked some SQL questions, specifically about window and inner joins. The interview had two people; one was nice and explained things, but the other, who seemed to be in a senior role, was quite inquisitive and tried to put pressure on me.
- Can you discuss the project from your resume?
- Describe your approach to overcoming challenges encountered in that project.
- What can you tell me about your Palantir workshop application?
Swiss Re Data Engineer Interview Questions
Quoted word for word from Swiss Re interview reports.
“How can you select the first record from a duplicated row?”
Read reports →“What are the underlying logics for capturing credit fraud?”
Read reports →“What is the relationship between the provided tables?”
Read reports →“How would you calculate aggregated metrics using the provided tables?”
Read reports →“Could you explain SQL window functions?”
Read report →“Can you elaborate on SQL inner joins?”
Read report →“Do you know basic Python, like how to reverse a string?”
Read report →“What are your thoughts on Spark architecture and dimension tables?”
Read report →“Can you explain OOP concepts?”
Read report →Formats, difficulty and experience
Across all 14 Swiss Re interview reports.