i
Chubb
Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min
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.
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.
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
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-...
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
Top trending discussions
I appeared for an interview in Aug 2024.
I applied via Approached by Company and was interviewed in Nov 2023. There were 2 interview rounds.
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 ...
I applied via Naukri.com and was interviewed before Jun 2020. There was 1 interview round.
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
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...
I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.
Easy
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...
posted on 18 Sep 2021
I applied via Referral and was interviewed in Mar 2021. There was 1 interview round.
I applied via LinkedIn
posted on 20 Jun 2024
All the questions are based on the MCQ , and the syllabus is covered python SQL Power BI
Some questions from the Pandas Data Frame scenario based
Some of the top questions asked at the Chubb Senior Data Analyst interview -
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
274
salaries
| ₹9.2 L/yr - ₹28 L/yr |
Technical Lead
238
salaries
| ₹16 L/yr - ₹46 L/yr |
Software Engineer
128
salaries
| ₹6 L/yr - ₹17 L/yr |
Data Scientist
49
salaries
| ₹8.5 L/yr - ₹23 L/yr |
Senior Analyst
42
salaries
| ₹6.8 L/yr - ₹24 L/yr |
HDFC Life
ICICI Prudential Life Insurance
Axis Max Life Insurance
Bajaj Allianz Life Insurance