JPMorgan Chase & Co. Business Analyst Interview Questions, Process, and Tips

Q1. General questions on my experience. How did I keep myself updated.
Add your answer

Q1. What was my job role till now.
Add your answer
Q2. With regards to reconciliation in investment banking was asked to provide a scenario whether did investigation and how was it resolved.
Add your answer

Q1. Explain previous experience and further questions based on this
Add your answer

Q1. Question related to your overall experience in the IT field.
Add your answer

Q1. Behavioral type. Looking for answers on how you will fit with the group.
Add your answer

Database and Java basic questions were asked

Q1. Joins and its types. Purpose of Joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN...read more
Answered by AI
Add your answer
Q2. What is deadlock
Ans. 
Deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.
• Occurs in multitasking environments

• Can happen in database systems when two transactions are waiting for each other to release locks

• Can be resolved using techniques like deadlock detection and prevention
Answered by AI
Add your answer

Q1. SQL questions standard interview qs
Add your answer
Q2. Tables update insert
Add your answer
Q3. SSIS, SSRS structure
Add your answer

Q1. Why do you want to join the company
Add your answer
Q2. Do you see yourself working long term in the company
Add your answer