CreditMantri 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

Q1. SQL basics Python Basics Linux Basics
Add your answer
Q2. Questions on date and time and joins.
Add your answer

It was hackerrank test

30 minutes Aptitude test

1 Hour 30 minutes on SQL screening test

SQL and Python data analysis questions

Q1. How do you match the data in different columns.
Ans. 
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
• Use string matching techniques like exact match, partial match, or fuzzy matching.

• Apply data cleaning and preprocessing techniques to standardize the data before matching.

• Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

• Consider using database join...read more
Answered by AI
Add your answer

Q1. Basic to Advanced level of SQL
Add your answer
Q2. Discussed 1 -2 Business Cases studies
Add your answer

Q1. Questions about your experience
Add your answer
Q2. It will depend your experience
Add your answer

Math , gk, english

AI

Q1. Ai questions , java questions , coding questions
Add your answer

Q1. Where do you see yourself in 5 years
Add your answer