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 Analyst Intern Interview Questions and Answers

Updated 18 Oct 2023

Crisil Data Analyst Intern Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at SIES College of Management Studies (SIESCMS) and was interviewed in Apr 2023. There were 3 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 - Technical 

(1 Question)

  • Q1. What is rdms? what are the objects in database? difference between olap and oltp? what is view? what is index? what are functions and stored procedures? what are constrains? what are foreign keys?
  • Ans. 

    RDBMS is a relational database management system. Objects in a database include tables, views, indexes, functions, stored procedures, constraints, and foreign keys. OLAP is for data analysis while OLTP is for transaction processing.

    • RDBMS stands for Relational Database Management System

    • Objects in a database include tables, views, indexes, functions, stored procedures, constraints, and foreign keys

    • OLAP (Online Analytical...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. About company? about yourself?

Skills evaluated in this interview

HCLTech

Workplace transformation starts with you

Explore various roles and find your spark with us

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions

Round 2 - Group Discussion 

Brand Assortment strategies

Round 3 - One-on-one 

(1 Question)

  • Q1. Guestimate questions , example case study
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Can you elaborate on your work experience?
  • Ans. 

    I have 5 years of experience in analyzing large datasets to extract valuable insights and make data-driven decisions.

    • Analyzed customer behavior data to optimize marketing strategies

    • Built predictive models to forecast sales trends

    • Utilized machine learning algorithms to improve product recommendations

    • Presented findings to stakeholders in a clear and actionable manner

  • Answered by AI
  • Q2. What questions were asked regarding your work experience?
  • Ans. 

    Questions related to work experience in data science field.

    • Asked about previous projects worked on

    • Inquired about specific data analysis techniques used

    • Discussed challenges faced and how they were overcome

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain any ML model.
  • Q2. Create Dataframe from two lists.

Interview Preparation Tips

Topics to prepare for Nielsen Data Scientist interview:
  • Python
  • pandas
  • ML
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • 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...

  • Answered by AI
  • 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...

  • Answered by AI

Skills evaluated in this interview

Data Scientist Interview Questions & Answers

C5i user image Kushal Kulkarni

posted on 18 Jun 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in May 2024.

Round 1 - Assignment 

Questions based on ML,PYTHON, DATA VISUALIZATION

Round 2 - Technical 

(2 Questions)

  • Q1. What is TF-IDF IN NLP
  • Ans. 

    TF-IDF is a numerical statistic that reflects the importance of a word in a document relative to a collection of documents.

    • TF-IDF stands for Term Frequency-Inverse Document Frequency

    • It is used in Natural Language Processing (NLP) to determine the importance of a word in a document

    • TF-IDF is calculated by multiplying the term frequency (TF) by the inverse document frequency (IDF)

    • It helps in identifying the most important

  • Answered by AI
  • Q2. Python coding questions based on list

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice python
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Case Study 

Excel data analytics case

Round 2 - Technical 

(1 Question)

  • Q1. Data analytics, data visualisation tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn Clik and SQL
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

SQL, Python coding …

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

I applied via campus placement at Sastra University and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Along with coding round..there's a communication test at the end

Round 2 - Technical 

(2 Questions)

  • Q1. There's ntg to ask about technical for me..
  • Q2. Behavioural questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - Coding Test 

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Round 2 - One-on-one 

(1 Question)

  • Q1. Explain the Project undertaken during the research and follow-up questions
Round 3 - Technical 

(1 Question)

  • Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...
  • Ans. 

    Answering questions related to data science concepts and techniques.

    • Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

    • To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Nielsen Data Scientist interview:
  • Python
  • Pandas
  • SQL
  • Machine Learning
Interview preparation tips for other job seekers - Have your basics strong.

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Crisil Interview FAQs

How many rounds are there in Crisil Data Analyst Intern interview?
Crisil interview process usually has 3 rounds. The most common rounds in the Crisil interview process are Resume Shortlist, Technical and HR.

Recently Viewed

INTERVIEWS

Apptunix

7 interviews

INTERVIEWS

Innov8

3 interviews

INTERVIEWS

Skolar

20 interviews

INTERVIEWS

MRF Tyres

298 interviews

INTERVIEWS

Wingsure

2 interviews

INTERVIEWS

KodNest

21 interviews

INTERVIEWS

Edifecs

13 interviews

INTERVIEWS

Faurecia

59 interviews

INTERVIEWS

Visible Alpha Solutions

No Interviews

INTERVIEWS

HPCL Rajasthan Refinery

No Interviews

Tell us how to improve this page.

Crisil Data Analyst Intern Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Sun Pharmaceutical Industries

Join us and thrive in a company culture that inspires and empowers.

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
Kantar Interview Questions
3.5
 • 96 Interviews
Netscribes Interview Questions
2.8
 • 83 Interviews
Cotiviti Interview Questions
3.9
 • 73 Interviews
Sigmoid Interview Questions
3.2
 • 59 Interviews
Hgs Services Interview Questions
4.0
 • 55 Interviews
View all

Crisil Data Analyst Intern Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

1.0

Skill development

3.0

Work-life balance

1.0

Salary

4.0

Job security

3.0

Company culture

1.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Research Analyst
948 salaries
unlock blur

₹5 L/yr - ₹18 L/yr

Senior Research Analyst
809 salaries
unlock blur

₹7.3 L/yr - ₹26 L/yr

Analyst
509 salaries
unlock blur

₹3 L/yr - ₹14 L/yr

Manager
462 salaries
unlock blur

₹12 L/yr - ₹36 L/yr

Credit Analyst
426 salaries
unlock blur

₹5 L/yr - ₹17 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent