AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Mu Sigma
Compare
Filter interviews by
Clear (1)
Mu Sigma Data Engineer Interview Questions, Process, and Tips
Top Mu Sigma Data Engineer Interview Questions and Answers
- Q1. sort by and order by difference
- Q2. explain hadoop ecosystem
- Q3. explain YARN architecture
Mu Sigma Data Engineer Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.
Apptitude test happen in first go it was quite easy
GD happen between 10 group member we have speak for sometime
(2 Questions)
- Q1. Question on OOPS
- Q2. Quesion on SQL and python
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.
(6 Questions)
- Q1. Explain hadoop ecosystem
- Ans.
Hadoop ecosystem is a collection of open-source software tools used for distributed storage and processing of big data.
Hadoop Distributed File System (HDFS) for storage
MapReduce for processing
Apache Hive for data warehousing
Apache Pig for data analysis
Apache Spark for real-time processing
Apache HBase for NoSQL database
Apache Kafka for real-time data streaming
- Q2. Explain YARN architecture
- Ans.
YARN architecture is a resource management layer in Hadoop ecosystem for job scheduling and cluster resource management.
YARN stands for Yet Another Resource Negotiator.
It consists of ResourceManager, NodeManager, ApplicationMaster, and Container.
ResourceManager manages resources and schedules applications.
NodeManager runs on each node and manages resources available on that node.
ApplicationMaster negotiates resources w...
- Q3. Hive external and internal tables
- Q4. Sort by and order by difference
- Ans.
Sort by is used to arrange data in a specific order, while order by is used to specify the sorting order in SQL queries.
Sort by is used in programming languages to arrange data based on a specific criteria
Order by is used in SQL queries to specify the sorting order of the result set
Sort by is more commonly used in programming languages like Python, while order by is used in SQL queries
- Q5. Broadcast and accumulator
- Q6. Optimization techniques
- Ans.
Optimization techniques are methods used to improve the efficiency and performance of data processing.
Use indexing to speed up data retrieval
Implement caching to reduce redundant computations
Utilize parallel processing for faster execution
Optimize algorithms for better performance
Use data compression techniques to reduce storage space
(4 Questions)
- Q1. It was a managerial round which was mostly around the project work and working experience in a team
- Q2. What was your role and responsisbility in the project
- Q3. Why is the approach of the project in this manner
- Q4. Few scenario based question
(1 Question)
- Q1. Compensation and salary discussion
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.
Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.
Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P
General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore
Selected
I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.
(2 Questions)
- Q1. How to decide upon Spark cluster sizing?
- Ans.
Spark cluster sizing depends on workload, data size, memory requirements, and processing speed.
Consider the size of the data being processed
Take into account the memory requirements of the Spark jobs
Factor in the processing speed needed for the workload
Scale the cluster based on the number of nodes and cores required
Monitor performance and adjust cluster size as needed
- Q2. Question on Spark internals
Implement a pipeline based on given conditions and data requirement
(1 Question)
- Q1. There were no questions as such. They want me join on very next day when the HR discussion was over and started itimidating me with aggressive approach even without discussing the salary part and the benef...
Interview Preparation Tips
Based on the HR behaviour, I can say there is no respect for an employee/ candidate.
The behaviour was like as if I am at the mercy of the employer and I don't have any other company in this world.
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Nov 2022. There were 5 interview rounds.
Get questions from all topics and medium level questions
They give one topic and provide one minute for thinking its overall 30 min discussion
(2 Questions)
- Q1. Total technical rounds 1)basic resume questions, python and sql questions. 2)same round 1 but a little bit extra dose 3) managerial round
- Q2. List, tuple, oops concept. joins from sql
(1 Question)
- Q1. Why latent view why analytics best achivemnts
- Ans.
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.
Analytics provides a systematic approach to analyzing data and extracting meaningful insights.
My best achievement is developing a predictive model for customer churn that helped
Interview Preparation Tips
Selected
I applied via Campus Placement
It was easy to approach!
Discussions about common topics like boon or bane to society
Asked about the scenarios
(1 Question)
- Q1. Technical round related to skills and resume
(1 Question)
- Q1. Discussions regarding work culture and compensations
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
(2 Questions)
- Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
- Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
- Ans.
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
There are four types of joins in SQL: inner join, left join, right join, and full outer join.
Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.
Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. All basic concepts of pthon sql and ml
Apptitude, tecncal, cognitiive
I applied via Campus Placement and was interviewed in Nov 2023. There were 4 interview rounds.
Blood Relations, Pipes and Cisterns, Time and work etc.
Question based on hashmap
Is Artificial Intelligence boon or ban.
(2 Questions)
- Q1. Python and SQL questions
- Q2. Python and Numpy, Pandas
Interview Preparation Tips
(2 Questions)
- Q1. Basic SQL questions
- Q2. Statistical questions
Mu Sigma Interview FAQs
Recently Viewed
INTERVIEWS
Sigmoid
No Interviews
SALARIES
Fractal Analytics
SALARIES
Fractal Analytics
SALARIES
Impetus Technologies
SALARIES
McKinsey & Company
REVIEWS
JPMorgan Chase & Co.
No Reviews
INTERVIEWS
Nielsen
No Interviews
INTERVIEWS
Crisil
No Interviews
REVIEWS
Celebal Technologies
No Reviews
REVIEWS
Celebal Technologies
No Reviews
Tell us how to improve this page.
Mu Sigma Interviews By Designations
- Mu Sigma Decision Scientist Interview Questions
- Mu Sigma Trainee Decision Scientist Interview Questions
- Mu Sigma Data Scientist Interview Questions
- Mu Sigma Business Analyst Interview Questions
- Mu Sigma Trainee Interview Questions
- Mu Sigma Apprentice Leader Interview Questions
- Mu Sigma Analyst Interview Questions
- Mu Sigma Data Analyst 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
Mu Sigma Data Engineer Interview Process
based on 2 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Mu Sigma Data Engineer Reviews and Ratings
based on 10 reviews
Rating in categories
|
Decision Scientist
1.7k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Trainee Decision Scientist
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Apprentice Leader
666
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Scientist
332
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
296
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
LatentView Analytics
Tiger Analytics
AbsolutData
- Home >
- Interviews >
- Mu Sigma Interview Questions >
- Mu Sigma Data Engineer Interview Questions
