Mu Sigma Interview Questions, Process, and Tips

Apptitude test happen in first go it was quite easy

GD happen between 10 group member we have speak for sometime

Q1. Question on OOPS
Add your answer
Q2. Quesion on SQL and python
Add your answer

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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q3. Hive external and internal tables
Add your answer
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
Answered by AI
Add your answer
Q5. Broadcast and accumulator
Add your answer
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
Answered by AI
Add your answer

Q1. It was a managerial round which was mostly around the project work and working experience in a team
Add your answer
Q2. What was your role and responsisbility in the project
Add your answer
Q3. Why is the approach of the project in this manner
Add your answer
Q4. Few scenario based question
Add your answer

Q1. Compensation and salary discussion
Add your answer

Contain logical, mathematical, reasoning and psychoanalytic sections

Current trend and affairs as topics. Groups of 5 with 10 mins as discussion time

Q1. Explain regression. What is database. What is machine learning.
Ans. 
Regression is a statistical method to analyze the relationship between variables. A database is a collection of organized data. Machine learning is a field of AI that enables systems to learn from data.
• Regression is a statistical technique used to understand the relationship between variables.

• A database is a structured collection of data that is stored and accessed electronically.

• Machine learning is a subset of artific...read more
Answered by AI
Add your answer
Q2. Where do you see yourself 2 years down the line?
Add your answer

GD conducted for 10 members

Aptitude test with technical questions

Q1. Interviewed on my project and technical skills
Add your answer
Q2. Difference between list and tuple
Ans. 
List is mutable and can be changed, while tuple is immutable and cannot be changed.
• List is defined using square brackets [], while tuple is defined using parentheses ().

• Elements in a list can be modified, added, or removed, while elements in a tuple cannot be changed once defined.

• Lists are typically used when the order of elements matters and when elements need to be modified, while tuples are used when immutability is...read more
Answered by AI
Add your answer
Q3. Tell me about your project
Add your answer
Q4. Where do see yourselfin 5 years
Add your answer

Q1. HR round with in 2 days
Add your answer

Computer based online aptitude test with basic math and reasoning

Discussion with a group of 8-10 candidate on a topic of your choice. My groups topic was abstract.

Q1. This involves very basic college level questions and more on personality and personal life.
Add your answer
Q2. Tell me about an incident when you had an argument with your professors and how did you convince them
Add your answer
Q3. What does your typical day look like?
Add your answer
Q4. How do you plan for your semester end exams?
Add your answer
Q5. What will you do if you do not get selected here?
Add your answer

30 Question overall test consist and all of them are multiple choice questions.

In GD one topic was given we need to be quit confidence to speak about the topic clearly.

Q1. 1.about the final project in college 2.about the key skills 3.hiw do you see your self in future and more
Add your answer

There were some basic questions related to time, distance and also asked to write about a topic

They'll give you a topic and ask you to speak

Q1. They ask you questions based on your resume, some SQL questions, guesstimates
Add your answer
Q2. Joins in SQL, order of execution
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are executed after the FROM clause and before the WHERE clause in SQL queries.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer

English 10, math 10, reasoning 10..60min

Five student can discuss one topic.
1.topic benifit
2.drawback
3.conclusion

Q1. 1.tell me about your self 2.tell me about company 3.if I will give you 10 crore then will you do 4.if are team leader, what kind of quality you need team mate
Add your answer