Upload Button Icon Add office photos

ICICI Prudential Life Insurance

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

ICICI Prudential Life Insurance MIS Executive Interview Questions and Answers

Updated 15 Aug 2024

ICICI Prudential Life Insurance MIS Executive Interview Experiences

2 interviews found

MIS Executive Interview Questions & Answers

user image Shivkumar Soni

posted on 15 May 2024

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

(1 Question)

  • Q1. Basically insurance related

MIS Executive Interview Questions & Answers

user image POOJA KUMARI

posted on 15 Aug 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about your self, work experience knowledge etc
  • Q2. Rate of yourself in excel
  • Ans. 

    I would rate myself 8 out of 10 in Excel proficiency.

    • Proficient in creating complex formulas and functions

    • Skilled in data analysis and visualization using pivot tables and charts

    • Experience in VLOOKUP, INDEX-MATCH, and conditional formatting

    • Familiar with macros and automation tasks

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Excel test (Vlookup, sumif etc)
  • Q2. How working on dashboard
  • Ans. 

    Working on dashboards involves creating visual representations of data to track key performance indicators.

    • Designing and developing dashboards to display relevant data

    • Using tools like Tableau, Power BI, or Excel to create interactive dashboards

    • Analyzing data trends and patterns to make informed business decisions

    • Customizing dashboards to meet specific business needs

    • Sharing dashboards with stakeholders for better decisi

  • Answered by AI

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
Q3. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
asked in HCLTech
Q4. What is the advantages of Data validation and why we use it?
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

I applied via Walk-in and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Introduce yourself?
  • Q2. What are the core principles of Information Security?
  • Ans. 

    The core principles of Information Security are confidentiality, integrity, and availability.

    • Confidentiality: ensuring that information is only accessible to authorized individuals

    • Integrity: maintaining the accuracy and completeness of information

    • Availability: ensuring that information is accessible to authorized individuals when needed

    • Examples: encryption, access controls, backups, disaster recovery plans

  • Answered by AI
  • Q3. What is Virus and Malware?
  • Ans. 

    Virus and malware are malicious software designed to harm computer systems and steal data.

    • Virus is a self-replicating program that attaches itself to clean files and spreads throughout the system.

    • Malware is a broader term that includes viruses, spyware, adware, and other malicious software.

    • Malware can be used to steal sensitive information, damage files, or take control of a computer.

    • Examples of malware include Trojan ...

  • Answered by AI
  • Q4. What will you do if your laptop gets infected by virus?
  • Ans. 

    I will immediately disconnect from the internet and run a virus scan to remove the virus.

    • Disconnect from the internet to prevent further spread of the virus

    • Run a virus scan using an updated antivirus software

    • If the virus cannot be removed, seek help from IT support

    • Regularly backup important files to prevent data loss

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Answer every question confidentally.Go through the job description very well.Prepare IT Security concepts thoroughly.Do not be nervous.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. General questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Its good experience and easy to crack the questions.

Interview Questionnaire 

1 Question

  • Q1. Why you want to come is insurance sector
  • Ans. 

    I am passionate about helping people protect their assets and loved ones through insurance.

    • I have a strong desire to help individuals and families plan for the unexpected.

    • I believe in the importance of financial security and peace of mind that insurance provides.

    • I am interested in the dynamic and evolving nature of the insurance industry.

    • I enjoy analyzing risks and finding solutions to mitigate them.

    • I have a background...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Aptitude & Reasoning

I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. Self introduction, what's your qualification, how many years of experience.
  • Ans. 

    I am a highly qualified professional with several years of experience in the field.

    • I have a Bachelor's degree in Business Administration.

    • I have 5 years of experience working in the finance industry.

    • I am skilled in financial analysis, budgeting, and forecasting.

    • I have successfully managed large-scale projects and teams.

    • I am proficient in various financial software and tools.

    • I have a proven track record of achieving targ

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I am currently working in Exide company, we have expectation for salary some past 2 years no increment no bonus etc.

I applied via Walk-in and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a highly motivated and dedicated individual with a strong background in finance and a passion for problem-solving.

    • I have a Bachelor's degree in Finance and have worked in the finance industry for 5 years.

    • I am skilled in financial analysis, budgeting, and forecasting.

    • I have successfully managed large-scale projects and implemented cost-saving strategies.

    • I am a team player and have excellent communication and interp...

  • Answered by AI
  • Q2. How much knowledge do you have in Insurance
  • Ans. 

    I have a strong knowledge in insurance.

    • I have a deep understanding of insurance policies and coverage.

    • I am familiar with different types of insurance such as life, health, auto, and property.

    • I have experience in analyzing insurance claims and determining coverage eligibility.

    • I am knowledgeable about insurance regulations and compliance.

    • I have worked with insurance companies and clients to provide accurate and timely in...

  • Answered by AI
  • Q3. They will ask you about your previous experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence is a key element to crack this Interview, there will be total 4-5 rounds of interview here

1) Focus about technical skills and Analytical skills
2) Gain knowledge about insurance and about insurance industry
3) They will check your verbal ability

I applied via Referral and was interviewed before Mar 2021. There were 2 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. How are heard about HDFC Life?

Interview Preparation Tips

Interview preparation tips for other job seekers - HDFC life is good for interns .

I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

6 Questions

  • Q1. Tell me about yourself
  • Q2. What is tangible asset
  • Ans. 

    A tangible asset is a physical asset that has a measurable value and can be seen or touched.

    • Examples include buildings, land, machinery, and inventory.

    • Tangible assets are typically depreciated over time.

    • They are recorded on a company's balance sheet.

    • Tangible assets can be bought, sold, or traded.

    • They are different from intangible assets, such as patents or trademarks.

  • Answered by AI
  • Q3. What is intangible asset
  • Ans. 

    An intangible asset is a non-physical asset that has no intrinsic value but has value due to its legal or intellectual property rights.

    • Intangible assets include patents, trademarks, copyrights, and goodwill.

    • They cannot be touched or seen but can be owned and traded.

    • Their value is based on their ability to generate revenue or provide a competitive advantage.

    • Intangible assets are recorded on a company's balance sheet and...

  • Answered by AI
  • Q4. What is insurance
  • Ans. 

    Insurance is a contract between an individual and an insurance company to protect against financial loss.

    • Insurance provides financial protection against unexpected events

    • Premiums are paid to the insurance company in exchange for coverage

    • Types of insurance include health, auto, home, and life insurance

    • Insurance policies have terms and conditions that must be followed to receive benefits

    • Insurance companies use actuarial

  • Answered by AI
  • Q5. What is account payable
  • Ans. 

    Accounts payable is the amount of money a company owes to its suppliers or vendors for goods and services received but not yet paid for.

    • Accounts payable is a liability on the balance sheet.

    • It represents the amount owed to suppliers or vendors for goods or services received.

    • Accounts payable is usually paid within a certain period of time, known as the payment terms.

    • Examples of accounts payable include bills for utilitie...

  • Answered by AI
  • Q6. What is account receivables
  • Ans. 

    Account receivables refer to the money owed to a company by its customers for goods or services provided on credit.

    • It is a type of asset on a company's balance sheet

    • It represents the amount of money owed to the company by its customers

    • It is typically collected within a certain period of time, usually 30-90 days

    • Examples include unpaid invoices, outstanding bills, and overdue payments

  • Answered by AI

I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Insurance topics
  • Q2. What is insurance
  • Ans. 

    Insurance is a contract between an individual and an insurance company to protect against financial loss.

    • Insurance provides financial protection against unexpected events

    • Premiums are paid to the insurance company in exchange for coverage

    • Types of insurance include health, auto, home, and life insurance

    • Insurance policies have terms and conditions that must be followed to receive benefits

    • Insurance helps individuals and bu

  • Answered by AI
  • Q3. Underwriter
  • Q4. Nominee
  • Q5. Premium
  • Q6. Types of insurance
  • Ans. 

    Types of insurance include life, health, auto, home, and travel.

    • Life insurance provides financial support to beneficiaries upon the policyholder's death.

    • Health insurance covers medical expenses and treatments.

    • Auto insurance covers damages and injuries resulting from car accidents.

    • Home insurance covers damages to the home and personal property.

    • Travel insurance covers unexpected events while traveling, such as trip cance

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about yourself. Think before you say something and try to prove that you are the best choice. Before you attend the interview please get to know about the domain and have good knowledge about the company

ICICI Prudential Life Insurance Interview FAQs

How many rounds are there in ICICI Prudential Life Insurance MIS Executive interview?
ICICI Prudential Life Insurance interview process usually has 1-2 rounds. The most common rounds in the ICICI Prudential Life Insurance interview process are One-on-one Round, HR and Technical.
What are the top questions asked in ICICI Prudential Life Insurance MIS Executive interview?

Some of the top questions asked at the ICICI Prudential Life Insurance MIS Executive interview -

  1. How working on dashbo...read more
  2. Excel test (Vlookup, sumif e...read more
  3. Basically insurance rela...read more

Tell us how to improve this page.

ICICI Prudential Life Insurance MIS Executive Interview Process

based on 3 interviews

Interview experience

5
  
Excellent
View more
ICICI Prudential Life Insurance MIS Executive Salary
based on 131 salaries
₹1.4 L/yr - ₹4.5 L/yr
At par with the average MIS Executive Salary in India
View more details

ICICI Prudential Life Insurance MIS Executive Reviews and Ratings

based on 22 reviews

4.0/5

Rating in categories

3.6

Skill development

3.7

Work-life balance

3.5

Salary

3.8

Job security

3.9

Company culture

2.8

Promotions

4.0

Work satisfaction

Explore 22 Reviews and Ratings
Financial Service Consultant
1.6k salaries
unlock blur

₹1.7 L/yr - ₹4.8 L/yr

Sales Manager
958 salaries
unlock blur

₹2.5 L/yr - ₹11 L/yr

Associate Financial Service Manager
939 salaries
unlock blur

₹1.9 L/yr - ₹4.6 L/yr

Senior Financial Service Manager
740 salaries
unlock blur

₹2 L/yr - ₹5.1 L/yr

Associate Key Relationship Manager
597 salaries
unlock blur

₹3.3 L/yr - ₹6.5 L/yr

Explore more salaries
Compare ICICI Prudential Life Insurance with

Axis Max Life Insurance

4.1
Compare

HDFC Life

3.9
Compare

Bajaj Allianz Life Insurance

3.9
Compare

ICICI Lombard General Insurance Company

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