i
Chubb
Filter interviews by
Top trending discussions
posted on 9 Nov 2024
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
End to end project architecture involves designing and implementing a data pipeline to process and analyze data from various sources.
Define project requirements and goals
Design data architecture including data sources, storage, processing, and analytics tools
Implement data pipeline to extract, transform, and load data
Ensure data quality and consistency throughout the pipeline
Monitor and optimize performance of the data...
Implemented query optimization techniques to improve performance in data processing.
Utilized indexing to speed up data retrieval
Optimized SQL queries by rewriting them for better performance
Implemented caching mechanisms to reduce redundant data processing
Using Common Table Expressions (CTEs) to delete duplicates in SQL query
Use a CTE to identify duplicates by ranking rows based on a unique identifier
Delete rows with duplicate ranks in the main query
Reverse a list without using inbuilt functions
Create two pointers, one at the start and one at the end of the array
Swap the elements at the two pointers and move them towards the center until they meet
Repeat the process until the entire list is reversed
End to end project implementation involves taking a project from conception to completion, including planning, development, testing, and deployment.
Define project goals and requirements
Design data pipelines and architecture
Develop and implement data processing algorithms
Test and validate data quality and accuracy
Deploy and monitor the project in production
Iterate and improve based on feedback
SQL joins combine data from two or more tables based on a related column between them.
Different types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
The number of records in the result of a join depends on the type of join and the data in the tables.
For example, an INNER JOIN will only return records that have matching values in both tables, while a LEFT JOIN will return all records from the left...
Questions on python programming- 2 and SQL-1
They will ask from you resume
First round will be aptitude test
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
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)
posted on 16 Apr 2024
I applied via Campus Placement
Basic 10 apti question
Basic 5 python question
Basic 5 SQL question
I applied via Campus Placement
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
233
salaries
| ₹9.2 L/yr - ₹29 L/yr |
Technical Lead
194
salaries
| ₹16 L/yr - ₹46 L/yr |
Software Engineer
115
salaries
| ₹6 L/yr - ₹17 L/yr |
Data Scientist
43
salaries
| ₹8.5 L/yr - ₹25.2 L/yr |
Senior Analyst
41
salaries
| ₹6.5 L/yr - ₹23 L/yr |
AIG
Allianz
AXA
Zurich Insurance