Crisil Senior Data Engineer Interview Questions and Answers

Q1. Data modeling on website data
Add your answer
Q2. Spark performance tuning
Add your answer

They will ask aptitude, reasoning and other questions as an online test to know your problem solving skills.

They will give a topic where either we have to speak or write on that topic

Q1. Intro, questions related to python, guesstimate questions
Add your answer
Q2. Behavorial questions and other hr questions included
Add your answer

Q1. About SQL basics such as difference between delete and truncate, and some basic definitions.
Add your answer
Q2. About Python basics such as list, tuple and all.
Add your answer
Q3. Basic questions about Excel.
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. About Company Work Culture
Add your answer

Q1. What is difference between function and stored procedure
Ans. 
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value, while stored procedures can return multiple values.

• Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.

• Functions cannot have output parameters, while stored procedures can have output parameters.

• Functions cannot modify server ...read more
Answered by AI
Add your answer
Q2. How to implement custom exception in MVC
Ans. 
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
• Create a new class that inherits from Exception class

• Override the constructor to pass a custom message to the base Exception class

• Throw the custom exception in the MVC controller or service layer
Answered by AI
Add your answer

First round was on Hacker Earth

Q1. Technical round was on Spring Data Jpa, Pagination, SOLID principles
Add your answer

Q1. Explain the RAG pipeline?
Ans. 
RAG pipeline is a data processing pipeline used in data science to categorize data into Red, Amber, and Green based on certain criteria.
• RAG stands for Red, Amber, Green which are used to categorize data based on certain criteria

• Red category typically represents data that needs immediate attention or action

• Amber category represents data that requires monitoring or further investigation

• Green category represents data that...read more
Answered by AI
Add your answer
Q2. Explain Confusion metrics
Ans. 
Confusion metrics are used to evaluate the performance of a classification model by comparing predicted values with actual values.
• Confusion matrix is a table that describes the performance of a classification model.

• It consists of four different metrics: True Positive, True Negative, False Positive, and False Negative.

• These metrics are used to calculate other evaluation metrics like accuracy, precision, recall, and F1 s...read more
Answered by AI
Add your answer

Q1. Self intro and technical questions
Add your answer

Q1. Its all about statistical analysis
Add your answer

Q1. Basic questions based on resume
Add your answer

Q1. On skills mentioned in resume
Add your answer

Q1. Asked scenario based questions
Add your answer