i
Chubb
Filter interviews by
Clear (1)
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 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 LinkedIn
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.
posted on 20 Jun 2024
Aptitude and other questions SQL and R and Python
I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 4 interview rounds.
All basic and mid reasoning level
LSTM RNN is a type of RNN that can learn long-term dependencies, while simple RNN struggles with vanishing/exploding gradients.
LSTM RNN has more complex architecture with memory cells, input, forget, and output gates.
Simple RNN has a single tanh activation function and suffers from vanishing/exploding gradients.
LSTM RNN is better at capturing long-term dependencies in sequences.
Simple RNN is simpler but struggles with
Lasso regression is a type of linear regression that uses L1 regularization to prevent overfitting by adding a penalty term to the loss function.
Lasso regression helps in feature selection by shrinking the coefficients of less important features to zero.
It is particularly useful when dealing with high-dimensional data where the number of features is much larger than the number of samples.
The regularization parameter in...
Fine tuning a LLM model involves adjusting hyperparameters to improve performance.
Perform grid search or random search to find optimal hyperparameters
Use cross-validation to evaluate different hyperparameter combinations
Regularize the model to prevent overfitting
Adjust learning rate and batch size for better convergence
Consider using techniques like early stopping to prevent overfitting
Calculate number of a/c sold in delhi
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
249
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
206
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
127
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Scientist
40
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
39
salaries
| ₹0 L/yr - ₹0 L/yr |
AIG
Allianz
AXA
Zurich Insurance