Upload Button Icon Add office photos

Crif Solutions

Compare button icon Compare button icon Compare

Filter interviews by

Crif Solutions Business Analyst Interview Questions and Answers

Updated 10 Jul 2021

Crif Solutions Business Analyst Interview Experiences

1 interview found

I applied via Campus Placement and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions related to credit bureaus, knowledge of Python/R, projects done in the related domain

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with basics, be well informed about Credit Risk.

Interview questions from similar companies

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

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

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

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

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

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
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
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(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

  • Answered by AI
Round 2 - Coding Test 

SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

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

Round 1 - Coding Test 

Sql, python, statistical questions

Round 2 - HR 

(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

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

  • Answered by AI
Round 3 - Coding Test 

4 sql tasks on 3 tables. Joins, subqueries

Interview Preparation Tips

Interview preparation tips for other job seekers - Learm main statistics principles
Sql mandatory

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Brief me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. What is your experience as a data analyst?

I applied via Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on sql

Interview Preparation Tips

Interview preparation tips for other job seekers - it is good experience and moderate prepare for sql, data visualisation etc,it lasted for 2 hrs 30 mins. the interviwers want to test by both technical and soft skills
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(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]

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

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

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2022. 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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. SQL Window functions projects
Round 3 - Technical 

(1 Question)

  • Q1. ML questions case study

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare projects on resume and ML algorithms along with SQL questions

Data Analyst Interview Questions & Answers

PayPal user image Snehith Korukonda

posted on 21 Aug 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Round 2 - Coding Test 

Customer churn classification using a classification ML model

Round 3 - Technical 

(2 Questions)

  • Q1. Write a pseudo code for Bubble sort
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.

    • Start with the first element and compare it with the next element, swapping if necessary

    • Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

    • Continue this process for each element in the array until no more swaps are ne

  • Answered by AI
  • Q2. What is an API
  • Ans. 

    An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.

    • APIs define the methods for requesting and receiving data between software applications

    • APIs can be used to access data from external sources, such as social media platforms or weather services

    • Examples of APIs include the Twitter API, Google Maps API, and Spotify API

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Graduated with a degree in Statistics

    • Proficient in programming languages like Python and R

    • Experience in analyzing large datasets and creating data visualizations

    • Strong problem-solving skills and attention to detail

  • Answered by AI
  • Q2. Salaray compensation how much

Skills evaluated in this interview

Crif Solutions Interview FAQs

How to prepare for Crif Solutions Business Analyst 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 Crif Solutions. The most common topics and skills that interviewers at Crif Solutions expect are Business Analysis, Requirement Gathering, Documentation, Lending and Product Management.

Tell us how to improve this page.

Crif Solutions Business Analyst Salary
based on 53 salaries
₹5.5 L/yr - ₹20.5 L/yr
38% more than the average Business Analyst Salary in India
View more details

Crif Solutions Business Analyst Reviews and Ratings

based on 7 reviews

4.0/5

Rating in categories

4.0

Skill development

4.4

Work-life balance

3.9

Salary

4.0

Job security

4.4

Company culture

3.6

Promotions

4.3

Work satisfaction

Explore 7 Reviews and Ratings
Software Developer
80 salaries
unlock blur

₹3.5 L/yr - ₹14 L/yr

Business Analyst
53 salaries
unlock blur

₹5.5 L/yr - ₹20.5 L/yr

Softwaretest Engineer
34 salaries
unlock blur

₹3.3 L/yr - ₹11.5 L/yr

Senior Business Analyst
31 salaries
unlock blur

₹8.5 L/yr - ₹27.5 L/yr

Senior Software Developer
28 salaries
unlock blur

₹6.5 L/yr - ₹19.8 L/yr

Explore more salaries
Compare Crif Solutions with

Paytm

3.3
Compare

HighRadius

2.9
Compare

Broadridge Financial Solutions

3.9
Compare

PayPal

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