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
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
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Information on company tickers, basic reports pull, etc

Round 2 - One-on-one 

(1 Question)

  • Q1. Give an example where the management failed that affected the company's operations
  • Ans. 

    The management failed to anticipate a shift in market trends, leading to a decline in sales and profitability.

    • Lack of market research and analysis

    • Failure to adapt to changing consumer preferences

    • Ineffective decision-making processes

    • Lack of strategic planning and foresight

  • Answered by AI

Interview Questionnaire 

14 Questions

  • Q1. What is VPN? How do you solve Vpn issues? Explain with scenarios?
  • Ans. 

    VPN stands for Virtual Private Network. It is a secure connection between two or more devices over the internet.

    • VPN allows remote access to a private network over the internet

    • Common VPN issues include connection failures, slow speeds, and authentication problems

    • To solve VPN issues, troubleshoot the connection, check for software updates, and verify login credentials

    • For example, if a user is unable to connect to the VPN...

  • Answered by AI
  • Q2. How do you resolve vdi login and vdi slowness issues?
  • Ans. 

    VDI login and slowness issues can be resolved by identifying the root cause and implementing appropriate solutions.

    • Check network connectivity and bandwidth

    • Ensure VDI infrastructure is properly configured and optimized

    • Monitor resource usage and adjust allocation as needed

    • Update VDI software and drivers

    • Implement caching and compression technologies

    • Consider implementing load balancing

    • Provide end-user training and support

    • P

  • Answered by AI
  • Q3. What is the ping command to check latency in vdi?
  • Ans. 

    The ping command to check latency in VDI is 'ping -t '.

    • Open Command Prompt or Terminal

    • Type 'ping -t '

    • Press Enter

    • Observe the latency results

  • Answered by AI
  • Q4. Difference between incident and service request?
  • Ans. 

    An incident is an unplanned interruption while a service request is a planned request for assistance or information.

    • Incidents are unexpected and can cause disruption to normal operations.

    • Service requests are planned and can be initiated by the user or the service provider.

    • Incidents require immediate attention and resolution while service requests can be prioritized based on their urgency and impact.

    • Examples of incident...

  • Answered by AI
  • Q5. What is Organizational unit? What is the difference between shared mailbox and distribution list.
  • Ans. 

    Organizational unit is a container for objects in Active Directory. Shared mailbox is a mailbox that multiple users can access. Distribution list is a group of email addresses.

    • Organizational unit is used to organize objects in Active Directory

    • Shared mailbox allows multiple users to access a single mailbox

    • Distribution list is a group of email addresses used to send emails to multiple recipients

    • Shared mailbox is accessed...

  • Answered by AI
  • Q6. How do you modify and create DL?
  • Ans. 

    To modify and create DL, use the appropriate tools and follow the necessary steps.

    • Use the Exchange Management Console or Exchange Management Shell to modify and create DL

    • Ensure that you have the necessary permissions to modify and create DL

    • Follow the steps outlined in the documentation to modify and create DL

    • Test the DL to ensure that it is working as expected

  • Answered by AI
  • Q7. Do shared mailbox has owners?
  • Ans. 

    Yes, shared mailboxes have owners.

    • Shared mailboxes are created and owned by an administrator or a group of users with administrative privileges.

    • The owner of a shared mailbox can add or remove users who have access to the mailbox.

    • The owner can also manage permissions and settings for the mailbox.

    • In some cases, the owner of a shared mailbox may delegate access to another user, who becomes a co-owner of the mailbox.

  • Answered by AI
  • Q8. Domain controller ?
  • Q9. What is Dial in?
  • Ans. 

    Dial in refers to the process of connecting to a remote computer or network via a telephone line.

    • It involves using a modem to establish a connection over a phone line.

    • Dial in is commonly used for remote access to a company's network or for accessing the internet.

    • It can also refer to the process of joining a conference call by dialing a phone number.

    • Dial in can be less secure than other methods of remote access, as phon...

  • Answered by AI
  • Q10. If you want to onboard any empoloyee to the company so how will you follow the steps?
  • Q11. Anything you know about azure and end point manager?
  • Ans. 

    Azure is a cloud computing platform and Endpoint Manager is a device management solution by Microsoft.

    • Azure provides a wide range of cloud services including virtual machines, storage, and databases.

    • Endpoint Manager is a unified endpoint management solution that allows IT admins to manage and secure devices across multiple platforms.

    • Endpoint Manager includes features such as device configuration, application management...

  • Answered by AI
  • Q12. How many groups you have in AD?
  • Q13. Group policy?
  • Q14. What is patching? Steps involved?
  • Ans. 

    Patching is the process of updating software to fix vulnerabilities and bugs.

    • Identify the software that needs to be patched

    • Download the patch from the vendor's website

    • Test the patch in a non-production environment

    • Deploy the patch to production systems

    • Verify that the patch was successful

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep you confidence high with good communication skills.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

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 - 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 before Oct 2021. There were 4 interview rounds.

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 - 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
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Was good. Interviewer was very cordial & explained the Job role very well

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Yourself. No need to worry. Depends on the project

Interview Questionnaire 

3 Questions

  • Q1. What is data base analyst?
  • Ans. 

    A database analyst is responsible for designing, maintaining, and optimizing databases.

    • Designing and implementing databases

    • Ensuring data accuracy and security

    • Optimizing database performance

    • Creating reports and analyzing data

    • Collaborating with other teams to ensure data integration

    • Proficiency in SQL and database management systems

    • Knowledge of data warehousing and data mining

    • Experience with ETL processes

    • Ability to troubl

  • Answered by AI
  • Q2. How do you analyse a data?
  • Ans. 

    Data analysis involves identifying patterns, trends, and insights from data to make informed decisions.

    • Define the problem and identify the data needed

    • Clean and preprocess the data

    • Explore the data using statistical methods and visualizations

    • Develop and test hypotheses

    • Communicate findings and insights to stakeholders

  • Answered by AI
  • Q3. Knowledge of advance excel.

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.6k 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
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 806 Interviews
UnitedLex Interview Questions
3.1
 • 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
58 salaries
unlock blur

₹2 L/yr - ₹3.7 L/yr

Assistant Manager
38 salaries
unlock blur

₹3.6 L/yr - ₹8.4 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