AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
MassMutual Data Engineer Interview Questions and Answers
MassMutual Data Engineer Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.
(1 Question)
- Q1. Python data types, SQL medium to complex, Spark medium question
(1 Question)
- Q1. SQL complex, Spark theory
(1 Question)
- Q1. Basic HR questions
Interview Preparation Tips
- Python
- SQL
- Spark
(2 Questions)
- Q1. Current job roles
- Q2. Data engineering concepts
Interview Preparation Tips
(3 Questions)
- Q1. DIMENCTIONS VS FACTS
- Ans.
Dimensions and facts are two types of data in a data warehouse. Dimensions are descriptive attributes while facts are measurable data.
Dimensions are used to categorize and filter data while facts are used to perform calculations and analysis.
Dimensions are often used as the basis for reports and dashboards while facts are used to provide the underlying data.
Examples of dimensions include time, location, and product whi...
- Q2. INFORMATICA ROUTER VS UNION
- Ans.
Informatica Router and Union are used for data integration and transformation.
Informatica Router is used to route data based on certain conditions.
Informatica Union is used to combine data from multiple sources.
Router can be used to split data into multiple targets based on conditions.
Union can be used to merge data from multiple sources into a single target.
Router can be used to implement complex data flows.
Union can
- Q3. EMP DETAILS WHO HAS MAX SAL IN EACH DEPT
- Ans.
Find employee details with max salary in each department.
Group employees by department
Find max salary for each group
Join with employee details to get employee info
Interview Preparation Tips
THEY ALSO CHECK OUT CONFIDENCE
Skills evaluated in this interview
Interview questions from similar companies
Prerna Hirekar
2 questions based on Algorithm and logic
(1 Question)
- Q1. Questions on basic python, hadoop, sql etc
Selected
I applied via Approached by Company and was interviewed before Apr 2022. There were 4 interview rounds.
(2 Questions)
- Q1. Overall question on resume
- Q2. This is mainly from your resume & your profile for which the process is happening.
(1 Question)
- Q1. Second Round as well was on Credit Risk
(1 Question)
- Q1. Credit Risk + Technical stuff like SQL, IFRS9
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
Coding questions on sql python and spark
(2 Questions)
- Q1. Hacker rank code pair
- Ans.
Implement a function to pair elements of an array based on a given sum.
Iterate through the array and check if the current element plus any other element equals the given sum.
Use a hash set to store elements already visited to avoid duplicate pairs.
Return an array of arrays containing the pairs that sum up to the given value.
- Q2. Pyspark questions
I applied via Approached by Company and was interviewed in Feb 2022. There were 5 interview rounds.
(1 Question)
- Q1. We were asked to find mean, median and mode of a data and send it through an API link.
Was asked 10 MCQ and 1 coding question of easy difficulty.
(1 Question)
- Q1. This was technical interview 1 where I was asked about my knowledge on Data warehousing, Big data, Python. Was asked about my projects.
(1 Question)
- Q1. In Tech interview 2 I was asked a lot on SQL and Python and was grilled on abstract topic of data and its uses. Was grilled on my projects also.
(1 Question)
- Q1. I was asked to talk about anything other than academics. And was asked some basic HR questions.
Interview Preparation Tips
- SQL
- Python
- Data Warehousing
- Big Data
Swapnil Hingmire
Python features and implementation
(1 Question)
- Q1. Difference between while and for
- Ans.
While loop is used when the number of iterations is not known beforehand, while for loop is used when the number of iterations is known.
While loop is entry-controlled, meaning the condition is checked before the loop body is executed.
For loop is exit-controlled, meaning the condition is checked after the loop body is executed.
While loop is used when the number of iterations is not known beforehand, for loop is used whe
(1 Question)
- Q1. Why RDBMS over Non RDBMs
Shubham Thote
Selected
I applied via Campus Placement
Quantitative And Reasoning questions
There is one code which u will have written in any language u are want.
(2 Questions)
- Q1. Sql joins, window functions
- Q2. Writing some queries in front of interviewer
MassMutual Interview FAQs
Tell us how to improve this page.
MassMutual Interviews By Designations
- MassMutual Senior Associate Interview Questions
- MassMutual Data Engineer Interview Questions
- MassMutual Software Developer Interview Questions
- MassMutual Team Leader-Quality Assurance/Quality Control Interview Questions
- MassMutual Operations Associate Interview Questions
- MassMutual Senior Analyst Interview Questions
- MassMutual Data Analyst Interview Questions
- MassMutual Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
MassMutual Data Engineer Interview Process
based on 2 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
MassMutual Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Associate
144
salaries
|  ₹10 L/yr - ₹28.5 L/yr |
|
Associate
72
salaries
| ₹6.5 L/yr - ₹14.2 L/yr |
|
Senior Analyst
47
salaries
| ₹4 L/yr - ₹10.2 L/yr |
|
Data Engineer
14
salaries
| ₹6 L/yr - ₹16.5 L/yr |
|
Analyst
14
salaries
| ₹3 L/yr - ₹10.7 L/yr |
Bajaj Finserv
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
- Home >
- Interviews >
- MassMutual Interview Questions >
- MassMutual Data Engineer Interview Questions
