Upload Button Icon Add office photos

Filter interviews by

Rosmerta Technologies Senior MIS Analyst Interview Questions, Process, and Tips

Updated 13 Mar 2021

Rosmerta Technologies Senior MIS Analyst Interview Experiences

1 interview found

Interview Questionnaire 

6 Questions

  • Q1. What is MIS, what is purpose of an MIS
  • Ans. 

    MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.

    • MIS collects, processes, and stores data from various sources.

    • It generates reports and provides analysis to support decision-making.

    • MIS helps in planning, controlling, and organizing business operations.

    • Examples of MIS include ERP systems, CRM systems, and financial management systems.

  • Answered by AI
  • Q2. What are the different type of MIS
  • Ans. 

    MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.

    • Strategic MIS: Helps in long-term planning and decision-making.

    • Tactical MIS: Helps in short-term planning and decision-making.

    • Operational MIS: Helps in day-to-day operations and monitoring.

    • Decision Support System: Helps in complex decision-making by providing analytical tools a...

  • Answered by AI
  • Q3. How can you protect your sheet from anyone editing the data
  • Ans. 

    Protect sheet from editing by setting password and restricting access.

    • Set a password to protect the sheet

    • Restrict access to the sheet by only allowing authorized users to edit

    • Use Excel's Protect Sheet feature to prevent editing

    • Use VBA code to protect the sheet and prevent unauthorized access

  • Answered by AI
  • Q4. What is the constraint of a VLOOKUP function
  • Ans. 

    The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.

    • VLOOKUP can only search for values in the first column of a table

    • The lookup value must be in the leftmost column of the table

    • If you need to search for values in other columns, you need to use INDEX/MATCH instead

  • Answered by AI
  • Q5. How many report formats are available in MS Excel
  • Ans. 

    There are several report formats available in MS Excel.

    • Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.

    • Tables are used to organize data in rows and columns.

    • Charts are used to visually represent data in different formats such as bar, line, and pie charts.

    • Pivot tables are used to summarize and analyze large amounts of data.

    • Pivot charts are used to visually represent data from pi...

  • Answered by AI
  • Q6. How do prepare an MIS report in excel
  • Ans. 

    To prepare an MIS report in Excel, follow these steps:

    • Identify the data to be included in the report

    • Organize the data in a structured format

    • Use Excel functions and formulas to calculate metrics

    • Create charts and graphs to visualize the data

    • Format the report for readability and clarity

    • Include a summary or conclusion section

    • Save the report and share with relevant stakeholders

  • Answered by AI

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is your experience
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Not Selected
Round 1 - HR 

(2 Questions)

  • Q1. What was your Current CTC
  • Ans. 

    My current CTC is INR 12 lakhs per annum.

    • My current CTC is INR 12 lakhs per annum

    • I am currently earning INR 1,00,000 per month

    • My current salary package is INR 12,00,000 per year

  • Answered by AI
  • Q2. How many experience now in your present company
  • Ans. 

    I have 5 years of experience in my current company.

    • 5 years of experience in current company

    • Experience gained through various projects and roles

    • Demonstrated growth and expertise in the field

    • Received promotions and increased responsibilities

    • Contributed to the success of the company

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Sql and power bi
Round 2 - Technical 

(1 Question)

  • Q1. Sql and power bi

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for technical rounds.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Assignment 

Finacial modeling , Finacial Budegeting , Cash flow statement , Projection Report

Round 2 - One-on-one 

(1 Question)

  • Q1. All the Questions Relate to Assignment.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Excel formulas u knew
  • Ans. 

    I am familiar with a variety of Excel formulas including VLOOKUP, SUMIF, COUNTIF, INDEX/MATCH, and IF functions.

    • VLOOKUP: Used to search for a value in a table and return a corresponding value from another column.

    • SUMIF: Adds the cells specified by a given condition or criteria.

    • COUNTIF: Counts the number of cells within a range that meet a certain condition.

    • INDEX/MATCH: Used together to look up a value in a table based o...

  • Answered by AI
  • Q2. Power query questions

I applied via Referral and was interviewed before Oct 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. About Myself and the details
Round 3 - HR 

(1 Question)

  • Q1. Regarding CV details and employment gaps if any
Round 4 - One-on-one 

(2 Questions)

  • Q1. With Manager.... question was regarding a bit regarding the process and if immediate joining
  • Ans. Provided answer related with contract queries and was a immediate joiner
  • Answered Anonymously
  • Q2. Reason for job gap and if there was any questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your communication skills level minimum as you may get rejected in first round
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There was 1 interview round.

Round 1 - HR 

(3 Questions)

  • Q1. Tell me more about you
  • Q2. Last company experience
  • Q3. Last salary of you

Interview Preparation Tips

Interview preparation tips for other job seekers - Relax thay need people so you will be selectedm
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Financial model Ratio
  • Q2. Presentations skill and all financial statement

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and talk in English show your past achieve ments

I applied via Referral and was interviewed in May 2022. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. About ur self, ceo of our company
  • Q2. Tell me about Oops concept
  • Ans. 

    Oops concept is a programming paradigm that focuses on objects and their interactions.

    • Oops stands for Object-Oriented Programming System

    • It emphasizes on encapsulation, inheritance, and polymorphism

    • Encapsulation is the process of hiding the implementation details of an object from the outside world

    • Inheritance allows a class to inherit properties and methods from another class

    • Polymorphism allows objects of different clas...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for EPIQ Systems Data Analyst interview:
  • C language
  • Java
  • Related to company require
  • Python
Interview preparation tips for other job seekers - First thing... U don't fear about any interview.. Just talk to HR as a friend.. And answer the questions that u know... Don't put any disturbing noises in interview..

Rosmerta Technologies Interview FAQs

What are the top questions asked in Rosmerta Technologies Senior MIS Analyst interview?

Some of the top questions asked at the Rosmerta Technologies Senior MIS Analyst interview -

  1. how can you protect your sheet from anyone editing the d...read more
  2. what is the constraint of a VLOOKUP funct...read more
  3. how many report formats are available in MS Ex...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 788 Interviews
UnitedLex Interview Questions
3.0
 • 69 Interviews
View all

Rosmerta Technologies Senior MIS Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

1.0

Job security

3.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
MIS Executive
56 salaries
unlock blur

₹2 L/yr - ₹3.7 L/yr

Assistant Manager
39 salaries
unlock blur

₹3.6 L/yr - ₹9.1 L/yr

Project Manager
27 salaries
unlock blur

₹3 L/yr - ₹13.3 L/yr

Operations Manager
26 salaries
unlock blur

₹4.4 L/yr - ₹11 L/yr

Executive Accountant
20 salaries
unlock blur

₹3 L/yr - ₹4.8 L/yr

Explore more salaries
Compare Rosmerta Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview