Northern Trust Operating Services Risk Analyst Interview Questions and Answers

2 hirs 100 questions generic type

Q1. Sql ques, guessstimates
Add your answer
Q2. Joins, vlookup and sql
Add your answer

Q1. Basic resume related questions and about the JD
Add your answer

Q1. Technical round related to the skill sets.
Add your answer

Q1. Behavioral questions
Add your answer

Q1. Powerbi visuals and use case
Add your answer

Q1. Q about resume mostly
Add your answer
Q2. Generic finance qs
Add your answer

Q1. Managerial and hr qs
Add your answer
Q2. Situational questions
Add your answer

Q1. Exact i wont remember but its related to risk part of banking
Add your answer

Q1. What is difference between join and merge?
Ans. 
Join is used in SQL to combine rows from two or more tables based on a related column, while merge is used in data manipulation tools like pandas to combine data frames based on common columns.
• Join is typically used in SQL queries to combine rows from two or more tables based on a related column

• Merge is used in data manipulation tools like pandas to combine data frames based on common columns

• Join can be inner, outer, l...read more
Answered by AI
Add your answer
Q2. What is left join?
Ans. 
Left join is a type of join operation in SQL that returns all rows from the left table and the matched rows from the right table.
• Left join combines rows from two tables based on a related column between them.

• If there is no match for a row in the right table, NULL values are used for the columns from the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer

Q1. Why do you want to move to Citi?
Ans. 
I want to move to Citi because of its reputation for innovation and global presence.
• Citi is known for its cutting-edge technology and data analytics, which aligns with my skills and interests.

• I am excited about the opportunity to work in a diverse and dynamic environment at Citi.

• Citi's global presence offers the chance to work on a wide range of projects and collaborate with colleagues from around the world.
Answered by AI
Add your answer
Q2. What is expected CTC?
Ans. 
Expected CTC is negotiable based on candidate's experience, skills, and the company's budget.
• Expected CTC depends on the candidate's level of experience and skills.

• It also depends on the company's budget and industry standards.

• Negotiation is common during the offer stage to reach a mutually agreeable CTC.

• Candidates can research average salaries for similar roles to have an idea of what to expect.
Answered by AI
Add your answer

Q1. What challenges did you overcome in your last company?
Ans. 
I overcame challenges related to data accuracy and communication in my previous company.
• Implemented new data validation processes to improve accuracy

• Improved communication between departments to streamline workflow

• Resolved discrepancies in risk assessment reports through thorough analysis
Answered by AI
Add your answer
Q2. Explain a challenge that you solved?
Ans. 
I successfully implemented a new risk assessment model for a financial institution.
• Identified limitations of current risk assessment model

• Researched and analyzed alternative models

• Collaborated with team to implement and test new model

• Monitored and adjusted model based on feedback and results
Answered by AI
Add your answer

Q1. BAsic resume based questions
Add your answer
Q2. SQL, C++ basics, PowerBi, Puzzle
Add your answer

Q1. SQL questions medium-level,
Add your answer
Q2. Managerial Questions, Puzzle
Add your answer

Q1. Questions related to the inherent risk in products like bonds, structured products, etc.
Add your answer