Onicra Credit Rating Agency Interview Questions and Answers

They will give a Assignment

Q1. Ask about the STock markets
Add your answer
Q2. Should be aware on OPTIONS Trading
Add your answer

Q1. Desing chatbot using 3rd party providers
Add your answer

Q1. Palindrome program, Basic python, SQL and oops Difference between delete, drop and truncate
Add your answer

Q1. Fibonacci sequence
Add your answer
Q2. Databricks cluster questions
Add your answer
Q3. Intermediate SQL questions from datalemur
Add your answer
Q4. Python questions from geeksforgeeks
Add your answer
Q5. ETL information
Add your answer

Q1. Code review, clean coding, design
Add your answer

Q1. Tell me something about yourself.
Add your answer
Q2. Why consulting after audit?
Add your answer
Q3. What do you know about Mastercard Advisory services?
Ans. 
Mastercard Advisory Services is a consulting arm of Mastercard that provides strategic advice and solutions to businesses.
• Offers customized solutions to clients based on their specific needs

• Helps businesses optimize their operations and improve their financial performance

• Provides expertise in areas such as digital transformation, risk management, and customer experience

• Works with clients across various industries inclu
Answered by AI
Add your answer
Q4. Why do you think you are good fit for Consulting?
Add your answer
Q5. Which other shortlists do you have?
Add your answer
Q6. A brief discussion about one of my projects related to GTM.
Add your answer

Calculate the number of table tennis balls that can be put inside an Indigo airplane.
[Please note that I stands for Interviewer and C stands for Candidate]

C: The number of balls that can be put inside a plane would be the =volume of the plane-30% (for the seats, equipment which are a part of the airplane)/ volume of the one TT ball.

I: Let us move forward with the approach only.

C: We can consider the middle portion of the plane to be a cylinder and the dimensions can be calculated assuming the number of rows to be 30. Assuming every row has distance of 1m distance between them which makes a 30m length adding another 5m for the cockpit area, we get a total length of 35m. An average person is of the height 2m. Hence the volume=3.14*2*2*35=400m^3.

An average table tennis ball is of a radius 2.5-3cm. The volume of one ball=4/3*3.14*3*3*3=113.04cm^3 which we convert back to my^3.

Your client is a card issuer. How can they increase their revenues?
[Please note that I stands for Interviewer and C stands for Candidate]

C: For the sake of the case can I assume the operations of the client to be like maybe say ICICI bank?

I: That's correct. But's lets only focus on increasing the profitability for the card’s revenue segment.

C: Alright! Profitability can be measured in terms of Revenues and Costs. According to my knowledge of the industry, revenue of the client would mostly be from the Gross Dollar value charged from customers, transaction or interchange fee, interest charged. And the costs are the costs of issuing, acquisition cost of the client, merchant fee paid.

Please let me know if I am missing out on anything as I am not fully aware about the payments industry.

I: That's understandable. We can move forward with these heads. How can we increase the profitability from the interest revenue?

C: Interest revenue are majorly charged when a consumer makes a purchase on the credit card. We can look into the EMI section as that is major source of this kind of an income. We can increase the EMI facilities in different products.