Crif High Mark Credit Information Services Data Analyst Interview Questions and Answers

Q1. What are window functions and asked to find out the highest salary from each department.
Add your answer
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...read more
Answered by AI
Add your answer

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
Add your answer
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...read more
Answered by AI
Add your answer
Q3. How many credit bureau's are there
Add your answer

Improve your skills

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
Add your answer
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
Add your answer

Q1. Intro about ratings
Add your answer
Q2. Intro with CBO, basic questing regarding the company
Add your answer

Q1. Was good and putting this as high level
Add your answer
Q2. Na but still gvnfgnxvbb
Add your answer
Q3. Bvdgjhfbjgrghgcfvbhgfgv
Add your answer

Ratio Analysis and general awareness about the economy

Q1. General economy trend and ratios
Add your answer

Basic aptitude questions of quant and reasoning and general english

Case study of varies products asked around 15-20 which were easy to attempt

Q1. About yourself, practical knowledge, family, data related,etc.
Add your answer
Q2. What is sql. Excel formulas
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
• SQL is used to retrieve, insert, update, and delete data from databases.

• Excel formulas are written using functions and operators to perform calculations and manipulate data.

• SQL example: SELECT * FROM customers WHERE age > 30;

• Excel formula example...read more
Answered by AI
Add your answer

Normal aptitude questions

Q1. Interview with manager
Add your answer