Integra Global Solutions Senior Research Analyst Interview Questions and Answers

Q1. Write a query to obtain the third transaction of every user
Ans. 
Query to retrieve the third transaction of every user
• Use a subquery to rank the transactions for each user

• Filter the results to only include the third transaction for each user
Answered by AI
Add your answer
Q2. Write a query that outputs the name of the credit card and how many cards are issued in it's launch month
Ans. 
Query to output the name of credit card and number of cards issued in launch month
• Use GROUP BY to group by launch month

• Count the number of cards issued in each launch month

• Select the name of the credit card and the count of cards issued
Answered by AI
Add your answer

Q1. Not remember but related to SQL and ML
Add your answer
Q2. Related to SQL and ml
Add your answer

Q1. PowerApps and PowerBI related questions
Add your answer

Q1. High level scenerio based analytical questions
Add your answer

Q1. Basic ml qiestions
Add your answer

Q1. Ml related questions
Add your answer

Q1. How random forest decides the variables
Ans. 
Random forest decides variables based on feature importance and information gain.
• Random forest calculates feature importance by measuring how much the tree nodes that use a particular feature reduce impurity.

• Variables with higher feature importance are considered more important in making predictions.

• Random forest also uses information gain to decide which variables to split on at each node in the trees.

• The variables th...read more
Answered by AI
Add your answer
Q2. We need to use gini index for variable selection
Ans. 
Gini index is a measure of impurity used in decision trees for variable selection.
• Gini index ranges from 0 (pure node) to 0.5 (impure node)

• Variables with lower Gini index are preferred for splitting

• Higher Gini index indicates higher impurity and less predictive power
Answered by AI
Add your answer

Q1. SQL queries scenario based
Add your answer
Q2. Just gave schema and asked 5 questions.
Add your answer

Logical Reasoning, Comprehension

General discussion on current affairs

Q1. C++ coding questions
Add your answer