Assurant interview experience Real time questions & tips from candidates to crack your interview

Data Engineering Intern

Assurant
upvote
share-icon
1 rounds | 3 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 months
Topics: DBMS, OOPS, SQL, Data Structures, Algorithms
Tip
Tip

Tip 1 : Know your subjects well
Tip 2 : Mention only those skills in your resume that you're confident about
Tip 3 : Collect insight about the company and the role beforehand

Application process
Where: Campus
Eligibility: 7 CGPA
Resume Tip
Resume tip

Tip 1 : Have projects on your resume
Tip 2 : Have a diverse skill set

Interview rounds

01
Round
Medium
Video Call
Duration45 minutes
Interview date4 Apr 2021
Coding problem3

Only four candidates were shortlisted through resume picking for the interview. Candidates were interviewed by a single panelist, the hiring manager in the evening. The interviewer was based out of UK and was very welcoming. The interview began with brief introductions, then the interviewer questioned me on how confident am I about by DBMS skills. He asked me one or two very basic questions related to it. Then he moved on to brief discussion about the projects mentioned in my resume. The most important and the deciding section of the interview honestly was the set of two data-oriented analytical questions. I could answer them because I had an insight about what kind of data the company deals with and it's field of business.
In the end I was very satisfied with how my interview went and felt confident about it.

1. DBMS

Easy
10m average time
90% success
0/40
Asked in companies
UnacademyIBMOptum
  • What do you understand by acid properties?
  • Write an SQL Query to fetch records of all employees who have not completed the task assigned and belong to engineering team?
Problem approach

Practice SQL Queries

Go through DBMS concepts

Try solving now

2. Basic Managerial Questions

1. Can you think of any novel ways in which Assurant can use its existing data to increase it's field of business?
2. What data sets would you suggest be added to the existing Assurant data that could be of advantage to the company?

Problem approach

Think twice before you reply.

Try to support your statements with some proof

3. Reverse Words In A String

I was asked just tell the approach and not to code the solution

Problem approach

Use two pointers approach and reverse the string once you encounter a space.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
4657 views
0 comments
0 upvotes
company logo
SDE - Intern
2 rounds | 3 problems
Interviewed by Amazon
960 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
6450 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
3451 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Data Engineering Intern
3 rounds | 4 problems
Interviewed by Dunzo
841 views
0 comments
0 upvotes