AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Credit Information Bureau Data Analyst Interview Questions and Answers
Credit Information Bureau Data Analyst Interview Experiences
1 interview found
Selected
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
(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...
(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
- 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...
- Q3. How many credit bureau's are there
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Data Analyst Interview Questions & Answers
Crif High Mark Credit Information Services
Anonymous
posted on 18 Sep 2024
Selected
I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.
(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...
- 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...
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2022. There were 2 interview rounds.
Improve your skills
Interview Preparation Tips
(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
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here
(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
I applied via Campus Placement and was interviewed in Nov 2022. There were 2 interview rounds.
(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
- 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
Interview Preparation Tips
- Python
- sql
- guest estimate
- machine learning
I applied via Campus Placement and was interviewed in Jan 2016. There were 6 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Questions on resume
- Q2. Small Case study ( statistics )
- Q3. Why analytics and goal in life
- Ans.
Analytics helps me make informed decisions and achieve my goals in life.
Analytics provides valuable insights and data-driven solutions to complex problems.
Setting goals helps me stay focused and motivated towards achieving personal and professional success.
By analyzing data and setting specific goals, I can track my progress and make necessary adjustments to reach my objectives.
For example, in my previous role as a mar...
Interview Preparation Tips
Experience: Dual Degree students with decent CPI, relevant projects and extras
Tips: Highlight subjects and projects involving data mining, machine learning, marketing research
Round: Test
Experience: PST had 26 questions to be done in an hour (3 cases) and 20 QUESTIONS in 30 mins general apti (level: 2-3 of Arun sharma)
Tips: practice!
Duration: 1 hour 30 minutes
Total Questions: 46
Round: Technical + HR Interview
Experience: Since my resume was filled with
College Name: IIT Kanpur
Interview Questionnaire
6 Questions
- Q1. CASE 1: A boiler manufacturer wants to go global, how should he go about doing it?
- Q2. Tell me about yourself
- Ans.
I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.
Experienced in data analysis and project management
Highly motivated and detail-oriented
Strong communication and problem-solving skills
Proficient in various analytical tools such as Excel, SQL, and Tableau
- Q3. Why consulting/business?
- Ans.
Consulting/business offers diverse challenges and opportunities to solve complex problems and drive impactful change.
Opportunity to work with a variety of clients and industries
Ability to solve complex problems and drive impactful change
Continuous learning and development
Exposure to different business models and strategies
Opportunity to work with talented and diverse teams
- Q4. Why don't you want to do research?
- Ans.
I never said I don't want to do research. In fact, research is an integral part of my job as a Business Analyst.
I never said I don't want to do research, I just want to clarify any misunderstandings.
Research is an essential part of my job as a Business Analyst.
I enjoy conducting research and analyzing data to provide valuable insights.
I believe that research is crucial in making informed decisions and driving business ...
- Q5. Don't you like aerospace?
- Ans.
Yes, I do like aerospace.
I find the advancements in aerospace technology fascinating.
I enjoy learning about the different types of aircraft and their capabilities.
I appreciate the importance of the aerospace industry in our economy and national security.
For example, I recently read about the successful test flight of SpaceX's Crew Dragon spacecraft and was impressed by the level of innovation and engineering involved.
- Q6. CASE 2: Some airline flies from Mango to NY. Should it shift to some other route?
- Ans.
It depends on various factors such as demand, competition, profitability, and operational feasibility.
Analyze the demand for the current route and potential demand for other routes
Evaluate the competition on the current route and other potential routes
Assess the profitability of the current route and potential routes
Consider the operational feasibility of shifting to another route
Examples of potential routes could be M
Interview Preparation Tips
Experience: CASE 1:
I started by trying to get the prerequisites of going global demand, type and size of market, capital, project differentiation, management, logistics. My major mistake was delving too much into depth.
CASE 2:
He asked how you increased revenues?
I said....Everything depends on the elasticity of demand. You might want to increase sales or increase prices and reduce sales. Then he said, we increase prices or demand and assume the other to be constant.
How do you increase prices?
I said you just quote a higher price. Then he said that there are different seats in an airplane. That kind of tinkering you can always do even if you want to keep the revenues same
Tips: 1.In the about yourself questions you can either give an overview of your resume or tell them something more general.
2.You will be asked about your biggest academic achievment.
3.Don't be so cool to the extent of being casual.
4.Don't prepare answers.
General Tips: 1.Attend PPTs and listen very carefully.
2.Be sure to find out what you will be doing in the company.
3.Don't try and squeeze too much in your resume.
Skill Tips: 1. For case studies thereis a lot of stuff on the LAN and on the internet.
2. It's better to do these in groups.
College Name: IIT BOMBAY
Interview Questionnaire
5 Questions
- Q1. CASE 1: Estimate the consumption of vodka in bombay
- Ans.
Estimate vodka consumption in Bombay.
Gather data on population demographics, alcohol consumption patterns, and sales data.
Use statistical analysis to estimate consumption based on available data.
Consider factors such as income levels, cultural attitudes towards alcohol, and availability of vodka.
Compare estimates to similar cities or regions for context.
Adjust estimates based on any unique factors specific to Bombay.
Co...
- Q2. Q1: Why consultancy?
- Ans.
Consultancy offers diverse opportunities to work with different clients and industries, and to constantly learn and grow as a professional.
Consultancy provides exposure to various industries and clients, allowing for a diverse range of experiences and challenges.
Working as a consultant requires constant learning and adaptation to new situations, which can be intellectually stimulating.
Consultancy offers the opportunity...
- Q3. Q2: What will you do if all consultants die one fine morning?
- Ans.
I would assess the impact on the project and identify alternative solutions.
Assess the impact of the loss of consultants on the project timeline and deliverables
Identify alternative solutions such as hiring new consultants, redistributing work among existing team members, or outsourcing work
Communicate with stakeholders and project sponsors to keep them informed of the situation and proposed solutions
- Q4. CASE 2: How to go about starting an airline
- Ans.
Starting an airline requires extensive planning, research, and investment.
Conduct market research to identify demand and competition
Develop a business plan including financial projections
Obtain necessary licenses and permits
Acquire or lease aircrafts and hire staff
Establish partnerships with suppliers and vendors
Implement marketing and advertising strategies
Ensure compliance with safety regulations and industry standar
- Q5. Why not research?
- Ans.
Research is important, but I am more interested in analyzing and solving business problems.
I enjoy working with data and finding insights to improve business processes
I am skilled in identifying patterns and trends in data
I prefer to focus on practical solutions rather than theoretical research
I believe my strengths lie in problem-solving and decision-making
For example, in my previous role as a business analyst, I anal...
Interview Preparation Tips
Experience: CASE 1:
I took a long time to do this one. The interviewer was not helpful and that slowed down my response. I had only discussed the consumption of vodka by women when she asked me to stop.
CASE 2:
There was no real case here. The interviewer wanted me to discuss how to go about starting an airline.He asked me to estimate the no. of passengers.
Round: HR Interview
Experience: 1. Questions regarding my projects and internships were asked.
2. A large part of the interview was devoted to "McKinsey vs its competition.
Skill Tips: 1.Attend PPTs of all the companies that you are interested in.
2.Don't exaggerate in your resume.
3.Case studies is a must for consultancies.
College Name: IIT BOMBAY
Interview Preparation Tips
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: 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: McKinsey interviews are mostly case study based. So prepare accordingly. Once you get shortlisted they send you a ton of material, search for a “Vault” case book amongst this pile. Reading that should be enough ;). First read the basic material by you and once you are confident enough make a group of around 3 people and practice case studies.
I guess this job opportunity meant a lot to all of us and it did to me too. I became nervous and that severely affected my performance and moreover I looked under confident. Take on every interview as if that job doesn't mean anything to you.
General Tips: Internship: (attention third year people!)
When it comes to the placement interview, internships play pivotal role. There are rarely any interviews where the interviewee isn't drilled on their internships. So, please don‟t treat an internship as a paid vacation. Good work done during the internship gives one the confidence that can very well bowl the interviewer over (as it did in my case :D). Believe me confidence does much more than get you a job; it determines success and failure in most
undertakings. Internship gives you the first chance to build that up … use it!
Pre Placement Talks:
Please attend the ppts of at least those companies which fall into your sector of interest. At ppts you get to see a lot more things than the boring presentations and the pay package. Most companies bring along with them alumni who have spent a few years in the company. Observing or interacting with them will give you a good assessment of what you are going to be a few years from now if you join that company. For example I observed that alumni of XYZ Company were not as upbeat and confident as alumni of ABC Company (names have
been hidden on request ;) ) even if XYZ was paying plenty more than ABC. I knew then and there that I would want to join ABC and never applied to XYZ. Be sure to utilize them and be sure to clear all your doubts and conceptions. Once you start attending presentations you will observe junta asking questions just to score brownie points with the speaker. Believe me it won't help one bit in landing them a job!
Resumes:
Making an appealing resume is the single most important step in the placement process and IITK is notorious for its bad resumes, so attend workshops. Like most IITK junta I sucked at making a resume (and still do), but whatever little skill I have, I got through workshops. One workshop I would advise everyone to attend is the resume making workshop of McKinsey. Get your resumes checked and edited by those who have been through placement especially by those from other IITs (I know this will hurt a lot of egos, but IITB's resumes are some of the best. Those dudes have mastered the art of making an impact with whatever little they've got, while we excel at doing exactly the opposite :P). Prepare an impactful resume and don't submit the same resume to every company, make changes based on the profile.
College Name: IIT KANPUR
Credit Information Bureau Interview FAQs
Recently Viewed
SALARIES
Bridgei2i Analytics Solutions
SALARIES
Deutsche Telekom Digital Labs
SALARIES
Impetus Technologies
SALARIES
Sigmoid
REVIEWS
Celebal Technologies
No Reviews
SALARIES
Bank of America
REVIEWS
Fractal Analytics
No Reviews
SALARIES
Sutherland Healthcare Solutions
SALARIES
Fractal Analytics
JOBS
Acuity Knowledge Partners
No Jobs
Tell us how to improve this page.
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
Credit Information Bureau Data Analyst Interview Process
based on 3 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Credit Information Bureau Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Manager
41
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Manager
29
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Vice President
23
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
19
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
18
salaries
| ₹0 L/yr - ₹0 L/yr |
Experian
Equifax
Crif High Mark Credit Information Services
Nsdl Database Management
- Home >
- Interviews >
- Credit Information Bureau Interview Questions >
- Credit Information Bureau Data Analyst Interview Questions
