i
Chubb
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Dec 2021. There were 4 interview rounds.
Primary key uniquely identifies a record in a table, while unique key ensures that all values in a column are distinct.
Primary key can't have null values, while unique key can have one null value.
A table can have only one primary key, but multiple unique keys.
Primary key is used as a foreign key in other tables, while unique key is not.
Example: Employee ID can be a primary key, while email address can be a unique key.
Stored procedures are pre-written SQL codes that can be saved and reused multiple times.
Stored procedures are used to simplify complex queries and reduce network traffic.
They can be used to perform multiple operations in a single transaction.
They can be parameterized to accept input values and return output values.
They can be used to enforce business rules and security measures.
Examples include creating a new user, upd
Top trending discussions
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
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
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)
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
posted on 13 Aug 2024
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There was 1 interview round.
Deep learning is used over statistical models for complex, non-linear relationships in data.
Deep learning can automatically learn hierarchical representations of data, capturing intricate patterns and relationships.
Statistical models may struggle with high-dimensional data or non-linear relationships, where deep learning excels.
Deep learning can handle unstructured data like images, audio, and text more effectively tha...
XGB is better than RF due to its ability to handle complex relationships and optimize performance.
XGB uses gradient boosting which allows for better handling of complex relationships compared to RF
XGB optimizes performance by using regularization techniques to prevent overfitting
XGB is faster and more efficient in training compared to RF
XGB allows for parallel processing which can speed up computation
XGB has been shown...
posted on 17 Mar 2024
I applied via Recruitment Consulltant and was interviewed in Jul 2021. There were 2 interview rounds.
Feature engineering is the process of selecting and transforming relevant features from raw data to improve model performance.
Identify relevant features based on domain knowledge and data exploration
Transform features to improve their quality and relevance
Create new features by combining or extracting information from existing features
Select the most important features using feature selection techniques
Iterate the proc
I have used logistic regression and decision tree models for classification.
Logistic regression is a linear model used for binary classification.
Decision tree is a non-linear model used for multi-class classification.
Logistic regression is simple and easy to interpret while decision tree can handle non-linear relationships.
I chose these models based on the nature of the data and the problem at hand.
Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.
Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.
There are four types of actions in Tableau: filter, highlight, URL, and parameter.
For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight ...
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
241
salaries
| ₹9.2 L/yr - ₹29 L/yr |
Technical Lead
198
salaries
| ₹16 L/yr - ₹46 L/yr |
Software Engineer
120
salaries
| ₹6 L/yr - ₹17 L/yr |
Senior Analyst
41
salaries
| ₹6.5 L/yr - ₹23 L/yr |
Data Scientist
39
salaries
| ₹8.5 L/yr - ₹26.5 L/yr |
AIG
Allianz
AXA
Zurich Insurance