MRI Software Interview Questions, Process, and Tips

Q1. Basic question on SQL
Add your answer
Q2. Aggregate function in SQL
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are often used with the GROUP BY clause to group the results based on certain criteria.

• Examples: SELECT SUM(sales) FROM orders; SELECT AVG(age) FROM employees GROUP BY department;

• Aggregate functions ignore NULL values unless specified.
Answered by AI
Add your answer

Tell me about yourself

Q1. What is static method
Ans. 
A static method is a method that belongs to the class itself, rather than to instances of the class.
• Static methods can be called without creating an instance of the class.

• They are commonly used for utility functions that do not require access to instance variables.

• Static methods are declared using the 'static' keyword in the method signature.

• Example: Math.max() is a static method in the Math class that returns the maxi
Answered by AI
Add your answer

Q1. It was 1 hr technical round for iOS Developer role. Questions related to project I am working, iOS Development questions like (process of publishing app, push notifications and its uses, Delegates how to u...read more
Add your answer

Q1. It was 30 min managerial round with one of the technical manager of MRI. Asked technical questions based on my projects. And then tricky questions like why you want to join, why we should hire you, where d...read more
Add your answer

There were many questions to be solved within an hour, but the expectation was to solve maximum you can.

1 DSA based and 2 SQL coding questions with 5/6 DSA based MCQs

Q1. Write a python code to find missing element ranging from 0 to 100. Write a SQL query to fetch data from multiple tables. Questions based on types on Joins in SQL, Stored Procedures, Views and importance o...read more
Ans. 
Python code to find missing element and SQL query for fetching data from multiple tables.
• Python code to find missing element: Use set difference to find missing elements in range 0 to 100.

• SQL query for fetching data from multiple tables: Use JOINs like INNER JOIN, LEFT JOIN, or CROSS JOIN to combine data from multiple tables.

• Types of Joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

• Stored Procedures: Precompi...read more
Answered by AI
Add your answer

Q1. Give a brief Introduction about yourself
Ans. Went over previous job profiles. A brief explanation on current role, industry and deliverables.
Answered Anonymously
Add your answer
Q2. Are you aware of agile methodologies?
Ans. 
Yes
• Yes, I am aware of agile methodologies.

• Agile methodologies are a set of principles and practices that promote iterative and incremental development.

• They prioritize customer collaboration, flexibility, and adaptability.

• Examples of agile methodologies include Scrum, Kanban, and Lean.

• Agile methodologies focus on delivering value to the customer in short iterations called sprints or iterations.
Answered by AI
View 1 more answer
Q3. How you would create user stories for a feature to capture employee attendance?
Ans. 
To create user stories for capturing employee attendance, consider the needs of the stakeholders and the desired functionality.
• Identify the stakeholders involved in the attendance tracking process (e.g., HR, managers, employees).

• Understand the requirements and goals of each stakeholder.

• Break down the feature into smaller user stories that address specific functionalities (e.g., clock-in/out, leave requests, reporting).

• ...read more
Answered by AI
View 1 more answer

Q1. Property tech industry knowledge
Add your answer
Q2. Agile working knowledge.
Add your answer
Q3. Experience with US product management teams.
Add your answer

AMCAT Test - basic aptitude test

Q1. Solid principle , oops
Add your answer
Q2. Why did you left your last company
Add your answer