Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Crisil Team. If you also belong to the team, you can get access from here

Crisil Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Crisil Data Engineer Interview Questions and Answers

Updated 3 Apr 2024

Crisil Data Engineer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There were 5 interview rounds.

Round 1 - Coding Test 

Python problem questions
SQL problem questions

Round 2 - One-on-one 

(1 Question)

  • Q1. 1. Difference between shallow copy and deep copy 2. How can you merge two dataframes with different column names 3. Regex question to find all the characters and numbers of particular length size 4. Spark ...
  • Ans. 

    1. Shallow copy creates a new object but does not duplicate nested objects. Deep copy creates a new object and duplicates all nested objects. 2. Merging dataframes with different column names requires renaming columns. 3. Regex can be used to find characters and numbers of a specific length. 4. Spark fundamentals involve understanding distributed computing and data processing.

    • Shallow copy: new object with same referenc...

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. 1. Design data architecture for a particular scenario 2. Spark optimisation questions for the given scenario
Round 4 - One-on-one 

(1 Question)

  • Q1. This was my director round where all the business related ettiquitess, emotional quotient and plans to remain in the society.
Round 5 - HR 

(1 Question)

  • Q1. Basic salary discussion and company policies

Interview Preparation Tips

Topics to prepare for Crisil Data Engineer interview:
  • Python
  • Pyspark
  • SQL
Interview preparation tips for other job seekers - Be well prepared

Skills evaluated in this interview

Data Engineer Jobs at Crisil

View all

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions related to Java, Spring, Rest API
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic java collection questions
Round 2 - Technical 

(1 Question)

  • Q1. Spring boot basic questions
Round 3 - HR 

(1 Question)

  • Q1. Why should we hire you
  • Ans. 

    I have a strong technical background, proven track record of delivering high-quality software, and a passion for continuous learning and improvement.

    • I have a Bachelor's degree in Computer Science and X years of experience in software development.

    • I have successfully led multiple projects from conception to completion, delivering high-quality software on time and within budget.

    • I am proficient in a variety of programming ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not even apply
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Share the link for codesignal

Round 2 - Technical 

(2 Questions)

  • Q1. Java related questions
  • Q2. Based on the resume
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Current time and their angles
  • Ans. 

    The question is asking for the current time and the angles formed by the hour and minute hands on a clock.

    • The angle between the hour and minute hands of a clock can be calculated using the formula: angle = |(30*hour - (11/2)*minutes)|

    • At 3:00, the angle between the hour and minute hands is 90 degrees.

    • At 6:00, the angle between the hour and minute hands is 180 degrees.

    • At 9:00, the angle between the hour and minute hands

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Didnt qual here btw
Round 3 - HR 

(1 Question)

  • Q1. Didnt qual either btw
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Angular and JavaScript.
Round 2 - One-on-one 

(2 Questions)

  • Q1. Behavioral Questions
  • Q2. CI-CD, Jenkins, AWS
Round 3 - One-on-one 

(1 Question)

  • Q1. Client Interview - Security related.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

There was a coding round and out of 75 students 28 got selected for next round

Round 2 - Technical 

(2 Questions)

  • Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
  • Q2. Explain your project in detail and asking cross questions regarding project.
Round 3 - Technical 

(1 Question)

  • Q1. I was rejected in round 2.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your resume thoroughly, and have a basic DSA knowledge.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are window functions and asked to find out the highest salary from each department.
  • Q2. What is Vlookup and formula of it
  • Ans. 

    Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.

    • Vlookup stands for 'Vertical Lookup'

    • It is used to search for a value in the first column of a table and return a value in the same row from a specified column

    • The syntax of Vlookup is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

    • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search...

  • Answered by AI
Round 2 - HR 

(3 Questions)

  • Q1. What do you know about TU CIBIL
  • Ans. 

    TU CIBIL is a credit information company in India that provides credit scores and reports to individuals and businesses.

    • TU CIBIL stands for TransUnion CIBIL Limited.

    • It is one of the leading credit bureaus in India.

    • It collects and maintains credit information of individuals and businesses.

    • Lenders use TU CIBIL reports to assess the creditworthiness of borrowers.

    • A good credit score from TU CIBIL can help in getting better

  • Answered by AI
  • Q2. What is credit score
  • Ans. 

    Credit score is a numerical representation of a person's creditworthiness, based on their credit history.

    • Credit score ranges from 300 to 850, with higher scores indicating better creditworthiness.

    • Factors that influence credit score include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.

    • Lenders use credit scores to assess the risk of lending money to individu...

  • Answered by AI
  • Q3. How many credit bureau's are there

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 3rd largest salary from each department(window function)

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL is Imp
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Intro about ratings
  • Q2. Intro with CBO, basic questing regarding the company
Contribute & help others!
anonymous
You can choose to be anonymous

Crisil Interview FAQs

How many rounds are there in Crisil Data Engineer interview?
Crisil interview process usually has 5 rounds. The most common rounds in the Crisil interview process are One-on-one Round, Coding Test and HR.
How to prepare for Crisil Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Crisil. The most common topics and skills that interviewers at Crisil expect are Python, SQL, Data Modeling, Spark and Financial Services.
What are the top questions asked in Crisil Data Engineer interview?

Some of the top questions asked at the Crisil Data Engineer interview -

  1. 1. Difference between shallow copy and deep copy 2. How can you merge two dataf...read more
  2. This was my director round where all the business related ettiquitess, emotiona...read more
  3. 1. Design data architecture for a particular scenario 2. Spark optimisation que...read more

Recently Viewed

REVIEWS

Celebal Technologies

No Reviews

REVIEWS

Celebal Technologies

No Reviews

REVIEWS

Celebal Technologies

No Reviews

SALARIES

Fractal Analytics

SALARIES

Sigmoid

LIST OF COMPANIES

Sigmoid

Overview

SALARIES

Sigmoid

SALARIES

Affine

SALARIES

Fractal Analytics

INTERVIEWS

Analyttica Datalab

No Interviews

Tell us how to improve this page.

Crisil Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Indegene Interview Questions
3.4
 • 151 Interviews
Nielsen Interview Questions
3.7
 • 117 Interviews
Netscribes Interview Questions
2.8
 • 83 Interviews
Cotiviti Interview Questions
3.9
 • 73 Interviews
View all
Crisil Data Engineer Salary
based on 7 salaries
₹7.5 L/yr - ₹27 L/yr
47% more than the average Data Engineer Salary in India
View more details

Crisil Data Engineer Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

3.0

Salary

4.0

Job security

5.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Financial Data Engineer

Mumbai

3-8 Yrs

Not Disclosed

Financial Data Engineer

Mumbai,

Chennai

3-8 Yrs

Not Disclosed

Explore more jobs
Research Analyst
957 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Research Analyst
799 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
509 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
461 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Credit Analyst
426 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Crisil with

ICRA

3.3
Compare

India Ratings & Research

3.8
Compare

Brickwork Ratings

3.7
Compare

SMERA Ratings

2.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview