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. Self intro and technical questions
Add your answer

Q1. Its all about statistical analysis
Add your answer

Q1. How can you explain your work experience and describe how you can contribute to the organization?
Ans. 
I have extensive experience in analyzing data to provide valuable insights and drive decision-making. I can contribute by leveraging my skills to improve processes and optimize performance.
• I have worked with various data analysis tools and techniques to extract, clean, and analyze data sets.

• I have experience in creating visualizations and reports to communicate findings to stakeholders.

• I have a track record of identify...read more
Answered by AI
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