Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Cigna Health Insurance Team. If you also belong to the team, you can get access from here

Cigna Health Insurance

Compare button icon Compare button icon Compare
2.9

based on 5 Reviews

Filter interviews by

Cigna Health Insurance Business Analyst Interview Questions and Answers

Updated 16 Jul 2021

Cigna Health Insurance Business Analyst Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Previous Company Experience and how you manage all the tasks alone from India
  • Q2. Past ML Based Solution Experience
  • Ans. 

    I have experience in developing an ML-based solution for predicting customer churn in a telecom company.

    • Developed a predictive model using decision trees and random forests

    • Used feature engineering techniques to extract relevant features from customer data

    • Achieved an accuracy of 85% in predicting customer churn

    • Collaborated with business stakeholders to identify key business metrics and interpret model results

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be practical because most of the people from the India Management team is talented , knows about most of company

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.

Round 2 - Technical 

(1 Question)

  • Q1. They give you some questions and you have to write sql queries for them
Round 3 - Technical 

(1 Question)

  • Q1. You are given case study and come sql questions based on that
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduction and explain any one of the projects plus what was the analytics you used
  • Ans. 

    Implemented a project to optimize marketing campaigns using predictive analytics

    • Developed a predictive model to identify the most effective marketing channels

    • Utilized data from past campaigns to train the model

    • Used techniques such as regression analysis and decision trees to analyze the data

    • Generated insights on customer behavior and preferences to improve campaign targeting

  • Answered by AI
  • Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very very well prepared with SQL and you should be aware of advanced sql, not only concepts but solving questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Case study questions based on Logistics & Porter business.
  • Q2. More Case study & porter business questions
Round 2 - Technical 

(2 Questions)

  • Q1. Some medium SQL Queries
  • Q2. Some medium python codes
Interview experience
3
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Excel question: Unique and Sumif
  • Q2. Quant questions
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Case Study 

Basic RCA question to diagnose falling numbers in a matrix.

Round 2 - Coding Test 

Basic left join, right join, sub query, ranking etc.

Interview Preparation Tips

Topics to prepare for Zepto Business Analyst interview:
  • RCA
  • Joins
  • Subquery
Interview preparation tips for other job seekers - SQL query using ranking, sub query etc.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. More about your role and insurance based questions
Round 2 - Technical 

(1 Question)

  • Q1. More about insurance based and brd, requirements gathering, sdlc
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. Expected salary vs what they can offer
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Sep 2023. There were 3 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 - Aptitude Test 

Medium difficultty on pandas SQL

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding interview python pandas medium difficulty
  • Ans. Solved it and had to discuss with manager
  • Answered by govind goel

Interview Preparation Tips

Topics to prepare for Paisabazaar.com Business Analyst interview:
  • Python
Interview preparation tips for other job seekers - Prepare pandas
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, Case study, and puzzles.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.

Tell us how to improve this page.

Claims Associate
4 salaries
unlock blur

₹3 L/yr - ₹4.1 L/yr

Assistant Manager
3 salaries
unlock blur

₹5.5 L/yr - ₹8.7 L/yr

Relationship Manager
3 salaries
unlock blur

₹3.2 L/yr - ₹3.6 L/yr

Application Development Analyst
3 salaries
unlock blur

₹13.2 L/yr - ₹14 L/yr

Insurance Executive
3 salaries
unlock blur

₹1.5 L/yr - ₹2 L/yr

Explore more salaries
Compare Cigna Health Insurance with

Niva Bupa Health Insurance Company

3.7
Compare

Star Health & Allied Insurance

3.7
Compare

Care Health Insurance

3.6
Compare

ICICI Lombard General Insurance Company

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