OpenXcell Technolabs MIS Executive Interview Questions and Answers

Q1. What is zero coupon bond?
Ans. 
A zero coupon bond is a bond that pays no interest and is sold at a discount to its face value.
• Zero coupon bonds are also known as discount bonds.

• Investors buy these bonds at a price lower than their face value and receive the full face value at maturity.

• The difference between the purchase price and the face value is the investor's return.

• Zero coupon bonds are often used for long-term investments, such as retirement sa...read more
Answered by AI
Add your answer
Q2. What is corporate actions and how you record those in books?
Ans. 
Corporate actions are events initiated by a company that can affect its stock price and shareholders. They are recorded in books through various accounting entries.
• Corporate actions include stock splits, dividends, mergers, acquisitions, and spin-offs.

• These actions are recorded in books through journal entries and adjustments to accounts such as retained earnings and stockholders' equity.

• For example, if a company decla...read more
Answered by AI
Add your answer

Q1. About my self and experience
Add your answer
Q2. About my hobbies
Add your answer

Q1. Document verify
Add your answer
Q2. Tel about my favorite topic
Ans. 
My favorite topic is artificial intelligence and its impact on society.
• AI has revolutionized various industries such as healthcare, finance, and transportation

• Ethical considerations surrounding AI development and deployment are crucial

• AI has the potential to both improve and disrupt society in significant ways
Answered by AI
Add your answer

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 languages do you know? Asked about the project I did and various clarification questions on that.
Add your answer
Q2. What are various assumption you made while implementing this project.
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. Previous year experience
Add your answer

Q1. Type of value added to the company
Ans. 
I add value to the company by leveraging my skills and experience to drive growth, improve efficiency, and enhance overall performance.
• Implementing cost-saving initiatives

• Developing innovative solutions to challenges

• Improving processes and workflows

• Increasing revenue through strategic partnerships

• Enhancing customer satisfaction and retention
Answered by AI
Add your answer

Q1. Tell about my self and experience
Add your answer

Q1. Telling about myself and my experience with my manager
Add your answer

Q1. Basic questions for finance
Add your answer
Q2. If you know everything from JD
Add your answer

Q1. Market capitalisation
Add your answer
Q2. Different type of swaps
Ans. 
Different types of swaps include interest rate swaps, currency swaps, and credit default swaps.
• Interest rate swaps involve exchanging fixed and floating interest rate payments.

• Currency swaps involve exchanging principal and interest payments in different currencies.

• Credit default swaps involve transferring the credit risk of a specific asset or entity.

• Other types of swaps include equity swaps, commodity swaps, and tota
Answered by AI
Add your answer