Upload Button Icon Add office photos

Filter interviews by

Credit Information Bureau Data Analyst Interview Questions and Answers

Updated 27 Aug 2024

Credit Information Bureau Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Aug 2024

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 questions from similar companies

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

I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What's is work experience.
  • Ans. 

    Work experience refers to the practical knowledge and skills gained from employment in a specific field or industry.

    • Work experience includes tasks, responsibilities, and projects completed in a professional setting.

    • It can be gained through internships, part-time jobs, full-time positions, or volunteer work.

    • Work experience helps individuals develop industry-specific skills, build a professional network, and gain a bette...

  • Answered by AI
  • Q2. Whats is sql and power bi.
  • Ans. 

    SQL is a programming language used for managing and querying databases. Power BI is a business analytics tool for visualizing and analyzing data.

    • SQL stands for Structured Query Language and is used to communicate with databases.

    • SQL can be used to retrieve, update, and manipulate data in databases.

    • Power BI is a data visualization tool that allows users to create interactive reports and dashboards.

    • Power BI can connect to...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Case Study 

Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here

Round 2 - Technical 

(1 Question)

  • Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare you resume and case studies well.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is the number of tourist per day in jaipur
  • Ans. 

    The number of tourists per day in Jaipur varies depending on the season and events happening in the city.

    • Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

    • Events like festivals or cultural events can attract more tourists

    • Historical sites like Amer Fort and Hawa Mahal are popular attractions

    • Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions

  • Answered by AI
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 Nov 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 tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

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

    • Experienced in analyzing large datasets and extracting meaningful insights

    • Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

    • Skilled in SQL for data querying and manipulation

    • Strong problem-solving and critical thinking abilities

    • Effective communication skills for presenting findings to stakeholders

  • Answered by AI
  • Q2. Projects you have done
  • Ans. 

    Developed a predictive model to forecast customer churn for a telecommunications company.

    • Used machine learning algorithms to analyze customer data

    • Performed feature engineering to identify key predictors of churn

    • Built and trained a model using historical data

    • Evaluated model performance and provided actionable insights to reduce churn

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Crisil Data Analyst interview:
  • Python
  • sql
  • guest estimate
  • machine learning

I applied via Company Website and was interviewed in Apr 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 tips
Round 2 - Group Discussion 

Improve your skills

Interview Preparation Tips

Interview preparation tips for other job seekers - If, now iam working in this company, i will make this company no.1 position with the help of group discussion

I was interviewed before Jun 2016.

Interview Preparation Tips

Round: Resume Shortlist
Experience: McKinsey looks for a spike in your resume, people who have commendable achievements is their field of choice, academics, extra curriculars or sports. So be sure to make your resume accordingly. McKinsey adds a lot of weight-age to formal awards, scholarships, achievements (like inter-IIT) etc. But if you don?t have them (like me) you just have to make extra effort to show that you have equivalent achievements.

Round: Technical + HR Interview
Experience: First I was asked about myself and mostly my connection to dance and the dance club. (Some interviewers do this to make you comfortable at the same time analyzing your personality). In the first interview I was given an estimation case about the dish TV industry. Here the interviewer was mostly interested in my approach to solving the problem and if applicable my numerical skills. The second interview was a pure business case about the printing business. Here my creativity and business sense (read common sense as applicable to a business situation) was put to test.
Tips: Take on every interview as if that job doesn?t mean anything to you.

Interview Preparation Tips

Round: HR Interview
Experience: They had 4 interviews.
McK1: Have faint recollections. However I remember I did well on the case and had loadsa HR involved specially in my work on internships and research paper.

Round: Technical Interview
Experience: McK2: The interviewer was a PhD in Chem Engg from Stanford followed by an MBA from Harvard. I found this before going in and got real nervous. He started off with some Chemical Engg questions and soon realized it was no use! (He did even comment that I had not learnt anything in Chem engg in the 4 years). We then moved on a case of petrochemical industry where a new player wanted to enter an oversaturated market. I concluded that scale is important and the entry has to be below the existing market price. Some HR including my question to him. Had a long discussion on Foreign MBA vs Indian MBA. At the end of the interview, I guess I had done a good enough job (surprisingly after the start I had) and was called in for the next 2 interviews..

Round: Case Study Interview
Experience: McK3: This was a disaster! And a big one. I was given an extremely easy case on nuclear reactor vs coal reactor economics. Simple mathematics which I screwed up because of just 1 simple error. I realized the same pretty late and pointed it out. He said it was ok. No HR

Round: Other Interview
Experience: McK4: The whole interview was a discussion on my BTP and seminar. BTP was related to Phosphoric Acid production. The discussion revolved around whether phosphoric acid should be produced in India or whether we should produce it outside from where we import ore. Then we moved on to my seminar which was related to Kyoto Protocol. Finally I asked question on how different is a foreign MBA vis a vis an Indian one. Very peaceful and fun interview!
Tips: The single biggest mistake I committed was going in a haste into the McK 3rd interview. I got involved in some placement work between the interviews and forgot to carry my folder or even a pen. This is probably why I did not do well on the case (which was probably the easiest of all 8). Its very important that you take 5 minutes off before walking in, get your composure and stop worrying about other things and just attend to the interview on hand. Key learnings included the fact that it is relatively difficult to come back if you don't start well. Thus its is better to take something like 5 seconds before you answer the first 2-3 questions to recollect thoughts, organize them and frame them well. Also that you need to be comfortable with everything on your resume. I appeared for 8 interviews and never mentioned/was asked anything related to MI which I thought was the most important point on my resume. Instead I was questioned on my hobbies. Smallest points on the resume could be the ones you are grilled most on. Another very important thing about case interviews is the fact that the interviewer will be guiding you all through to the final solution. Any thing that he speaks should be heard and taken notice of. Most of the times there will be a small hint given at some point and all you need to do is catch on to it! Structuring your answers is extremely important. One more important thing to keep in mind is that all your answers should kind of show to the company that you can FIT into the company, the job and the culture. It is also important you walk in with the feeling that you can get the job. Specifically in cases, if you get stuck, take some time off to think. Structure your solution well, it carries the maximum weight.

General Tips: Firstly suit up only in case you are comfortable in it. It makes no sense to wear it and be uncomfortable throughout. And in my opinion even if you do not wear one, it never goes against you (at least consulting). For companies like FMCG/Tech its better not to suit up because it doesn't go with the company cultures. If its IBanking, it is good if you wear one. It is very important that you have some questions for the interviewer for any given company. And it is more important that the questions are intelligent and genuine. Attending PPT/ reading up website is a must for the same. Most importantly you should not talk to any other candidate on interview experience before your interview. The interview changes for every candidate. If say for example you hear the case beforehand, the company is bound to find out which would ruin your chances for sure. Further talking to people who have already appeared increases the nervousness. Posture is something that you have to take care of. People have a tendency to relax which should not be the case. You should seem eager for both the interview and the job. While answering any question the most important things to keep in mind are • Take 5 seconds off before venturing into any answer. Compose your thoughts real well. Then start. Its better to get the whole thing in a impactful way then to miss out on certain points. It also doubles up as giving the interview a feel that you are thinking before answering.
College Name: IIT BOMBAY

Interview Questionnaire 

1 Question

  • Q1. For company X profit decreases can you find the reason?
  • Ans. 

    Profit decrease reasons for company X

    • Decrease in sales revenue

    • Increase in production costs

    • Economic downturn

    • Competition

    • Changes in consumer behavior

    • Poor management decisions

    • External factors such as natural disasters or political instability

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 3-4 case study with multiple choice answers.
Duration: 60-65 mins minutes

Round: Preparation round
Experience: A meeting was held where each and every selected candidate in test is assigned a buddy(company official).
Tips: You should maintain a good relation with him so that you can call him anytime to solve a case study together

Round: HR Interview
Experience: Each round (5 round) was HR based and case study was given.
Tips: Objective and clear with all resume points.

General Tips: Objective and clear with all resume points. Basically I am good at speaking,so I didn't prepare much for interview.
Skill Tips: Solved 3-4 case study with my PSG buddy. Solved 45-50 case studies before the interview from many materials.
Skills: Adapting to many situations., Leading different organization basically PORs.
College Name: IIT MADRAS

Interview Questionnaire 

7 Questions

  • Q1. CASE: Guesstimate+ case on a coaching class for JEE prep. The size of the JEE coaching etc
  • Q2. Why consulting?
  • Ans. 

    Consulting offers diverse opportunities to work with different clients and industries, constantly learn and grow, and make a significant impact.

    • Consulting provides exposure to a variety of clients and industries, allowing for continuous learning and development.

    • Consultants have the opportunity to work on challenging projects and solve complex problems.

    • Consulting offers the chance to make a significant impact on clients...

  • Answered by AI
  • Q3. Guesstimate+ case: I was asked to choose an industry. He then gave me a case on the possible entry of Peugeot in the indian markets
  • Q4. About my resume and internships
  • Q5. About my future plans
  • Q6. About CPI and why it was not higher
  • Q7. About what areas I like in elec

Interview Preparation Tips

Round: Case Study Interview
Experience: After I finished answering my first case she went on to ask if I would like to run a coaching class someday. Then she asked me about the kind of job I would like to take up and why.
She finally asked if I had some questions for them and I asked 2-3 questions. I thought I did really well and came out confident

Round: Case Study Interview
Experience: I asked him a couple of quetions on the same before jumping into the case. Didn't let me finish the case, just saw the approach and left it at that.
The next half hour was a discussion on how to make career choices and how he chose between 3 consulting firms he interviewed with through IIMs.

Round: HR Interview
Experience: I said I liked power and he asked me about power industry in India and about what I thought about possible products etc.
Then he asked me about my views on India's potential as a manufacturing superpower vs China. I presented my views and then he corrected me massively with his ideas. He went on to explain the kind of work Mck does and how it can help in my long term career objectives.

Later, he asked me about my perception of consulting firms and the reason behind it.

Round: HR Interview
Experience: No questions. Just a discussion on how I should make career choices and what factors I must consider.
He told me a little about his experiences with the firm etc.
Tips: 1.It is important to dress up bright and early on the interview day.
2.Dress up well. It adds immensely to your confidence.
3.Make sure you appear energetic and excited about the job.

General Tips: RESUME: Start working on this early and keep making improvements by taking inputs from seniors/friends.
PREPARATION HELP:
1.Prepare typical HR questions.
2.Prepare your resume well.
3.Prepare cases. Brush up DI.
4.Do your groundwork on the firms interested in.
College Name: IIT BOMBAY

Credit Information Bureau Interview FAQs

How many rounds are there in Credit Information Bureau Data Analyst interview?
Credit Information Bureau interview process usually has 2 rounds. The most common rounds in the Credit Information Bureau interview process are Technical and HR.
What are the top questions asked in Credit Information Bureau Data Analyst interview?

Some of the top questions asked at the Credit Information Bureau Data Analyst interview -

  1. What is Vlookup and formula of...read more
  2. What is credit sc...read more
  3. What are window functions and asked to find out the highest salary from each de...read more

Tell us how to improve this page.

Credit Information Bureau Data Analyst Interview Process

based on 3 interviews

Interview experience

4.7
  
Excellent
View more
Credit Information Bureau Data Analyst Salary
based on 20 salaries
₹4.7 L/yr - ₹11.5 L/yr
At par with the average Data Analyst Salary in India
View more details

Credit Information Bureau Data Analyst Reviews and Ratings

based on 3 reviews

3.8/5

Rating in categories

3.4

Skill development

3.5

Work-life balance

3.7

Salary

3.7

Job security

4.1

Company culture

2.8

Promotions

3.4

Work satisfaction

Explore 3 Reviews and Ratings
Senior Manager
41 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
24 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Vice President
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Credit Information Bureau with

Experian

3.8
Compare

Equifax

3.3
Compare

Crif High Mark Credit Information Services

2.9
Compare

Nsdl Database Management

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