Upload Button Icon Add office photos
Premium Employer

i

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

Chubb Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Chubb Senior Data Analyst Interview Questions, Process, and Tips

Updated 19 Oct 2024

Chubb Senior Data Analyst Interview Experiences

1 interview found

Senior Data Analyst Interview Questions & Answers

user image manthena saivarma

posted on 19 Oct 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Coding Test 

5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min

Round 2 - Technical 

(4 Questions)

  • Q1. How do you seperate name from emails for example *****,***** etc.. We need to get name form those mails in sql
  • Ans. 

    Use SQL string functions like SUBSTRING and CHARINDEX to separate name from emails.

    • Use CHARINDEX to find the position of the '@' symbol in the email address.

    • Use SUBSTRING to extract the characters before the '@' symbol as the name.

    • Consider handling cases where there are multiple names or special characters in the email address.

  • Answered by AI
  • Q2. There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matc...
  • Ans. 

    Calculate the number of matches won and lost by each team based on the given data in the matches table.

    • Group the data by team and count the number of matches won and lost for each team.

    • Use the winner column to determine the outcome of each match.

    • Create a query to calculate the number of matches won and lost for each team.

    • Example: Team A won 2 matches and lost 1 match.

    • Example: Team B won 1 match and lost 2 matches.

  • Answered by AI
  • Q3. Table a has 1, 1,0,0,null and table b has 1,0,null,null. Resultant rows for all joins
  • Ans. 

    The resultant rows for all joins between table a and table b with given values.

    • Inner join: 1

    • Left join: 1, 1, 0, 0, null

    • Right join: 1, 0, null, null

    • Full outer join: 1, 1, 0, 0, null, null

  • Answered by AI
  • Q4. Explain primary and secondary indexing. And more questions on indexing
Round 3 - Technical 

(3 Questions)

  • Q1. Explain about your projects
  • Ans. 

    I have worked on various projects involving data analysis, visualization, and predictive modeling.

    • Developed predictive models to forecast sales trends and customer behavior

    • Created interactive dashboards using Tableau for data visualization

    • Performed data cleaning and preprocessing to ensure accuracy and consistency

    • Utilized machine learning algorithms such as regression and clustering for analysis

    • Collaborated with cross-...

  • Answered by AI
  • Q2. Follow up questions on projects
  • Q3. Write a query to seperate first name, midle name and last name from full name in sql
  • Ans. 

    Use SUBSTRING_INDEX function in SQL to separate first name, middle name, and last name from full name.

    • Use SUBSTRING_INDEX function to extract first name by specifying space as delimiter

    • Use SUBSTRING_INDEX function to extract last name by specifying space as delimiter and -1 as position

    • Use combination of SUBSTRING_INDEX and REPLACE functions to extract middle name if present

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
No response

I appeared for an interview in Aug 2024.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is your Age
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Self introduction
Round 2 - One-on-one 

(2 Questions)

  • Q1. Job role in current organization.
  • Q2. What do you know about DB DC
  • Ans. 

    DB DC stands for Defined Benefit Defined Contribution, which are types of retirement plans.

    • DB DC plans are types of retirement plans offered by employers.

    • Defined Benefit (DB) plans provide a specific benefit upon retirement based on a formula, such as years of service and salary.

    • Defined Contribution (DC) plans involve contributions from both the employee and employer, with the final benefit depending on the investment ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Login 20 minutes before the interview. In faced technical issues during virtual interviews. I was logged in to the link provided by the hr however the interviewer was unable to see me joining the call.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is unit testing?

I applied via Naukri.com and was interviewed before Jun 2020. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. About how to increase business in village
  • Q2. How to manage time and business with bank staff
  • Ans. 

    Effective communication and prioritization are key to managing time and business with bank staff.

    • Establish clear communication channels and expectations

    • Set priorities and deadlines for tasks

    • Regularly review progress and adjust plans as needed

    • Provide feedback and recognition for good work

    • Utilize technology and automation to streamline processes

    • Collaborate and build relationships with bank staff

    • Stay organized and focused

  • Answered by AI
  • Q3. How many people khow in market
  • Ans. 

    It is impossible to determine how many people know in the market without specifying which market.

    • The question is too broad and lacks context.

    • The number of people who know in a market depends on the size and type of market.

    • Market research can be conducted to estimate the number of people who know about a particular product or service.

    • Social media analytics can also provide insights into the number of people who are awar...

  • Answered by AI
  • Q4. Write 50 number and name from your contact he should taking insurance form our sode

Interview Preparation Tips

Interview preparation tips for other job seekers - Friendly I'm experiencing person so I how to deal with this question only truth and confiden answer give job

I applied via Campus Placement and was interviewed before Jun 2021. 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 - Group Discussion 

Easy

Round 3 - One-on-one 

(1 Question)

  • Q1. Why you want to join Exide Life
  • Ans. 

    I want to join Exide Life because of its strong reputation in the insurance industry and its commitment to customer satisfaction.

    • Exide Life has a strong reputation in the insurance industry, known for its reliable and trustworthy services.

    • The company has a customer-centric approach, prioritizing customer satisfaction and providing personalized solutions.

    • Exide Life offers a wide range of insurance products and investmen...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your resume well. Be calm. Its jusr a discussion

I applied via Referral and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What is your strength
  • Ans. Positive attitude towards work and life
  • Answered by rashmi pandey

Interview Preparation Tips

Interview preparation tips for other job seekers - Be positive and with high confidencd

I applied via LinkedIn

Interview Questionnaire 

2 Questions

  • Q1. What makes you perfect
  • Q2. Where you see yourself after 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and be confident.
Don't act smart stay cool and relax
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Your past experience
  • Q2. Previous achieve projects
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

All the questions are based on the MCQ , and the syllabus is covered python SQL Power BI

Round 2 - Coding Test 

Some questions from the Pandas Data Frame scenario based

Round 3 - One-on-one 

(1 Question)

  • Q1. Ask about work and coding

Interview Preparation Tips

Interview preparation tips for other job seekers - It's Good to start the carrier

Chubb Interview FAQs

How many rounds are there in Chubb Senior Data Analyst interview?
Chubb interview process usually has 3 rounds. The most common rounds in the Chubb interview process are Technical and Coding Test.
How to prepare for Chubb Senior Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Chubb. The most common topics and skills that interviewers at Chubb expect are Data Analysis, Data Warehousing, ERwin, ETL and Performance Tuning.
What are the top questions asked in Chubb Senior Data Analyst interview?

Some of the top questions asked at the Chubb Senior Data Analyst interview -

  1. There is a table matches which has team 1,team 2 and winner columns. Sample dat...read more
  2. How do you seperate name from emails for example *****,***** etc.. We need to g...read more
  3. Write a query to seperate first name, midle name and last name from full name i...read more

Tell us how to improve this page.

Chubb Senior Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Chubb Senior Data Analyst Salary
based on 6 salaries
₹6.5 L/yr - ₹19.1 L/yr
29% more than the average Senior Data Analyst Salary in India
View more details

Chubb Senior Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Senior Software Engineer
274 salaries
unlock blur

₹9.2 L/yr - ₹28 L/yr

Technical Lead
238 salaries
unlock blur

₹16 L/yr - ₹46 L/yr

Software Engineer
128 salaries
unlock blur

₹6 L/yr - ₹17 L/yr

Data Scientist
49 salaries
unlock blur

₹8.5 L/yr - ₹23 L/yr

Senior Analyst
42 salaries
unlock blur

₹6.8 L/yr - ₹24 L/yr

Explore more salaries
Compare Chubb with

HDFC Life

4.0
Compare

ICICI Prudential Life Insurance

4.1
Compare

Axis Max Life Insurance

4.1
Compare

Bajaj Allianz Life Insurance

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