ICICI Securities Risk Management Executive Interview Questions and Answers

Q1. Introduction about yourself
Add your answer
Q2. Some technical questions
Add your answer

Q1. Different between vulnerability and risk
Ans. 
Vulnerability is a weakness in a system that can be exploited, while risk is the likelihood of a threat exploiting that vulnerability.
• Vulnerability is a flaw or weakness in a system that can be exploited by a threat.

• Risk is the likelihood of a threat exploiting that vulnerability and the potential impact of that exploitation.

• Vulnerability is inherent in the system, while risk is the combination of the likelihood and im...read more
Answered by AI
Add your answer
Q2. What is control monitoring
Ans. 
Control monitoring is the process of regularly checking and evaluating the effectiveness of controls put in place to manage risks.
• Regularly checking and evaluating controls

• Ensuring controls are effective in managing risks

• Identifying any gaps or weaknesses in controls

• Taking corrective actions to improve controls

• Examples: reviewing access logs to monitor unauthorized access, conducting periodic audits of financial contro
Answered by AI
Add your answer
Q3. Control and risk involved in your previous project or processes?
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced risk analyst with a background in finance and data analysis.
• Over 5 years of experience in analyzing financial risks and developing risk management strategies

• Proficient in statistical analysis and modeling using tools like Excel, SAS, and R

• Strong understanding of market trends and regulatory requirements

• Excellent communication skills and ability to present complex data to stakeholders

• Previously worked at XYZ...read more
Answered by AI
Add your answer

2 hirs 100 questions generic type

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

Q1. Tell me about yourself
Add your answer

It was mix of Quant, Reasoning, English and finance.

Topic was effect of covid on economy.

Q1. Basic python question from Geeks for Geeks.
Add your answer
Q2. Puzzle questions basic.
Add your answer

Q1. Resume read. About college projects. About languages like python and sql.
Add your answer
Q2. Why you want to join analytics.
Add your answer

Q1. Basic work related questions.
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?
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?
Add your answer
Q2. Explain a challenge that you solved?
Add your answer

Q1. How can concatenate in sql?
Ans. 
Concatenate in SQL is done using the CONCAT function or the + operator.
• Use the CONCAT function to concatenate strings in SQL, for example: SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees;

• Alternatively, you can use the + operator to concatenate strings, for example: SELECT first_name + ' ' + last_name AS full_name FROM employees;
Answered by AI
Add your answer