AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Crif Solutions Data Analyst Interview Questions, Process, and Tips
Top Crif Solutions Data Analyst Interview Questions and Answers
- Q1. What is the difference between linear and logistic reg.?
- Q2. What is Logistic Regression? What is Recall
- Q3. What are the performance metrics of Regression
Crif Solutions Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.
(5 Questions)
- Q1. Basics of Logistic regression
- Q2. What is Logistic Regression? What is Recall
- Ans.
Logistic Regression is a statistical method used to model the probability of a certain event occurring based on one or more predictor variables. Recall is a metric used to evaluate the performance of a classification model.
Logistic Regression is used for binary classification tasks, where the outcome variable is categorical and has two classes.
It estimates the probability that a given input belongs to a certain categor...
- Q3. What is Recall?
- Ans.
Recall is a metric used in classification models to measure the ability of the model to find all relevant cases within a dataset.
Recall is calculated as the number of true positive predictions divided by the sum of true positive and false negative predictions.
It is also known as sensitivity or true positive rate.
A high recall indicates that the model is good at identifying all relevant cases, even if it means more fals...
- Q4. What is the difference between linear and logistic reg.?
- Ans.
Linear regression is used for predicting continuous values, while logistic regression is used for predicting binary outcomes.
Linear regression is used when the target variable is continuous and has a linear relationship with the independent variables.
Logistic regression is used when the target variable is binary or categorical and the relationship between independent variables and the target is non-linear.
Linear regres...
- Q5. What are the performance metrics of Regression
- Ans.
Performance metrics of Regression include Mean Squared Error, R-squared, Mean Absolute Error, etc.
Mean Squared Error (MSE)
R-squared (R^2)
Mean Absolute Error (MAE)
Root Mean Squared Error (RMSE)
Adjusted R-squared
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.
Statistics assignment on given dataset
(1 Question)
- Q1. Credit Risk, loan disbursement process, PD model , machine learning
Interview Preparation Tips
Interview questions from similar companies
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. What techonologies do you know?
- Ans.
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
SQL
Python
R
Tableau
Excel
SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard
Interview Questionnaire
5 Questions
- Q1. Tell me about yourself
- Ans.
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
Experienced in using statistical analysis tools such as Python, R, and SQL
Proficient in data visualization tools like Tableau and Power BI
Skilled in data cleaning, data mining, and data modeling techniques
Strong problem-solving and critical thinking skills
Effective communicator and team player
Example: I have w...
- Q2. Biggest hurdle you faced during the work you did t organise the tech fest of your college
- Ans.
The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.
Difficulty in convincing companies to sponsor the event
Limited budget for organizing a large-scale tech fest
Competition with other college events for sponsorships
Negotiating sponsorship deals and ensuring deliverables
Finding sponsors aligned with the theme and objectives of the tech fest
- Q3. Would you go for an MBA?
- Ans.
Yes, pursuing an MBA can enhance my skills and open up new career opportunities.
An MBA can provide a strong foundation in business and management principles.
It can help develop analytical and problem-solving skills.
An MBA can broaden my network and provide access to valuable connections.
It can open up leadership roles and higher-level positions in organizations.
Having an MBA can increase earning potential and job prosp...
- Q4. Reliance fresh wants to open a store in north-eastern part of India. Should it or should it not?
- Ans.
Yes, Reliance Fresh should open a store in the north-eastern part of India.
The north-eastern part of India has a growing population and increasing consumer demand.
Reliance Fresh can tap into the untapped market potential in the region.
Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.
Reliance Fresh can leverage its existing supply chain and dist...
- Q5. Guesstimate the number of people travelling by local metro in mumbai
- Ans.
The number of people travelling by local metro in Mumbai is estimated to be in millions.
Mumbai has a population of over 20 million people.
The local metro is a popular mode of transportation in Mumbai.
During peak hours, the metro trains are usually crowded.
The metro network in Mumbai is extensive, covering various parts of the city.
The number of daily commuters on the metro can be estimated based on population density a
Interview Preparation Tips
Experience: cpi above 7.0
Round: Test
Experience: Basic maths, shares related questions and english
Duration: 1 hour
Total Questions: 40
Round: Technical + HR Interview
Experience: Very easy round.
Skills: Aptitude, Communication, Quantitative Aptitude, Leadership Skills, Technical Skill
College Name: IIT Kanpur
AKASH KUMAR SINGH
I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.
Interview Questionnaire
4 Questions
- Q1. For this round he gave me lot of problems and asked to develop optimal algorithm to solve that. Problems were mainly on trees and number sequences
- Q2. In this round he mainly discussed my projects and asked me how these can be put to use in Paypal. He also asked some basic questions from ML
- Q3. HR round was just for formality
- Q4. Probability , question on calculating expected number of trials and puzzles
Interview Preparation Tips
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes
Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well
Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems
Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.
College Name: IIT Madras
I applied via Company Website
Interview Questionnaire
1 Question
- Q1. Tell me about a project you worked on in which you handled large set of data and multiple tables.
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.
(1 Question)
- Q1. Brief me about yourself
(1 Question)
- Q1. What is your experience as a data analyst?
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Sql, python, statistical questions
(2 Questions)
- Q1. How daily work looks like?
- Ans.
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
Reviewing and cleaning data sets
Creating visualizations and dashboards
Conducting statistical analysis
Communicating insights to non-technical stakeholders
- Q2. Most ise tools?
- Ans.
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
Excel is widely used for data manipulation and analysis.
Python and R are popular programming languages for data analysis and machine learning.
Tableau is a powerful data visualization tool.
SQL is essential for querying databases and extracting data.
4 sql tasks on 3 tables. Joins, subqueries
Interview Preparation Tips
Sql mandatory
Skills evaluated in this interview
sameer kulkarni
(2 Questions)
- Q1. SQL case study for data
- Q2. Find nth salary
- Ans.
To find the nth salary in a dataset
Sort the dataset in descending order based on salary
Remove duplicates if necessary
Return the salary at index n-1
I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.
(3 Questions)
- Q1. Implement lag() and lead() without using lag() or lead()
- Ans.
Implement lag() and lead() functions without using lag() or lead()
To implement lag(), shift the values in the array by one position to the right
To implement lead(), shift the values in the array by one position to the left
For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]
For lead(), you can shift the values to get [2, 3, 4, null]
- Q2. How will you go about optimising a query?
- Ans.
Optimising a query involves identifying bottlenecks and improving efficiency.
Identify slow-performing queries using tools like query execution plans.
Optimize database indexes to speed up query performance.
Limit the number of columns and rows returned in the query.
Avoid using SELECT * and instead specify only the necessary columns.
Use appropriate data types and avoid unnecessary data conversions.
Consider denormalizing d...
- Q3. If the 3rd position in a string contains 'b' replace it with 'v'
- Ans.
Replace 'b' with 'v' in the 3rd position of each string in an array
Iterate through each string in the array
Check if the 3rd position contains 'b'
If yes, replace 'b' with 'v'
Skills evaluated in this interview
Crif Solutions Interview FAQs
Tell us how to improve this page.
Crif Solutions Interviews By Designations
- Crif Solutions Data Analyst Interview Questions
- Crif Solutions Test Analyst Interview Questions
- Crif Solutions Associate Analyst Interview Questions
- Crif Solutions Risk Analyst Interview Questions
- Crif Solutions Analyst Interview Questions
- Crif Solutions Manager Interview Questions
- Crif Solutions Software Developer Interview Questions
- Crif Solutions Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Crif Solutions Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Crif Solutions Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Software Developer
80
salaries
|  ₹3.5 L/yr - ₹14 L/yr |
|
Business Analyst
53
salaries
| ₹5.5 L/yr - ₹20.5 L/yr |
|
Softwaretest Engineer
34
salaries
| ₹3.3 L/yr - ₹11.5 L/yr |
|
Senior Business Analyst
31
salaries
| ₹8.5 L/yr - ₹27.5 L/yr |
|
Senior Software Developer
28
salaries
| ₹6.5 L/yr - ₹19.8 L/yr |
Paytm
HighRadius
Broadridge Financial Solutions
PayPal
- Home >
- Interviews >
- Crif Solutions Interview Questions >
- Crif Solutions Data Analyst Interview Questions
