Barclays Investment Bank Senior Risk Analyst Interview Questions and Answers

Q1. 5 ways of initializing SAS Macro variables
Ans. 
There are multiple ways to initialize SAS Macro variables.
• Using the %LET statement

• Using the %GLOBAL statement

• Using the %SYSCALL macro function

• Using the %SYSFUNC macro function

• Using the %DO loop
Answered by AI
Add your answer
Q2. Difference between Merge and Sql Join
Ans. 
Merge is a function in pandas library used to combine two dataframes based on a common column, while SQL join is used to combine tables based on a specified condition.
• Merge is a function in pandas library, while SQL join is a clause in SQL.

• Merge combines two dataframes based on a common column, while SQL join combines tables based on a specified condition.

• Merge can perform inner, outer, left, and right joins, while SQL...read more
Answered by AI
Add your answer
Q3. 5 proc statements
Add your answer

There were 5 questions(3 video questions +2 coding questions)
First video question was to introduce yourself, second was to explain that why are we fit for that role in their company and third question was to explain the approach and logic in detail of the coding questions.
Coding questions involved topics like string and linked lists.
one should be well versed with data structures to clear coding round
Duration: 48 hours are given. anytime in these 48 hours one can give the test.

Q1. Introduction Questions on each and everything that was mentioned in my resume, from languages to projects that i have done. Long discussion on my projects. What is DBMS, Joins and types, SQL, 1-2 basic SQL...read more
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. Why should we hire you?
Add your answer
Q5. What is your family background?
Add your answer

Q1. Linux, Cloud, Shell related questions
Add your answer

Q1. Cloud Computing - AWS related questions
Add your answer

Q1. Linux Administration, CI/CD, Application Architecture related question
Add your answer

Q1. Past Projects, Attitude, Situation related questions
Add your answer

The one-hour coding test included multiple-choice questions on Java and MySQL, as well as two coding questions.

Q1. It was based on Binary Search, Find the target element in the shifted sorted array.
Add your answer
Q2. Comparator vs Comparable. Sort List of employee object using salary attribute
Ans. 
Comparator is used to define custom sorting logic, while Comparable is used to implement natural ordering. Sort list of employee objects by salary using Comparator.
• Create a Comparator implementation to compare employee objects based on salary attribute

• Use Collections.sort() method with the custom Comparator to sort the list of employee objects
Answered by AI
Add your answer

Q1. Basic OOps concepts.
Add your answer
Q2. Dasic DBMS
Add your answer

2 Easy Coding questions and 15 core java questions

Q1. Write function to calculate value of x to the power of n
Ans. 
Function to calculate x to the power of n
• Create a function that takes two parameters, x and n

• Use a loop to multiply x by itself n times

• Return the result
Answered by AI
Add your answer
Q2. Sliding window based array question
Add your answer

Q1. Intersection of Linked List
Ans. 
Intersection of two linked lists is finding the node where they merge.
• Traverse both lists to find their lengths and the difference in lengths

• Move the pointer of the longer list by the difference in lengths

• Traverse both lists in parallel until they intersect
Answered by AI
Add your answer
Q2. Questions related to multi threading
Add your answer

Q1. Basic hr questions
Add your answer

Be through with all DSA questions

Q1. Technical questions based on profile
Add your answer