Cigna Health Insurance Business Analyst Interview Questions and Answers

Q1. Jira,product backlog
Add your answer

Q1. Tell me about yourself.
Ans. 
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Business Administration

• I have 5 years of experience in analyzing business processes and identifying areas for improvement

• I am proficient in using data analysis tools such as Excel and SQL

• I have a proven track record of delivering actionable insights to drive business growth
Answered by AI
Add your answer
Q2. What are your reasons for wanting to change your current situation?
Ans. 
I am seeking new challenges and opportunities for growth in my career.
• Seeking new challenges to continue learning and developing skills

• Looking for opportunities for career advancement

• Interested in working in a different industry or with a different team
Answered by AI
Add your answer
Q3. Are you comfortable working in an office environment?
Ans. 
Yes, I am comfortable working in an office environment.
• I have experience working in office environments in my previous roles.

• I am familiar with office protocols and procedures.

• I am comfortable using office software and technology.

• I enjoy collaborating with colleagues in an office setting.
Answered by AI
Add your answer

Q1. What was your previous job role, and what challenges did you face in that position?
Ans. 
I was previously a Business Analyst at a software company.
• Analyzed market trends and competitor data to make strategic recommendations

• Facilitated communication between stakeholders to ensure project alignment

• Developed and implemented data-driven solutions to improve business processes
Answered by AI
Add your answer
Q2. About yourself
Add your answer

SQL test coding assessment which I am yet to give

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.

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
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Add your answer

Mostly sql question asked, moderate level

Q1. Sql join and sub query
Add your answer
Q2. Window functions
Add your answer

SQL And Excel Test with Intermidiate to Entry level questions

SQL Test with questions on Window fx and logic

Case on various company and there problems

Q1. Why revenue of Flipkart dropped 20% in December, Compared to November.
Ans. 
The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.
• Seasonal factors such as holiday sales in November leading to higher revenue compared to December

• Promotional activities like Black Friday or Cyber Monday driving higher sales in November

• Changes in consumer behavior, such as delayed purchases or reduced spending a
Answered by AI
Add your answer
Q2. Why you want to join Swiggy
Ans. 
I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.
• Swiggy's cutting-edge technology and data-driven approach to food delivery excites me

• I am drawn to the fast-paced and dynamic work environment at Swiggy

• Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me
Answered by AI
Add your answer

Q1. SQL Queries were asked, most using direct functions
Add your answer