Tcg Digital Solutions Consulting Analyst Interview Questions and Answers

On python and sql coding.they ask simple to complex questions

Q1. On data science machine learning
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. Introduce yourself and explain your carrier
Add your answer
Q2. B. Tech with 11 years of experience on Linux Administration/Devops/Ansible/Puppet/Cloud administration/ AWS/Openstack
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. 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

Q1. Finance questions - related to option pricing, derivatives, securities such as ABS, CLOs
Add your answer
Q2. Questions on hedge fund structure, ecosystem, hedge fund strategies
Add your answer
Q3. Why do you want to join IVP? Why not sell side core finance roles?
Add your answer

Q1. Math puzzles, Statistics, Probability problems
Add your answer
Q2. Do you have any technical experience? Data visualization and SQL based
Add your answer
Q3. Why do you want to join us?
Add your answer
Q4. What do you know about IVP and the exact nature of work we do?
Add your answer

Q1. What keeps you going everyday?
Add your answer
Q2. Why do you want to join IVP and what strengths will make you thrive here?
Add your answer