Crisil Consultant Interview Questions and Answers

There were 3 rounds for data science consultant position at Equifax. 1st round consists of Python and SQL questions and also in this round they have tested analytical thinking as well.

In 2nd round they have asked me questions from my resume and asked me to explain the projects which I have worked on in previous company. In this round they have asked me pandas related questions and asked me write code.

Q1. In Managerial round again here I have been asked questions related my projects. and no coding round in this stage.
Add your answer

Q1. What is Tuples? How do you convert a string to a tuple?
Ans. 
Tuples are immutable sequences of elements. A string can be converted to a tuple using the tuple() function.
• Tuples are similar to lists but are immutable

• Elements of a tuple are enclosed in parentheses ()

• A string can be converted to a tuple using the tuple() function

• Each character in the string becomes an element in the tuple
Answered by AI
Add your answer
Q2. What is Left Join? Show one Left join for 2 data frames on Python
Ans. 
Left join is a type of join operation in SQL that returns all the rows from the left table and matching rows from the right table.
• Left join is performed using the 'left join' keyword in SQL

• In Python, left join can be performed using the 'merge' function from the pandas library

• Syntax: pd.merge(left_dataframe, right_dataframe, how='left', on='key_column')

• Example: pd.merge(df1, df2, how='left', on='id')
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. Market analysis? Ratios
Add your answer
Q2. Market? Ratios Analysis
Add your answer
Q3. Personal questions
Add your answer

Q1. Recent economic updates, past work experience, banking ratios calculation,
Add your answer

Financial ratios related to profit and loss statement and balance sheet

Q1. Which debt coverage ratios will you consider for analyzing the company
Ans. 
The debt coverage ratios that I would consider for analyzing a company are the debt service coverage ratio (DSCR) and the interest coverage ratio (ICR).
• Debt service coverage ratio (DSCR) measures a company's ability to cover its debt obligations. It is calculated by dividing the company's operating income by its total debt service.

• Interest coverage ratio (ICR) measures a company's ability to cover its interest expenses...read more
Answered by AI
Add your answer

Q1. Why CARE, about previous experience
Add your answer

Ratios, quantitative aptitude, GK

Q1. Ratios, important ratios to consider before giving a loan.
Ans. 
Key ratios to consider before giving a loan include debt-to-income ratio, loan-to-value ratio, and credit score.
• Debt-to-Income Ratio: This ratio compares a borrower's monthly debt payments to their gross monthly income. A lower ratio indicates a borrower is less risky.

• Loan-to-Value Ratio: This ratio compares the loan amount to the appraised value of the collateral. A lower ratio indicates a lower risk for the lender.

• Cr...read more
Answered by AI
Add your answer