Upload Button Icon Add office photos

ICICI Prudential Life Insurance

Compare button icon Compare button icon Compare
4.1

based on 6k Reviews

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
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. V Lookup,index match, pivot,sumif,countif,etc
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 

(1 Question)

  • Q1. Excel test and personal interview

I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 3 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 - Aptitude Test 

Advance excel test like sumif countif vlookup pivote

Round 3 - HR 

(2 Questions)

  • Q1. About current company profile and previous company profile
  • Q2. About yourself and current and previous company background

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare with excel formulas like sumif counif pivot vlookup if formula
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Wat is your salary expectation
Round 2 - One-on-one 

(2 Questions)

  • Q1. Salary expectation
  • Q2. General questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. 

    I am a dedicated HR professional with 5 years of experience in recruitment, employee relations, and performance management.

    • Bachelor's degree in Human Resources Management

    • Experience in conducting interviews and onboarding new employees

    • Strong knowledge of labor laws and regulations

    • Implemented employee engagement initiatives resulting in increased retention rates

  • Answered by AI
  • Q2. Tell about your career
  • Ans. 

    I have over 10 years of experience in HR, starting as a recruiter and working my way up to HR executive.

    • Started as a recruiter and gained experience in talent acquisition

    • Progressed to HR generalist role, handling employee relations and performance management

    • Currently serving as HR executive, overseeing HR strategies and initiatives

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Tell me something about yourself
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(19 Questions)

  • Q1. Showing resume details
  • Q2. For about some queries
  • Q3. About my personality test.
  • Q4. Moving structure
  • Q5. Knowledge about company.
  • Q6. Aim about company.
  • Q7. Every rules whose followed by us.
  • Q8. Mathematics determination .
  • Q9. Language English knowledge.
  • Q10. Doing work in company
  • Q11. Daily work process
  • Ans. 

    The daily work process of an HR Executive involves various tasks and responsibilities.

    • Recruiting and hiring new employees

    • Managing employee onboarding and orientation

    • Handling employee relations and resolving conflicts

    • Administering employee benefits and compensation

    • Developing and implementing HR policies and procedures

    • Maintaining employee records and HR databases

    • Conducting performance evaluations and providing feedback

    • En...

  • Answered by AI
  • Q12. Attendance completion
  • Q13. In year Holidays
  • Q14. Status in the company.
  • Q15. Bonding with others company
  • Q16. Quality structure
  • Q17. Doing Manual things
  • Q18. Mission denotation
  • Q19. In company nature of our
Round 2 - Case Study 

Knowledge wants to know about work

Interview Preparation Tips

Topics to prepare for SBI Life Insurance Company HR Executive interview:
  • Design Patterns
  • Networking
  • Valuation
  • Strategic Thinking
  • Up and downs
  • Accounting
  • Yozna
  • Manual Testing
Interview preparation tips for other job seekers - Continue job in good way.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Why you choose this post
  • Ans. 

    I chose this post because of my passion for sales and my proven track record of exceeding targets.

    • Passion for sales

    • Proven track record of exceeding targets

    • Opportunity for growth and advancement

    • Desire to work in a dynamic and challenging environment

  • Answered by AI
  • Q2. Why you want to join here
  • Ans. 

    I am excited about the company's innovative products and strong market presence.

    • Impressed by company's reputation in the industry

    • Excited about the opportunity to work with innovative products

    • Interested in contributing to the company's growth and success

  • Answered by AI

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 Salary
based on 133 salaries
₹1.5 L/yr - ₹4.3 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 20 reviews

4.0/5

Rating in categories

3.6

Skill development

3.6

Work-Life balance

3.6

Salary & Benefits

3.8

Job Security

3.8

Company culture

2.7

Promotions/Appraisal

4.0

Work Satisfaction

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

₹1.5 L/yr - ₹5.4 L/yr

Sales Manager
982 salaries
unlock blur

₹2.4 L/yr - ₹10.6 L/yr

Associate Financial Service Manager
751 salaries
unlock blur

₹1.7 L/yr - ₹4.6 L/yr

Senior Financial Service Manager
733 salaries
unlock blur

₹2.4 L/yr - ₹5.1 L/yr

Business Trainee
600 salaries
unlock blur

₹3.5 L/yr - ₹6.2 L/yr

Explore more salaries
Compare ICICI Prudential Life Insurance with

Max Life Insurance

4.1
Compare

HDFC Life

4.0
Compare

SBI Life Insurance Company

3.8
Compare

Life Insurance Corporation of India

4.4
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview