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 Data Analyst Interview Questions and Answers

Updated 27 Feb 2024

Chubb Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Feb 2024

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

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Tell me about your self?
  • Q2. What is SQL and diffrent joins in SQL?
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.

    • SQL is a standard programming language for managing and manipulating relational databases.

    • Different types of joins in SQL include inner join, outer join, left join, and right join.

    • Inner join returns rows when there is at least one match in both tables.

    • Ou...

  • Answered by AI
  • Q3. How to separate portion before @ and after @ from mail using python?
  • Ans. 

    Use Python to separate portion before and after @ in an email address.

    • Use the split() method to separate the email address into two parts based on the @ symbol.

    • Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

    • Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];

  • Answered by AI
  • Q4. What is the rank, Dense Rank and Row Number?
  • Ans. 

    Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.

    • Rank function assigns a unique rank to each row based on the specified column values.

    • Dense Rank function assigns a unique rank to each row without any gaps.

    • Row Number function assigns a sequential integer to each row in the result set.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - practice general questions like joins, commands of DML, DFL, DCL, TCL.
For python practice coding like regex, splitting of string etc.

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Whats is supervised learning
  • Ans. 

    Supervised learning is a type of machine learning where the model is trained on labeled data to make predictions or decisions.

    • Uses labeled data for training

    • Predicts outcomes based on input features

    • Examples include regression and classification algorithms

  • Answered by AI
  • Q2. What is unsupervised learning
  • Ans. 

    Unsupervised learning is a type of machine learning where the model is trained on unlabeled data without any predefined output labels.

    • No predefined output labels are provided for the training data

    • The model must find patterns and relationships in the data on its own

    • Common techniques include clustering and dimensionality reduction

    • Examples: K-means clustering, Principal Component Analysis (PCA)

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - do hard work

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Gallagher user image sandesh j sakure

posted on 30 Nov 2023

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

20 min for 25 question that are related to u r profile

Round 2 - HR 

(3 Questions)

  • Q1. They dont have knowledge about the profile asking some stupied questions
  • Q2. You are working before on MNC clients
  • Ans. 

    Yes, I have worked with MNC clients before.

    • I have experience working with multinational clients in my previous roles.

    • I have successfully managed projects for MNC clients, delivering high-quality data analysis.

    • I am familiar with the challenges and requirements of working with MNC clients, such as cultural differences and complex data sets.

    • I have collaborated with cross-functional teams to meet the specific needs of MNC ...

  • Answered by AI
  • Q3. They dont know this compeny is MNC asking again and again u r working in MNC
Round 3 - Assignment 

Assignment on Sales data to find revenue ,split column

Round 4 - HR 

(4 Questions)

  • Q1. How much project you done in last year ?
  • Ans. 

    I have completed multiple projects in the last year.

    • I have completed 5 projects in the last year.

    • One of the projects involved analyzing customer data to identify trends and patterns.

    • Another project focused on optimizing inventory management using data analysis techniques.

    • I also worked on a project that involved creating a predictive model for sales forecasting.

    • In addition, I collaborated on a project to analyze social ...

  • Answered by AI
  • Q2. After clering all rounds they arrange the salary discussion round but not done salary discussion round and not getting any response on email & call
  • Q3. HR not given proper feedback about selection not getting any response on call & email
  • Q4. It is so difficult to decide U r selected or not & u can wait or join another

Interview Preparation Tips

Topics to prepare for Gallagher Data Analyst interview:
  • Advanced Excel
  • SQL
  • Power Bi
Interview preparation tips for other job seekers - Ask to HR ( Javeed ) clearly u r selected or not when they are calling you because they are not receiving any call and not rplying on any email
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Assessment 

(2 Questions)

  • Q1. Type of sql Joints
  • Ans. 

    SQL Joins are used to combine rows from two or more tables based on a related column between them.

    • Types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN returns rows when there is at least one match in both tables.

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN returns all rows from the right table and the matched rows from the left tab...

  • Answered by AI
  • Q2. Write DAX for create data modeling on inactive relationship?
  • Ans. 

    Use DAX to create data modeling on inactive relationship in Power BI.

    • Use USERELATIONSHIP function to create an inactive relationship between two tables.

    • Specify the relationship between the tables and the columns to be used in the relationship.

    • Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.

  • Answered by AI
Round 2 - Coding Test 

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all

Skills evaluated in this interview

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
No response

I appeared for an interview in Aug 2024.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is your Age
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

First round will be aptitude test

Round 2 - HR 

(2 Questions)

  • Q1. Why should I hire you
  • Ans. 

    I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.

    • I have a degree in data analytics and relevant work experience

    • I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

    • I have successfully completed projects where I identified trends and patterns in data to drive business decisions

  • Answered by AI
  • Q2. Tell me about your self
Round 3 - Behavioral 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Position of the candidate
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Basic Excel function
  • Q2. Scenario based questions
Round 2 - Aptitude Test 

More questions about my experience & reason to join.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview toughness level was average.
Friendly behavior
Prepare more on scenario based questions
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

I appeared for an interview in Dec 2016.

Interview Questionnaire 

7 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Statistics and experience in analyzing large datasets

    • I am proficient in using statistical software such as R and Python

    • I have a proven track record of identifying trends and providing actionable insights to drive business decisions

  • Answered by AI
  • Q2. How does Insurance companies work ?
  • Ans. 

    Insurance companies work by providing financial protection to individuals or organizations against potential risks or losses.

    • Insurance companies collect premiums from policyholders in exchange for coverage.

    • They assess risks and determine the appropriate premiums to charge based on factors such as age, health, and occupation.

    • Insurance companies invest the collected premiums to generate income and ensure they have suffic...

  • Answered by AI
  • Q3. Who is an actuary and what are his roles ?
  • Ans. 

    An actuary is a professional who assesses and manages financial risks using mathematics, statistics, and business knowledge.

    • Analyzing data to calculate probabilities of events such as death, sickness, injury, and property loss

    • Designing insurance policies and pension plans based on risk assessments

    • Helping companies make informed decisions on managing risks and setting premiums

    • Advising on investment strategies to ensure ...

  • Answered by AI
  • Q4. What is India's GDP and its growth rate ?
  • Ans. 

    India's GDP is $2.7 trillion with a growth rate of 4.2%.

    • India's GDP is one of the largest in the world.

    • As of 2020, India's GDP was $2.7 trillion.

    • The growth rate of India's GDP in 2020 was 4.2%.

    • India's GDP growth rate has been fluctuating over the years.

    • The COVID-19 pandemic had a significant impact on India's GDP growth.

  • Answered by AI
  • Q5. What are the Pros and Cons of Demonetization ?
  • Ans. 

    Demonetization has pros and cons that impact various aspects of the economy and society.

    • Pros: Curbing black money, reducing corruption, promoting digital transactions

    • Cons: Initial economic disruption, inconvenience to the public, impact on informal sector

    • Example of a pro: Demonetization helped uncover undisclosed income and led to an increase in tax compliance.

    • Example of a con: Small businesses and daily wage workers f

  • Answered by AI
  • Q6. If there are two data sets each with 100 variables and having 10000 and 12000 policies verify the validity of the second data set assuming the first one is accurate.
  • Ans. 

    The validity of the second data set can be verified by comparing it with the first data set.

    • Compare the variables in both data sets to ensure they are the same.

    • Check if the number of policies in the second data set matches the number stated.

    • Perform statistical analysis on both data sets to identify any discrepancies or inconsistencies.

    • Validate the accuracy of the second data set by cross-referencing it with external so

  • Answered by AI
  • Q7. Why do you want to work as an analyst ?
  • Ans. 

    I am passionate about analyzing data and deriving insights to drive informed decision-making.

    • I enjoy problem-solving and critical thinking, which are essential skills for an analyst.

    • I have a strong attention to detail and excel at organizing and interpreting complex information.

    • I am interested in utilizing data to identify trends, patterns, and opportunities for improvement.

    • I believe that my analytical skills can contr...

  • Answered by AI

Interview Preparation Tips

College Name: IIT Madras

Chubb Interview FAQs

How many rounds are there in Chubb Data Analyst interview?
Chubb interview process usually has 1 rounds. The most common rounds in the Chubb interview process are One-on-one Round.
How to prepare for Chubb 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, Python, SQL, Excel and Statistics.
What are the top questions asked in Chubb Data Analyst interview?

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

  1. How to separate portion before @ and after @ from mail using pyth...read more
  2. What is the rank, Dense Rank and Row Numb...read more
  3. What is SQL and diffrent joins in S...read more

Tell us how to improve this page.

Chubb Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Chubb Data Analyst Salary
based on 38 salaries
₹4 L/yr - ₹15.8 L/yr
46% more than the average Data Analyst Salary in India
View more details

Chubb Data Analyst Reviews and Ratings

based on 8 reviews

4.3/5

Rating in categories

4.0

Skill development

4.6

Work-life balance

4.0

Salary

4.1

Job security

4.5

Company culture

3.8

Promotions

3.9

Work satisfaction

Explore 8 Reviews and Ratings
Senior Software Engineer
269 salaries
unlock blur

₹9.2 L/yr - ₹28.1 L/yr

Technical Lead
225 salaries
unlock blur

₹16 L/yr - ₹45 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 Associate
40 salaries
unlock blur

₹4.8 L/yr - ₹15 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