MRB Group Interview Questions and Answers

Q1. What is Primary and Secondary Research?
Ans. 
Primary research is original research conducted by the researcher, while secondary research is the analysis of existing research.
• Primary research involves collecting new data through methods such as surveys, interviews, and experiments.

• Secondary research involves analyzing existing data from sources such as books, journals, and online databases.

• Primary research is more time-consuming and expensive than secondary resear...read more
Answered by AI
Add your answer

Q1. Why are you looking for a change
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Looking for new challenges to enhance skills

• Seeking growth opportunities not available in current role

• Interested in exploring different work environment

• Want to broaden experience and knowledge
Answered by AI
Add your answer

Q1. Resume review and questions according to correlation with gemba Concepts
Add your answer
Q2. Technical knowledge & Certificate related verification on call by asking technical knowledge
Add your answer

Q1. Lean Technique & uses in real life
Ans. 
Lean techniques focus on eliminating waste and improving efficiency in processes.
• Lean techniques involve identifying and eliminating waste in processes to improve efficiency.

• Uses in real life include implementing just-in-time inventory systems, reducing lead times, and streamlining production processes.

• Lean techniques can also be applied in service industries to improve customer satisfaction and reduce costs.

• Examples i...read more
Answered by AI
Add your answer
Q2. Six Sigma & black lean uses with reason
Ans. 
Six Sigma and Lean Black Belt methodologies are used in consulting to improve processes and reduce waste.
• Six Sigma focuses on reducing defects and variation in processes

• Lean Black Belt focuses on eliminating waste and improving efficiency

• Combining both methodologies can lead to significant improvements in quality and productivity

• Examples of using Six Sigma and Lean Black Belt in consulting include streamlining supply c...read more
Answered by AI
Add your answer
Q3. Technical verification from core field
Add your answer

Q1. Project management & use of tools techniques
Ans. 
Project management involves planning, organizing, and executing projects using tools and techniques to achieve specific goals.
• Project management tools like Gantt charts, Kanban boards, and project management software help in planning and tracking progress.

• Techniques such as Agile, Waterfall, and Scrum methodologies are used to manage projects efficiently.

• Effective communication, risk management, and stakeholder engagem...read more
Answered by AI
Add your answer
Q2. Implementation based on experience & result came from it
Add your answer

Q1. Salary negotiation based on interview
Add your answer
Q2. Document & verification of availability
Add your answer

Q1. What is lean manufacturing ?
Ans. 
Lean manufacturing is a systematic approach to identifying and eliminating waste in the production process.
• Focuses on continuous improvement and waste reduction

• Involves all employees in the process

• Uses tools such as value stream mapping and 5S

• Examples include Toyota Production System and Kaizen
Answered by AI
Add your answer
Q2. What is OEE and productivity?
Ans. 
OEE stands for Overall Equipment Effectiveness and productivity refers to the efficiency of a process or system.
• OEE is a metric used to measure the performance of manufacturing equipment.

• It takes into account three factors: availability, performance, and quality.

• Productivity is a measure of how efficiently resources are used to produce goods or services.

• It can be calculated by dividing output by input.

• Improving OEE and...read more
Answered by AI
Add your answer

Q1. What is your last CTC?
Add your answer

Q1. Write SQL aggregation and join queries.
Ans. 
SQL aggregation and join queries for data analysis.
• Use GROUP BY clause for aggregation

• Use aggregate functions like SUM, AVG, COUNT, etc.

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Name types of joins and explain them.
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns all rows when there is a match in either table.
Answered by AI
Add your answer
Q3. How would you import data in power bi using api?
Ans. 
You can import data in Power BI using API by connecting to the API endpoint and specifying the required parameters.
• Use the 'Get Data' option in Power BI to connect to the API endpoint

• Specify the required authentication method (e.g. API key, OAuth)

• Select the data you want to import and transform it as needed

• Refresh the data periodically to keep it up to date
Answered by AI
Add your answer
Q4. Extract number from stings in sql
Ans. 
Extract numbers from strings in SQL
• Use the SQL function REGEXP_REPLACE to remove non-numeric characters

• Use the SQL function REGEXP_SUBSTR to extract numbers from strings

• Consider using regular expressions to handle different number formats
Answered by AI
Add your answer

Q1. What are window functions in sql and explain in detail
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions operate on a set of rows related to the current row

• They can be used to calculate running totals, ranks, and averages

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They are typically used with the OVER() clause to define the window frame
Answered by AI
Add your answer
Q2. Difference between joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in either table.

• Cross Join: Retur
Answered by AI
Add your answer
Q3. What is order of execution in sql
Ans. 
Order of execution in SQL refers to the sequence in which different clauses are processed in a SQL query.
• 1. FROM clause is processed first to retrieve data from the specified tables.

• 2. WHERE clause is processed next to filter the rows based on specified conditions.

• 3. GROUP BY clause is processed to group the rows based on specified columns.

• 4. HAVING clause is processed to filter the grouped rows based on specified cond...read more
Answered by AI
Add your answer
Q4. Ways to write time efficient sql queries
Ans. 
Use indexes, limit columns in SELECT, avoid using SELECT *, optimize joins
• Use indexes on columns frequently used in WHERE clauses

• Limit columns in SELECT to only those needed

• Avoid using SELECT * to retrieve all columns

• Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Answered by AI
Add your answer

Q1. Questions on Resume and why you want to work at the company
Add your answer

Q1. Another round on Resume and why you want to work with the company.
Add your answer

Q1. Asked questions regarding the research field and some technical question
Add your answer

Research on the automotive field

Q1. Tell me about some of your recent successes and failures.
Ans. 
I have had several recent successes and failures in my role as Managing Director & CEO.
• Successfully led a company-wide restructuring initiative, resulting in increased efficiency and cost savings.

• Implemented a new marketing strategy that led to a significant increase in sales and market share.

• Failed to secure a major partnership deal, but learned valuable lessons about negotiation and relationship building.

• Successfully...read more
Answered by AI
Add your answer