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

General finance and logical reasoning

Q1. Basics of finance and accounting
Add your answer
Q2. About previous experience and why do you wish to switch
Add your answer

Aptitude test , finance questions, written test

GD topic related to economy etc

Q1. Resume based questions
Add your answer

Q1. Basic questions related to location etc
Add your answer

Q1. SQL joins were asked
Add your answer
Q2. SAS Macros were asked
Add your answer

Q1. What is disadvantages of vlookup
Ans. 
VLOOKUP has limitations such as only searching for values in the leftmost column and being case-sensitive.
• VLOOKUP only searches for values in the leftmost column of a table

• It is case-sensitive, so if the lookup value has a different case than the table, it won't find a match

• It can only return one value, so if there are multiple matches, it will only return the first one

• It can be slow and resource-intensive for large da
Answered by AI
View 1 more answer
Q2. How do you prepare before an assignment
Ans. 
Preparing for an assignment involves research, planning, and organizing.
• Research the topic or subject of the assignment

• Gather relevant information and data

• Create a plan or outline for the assignment

• Organize resources and materials needed

• Set goals and deadlines

• Allocate time for each task

• Review and revise as necessary
Answered by AI
Add your answer
Q3. Why do you want to join jpmc
Ans. 
I want to join JPMC because of its reputation, global presence, and opportunities for growth.
• JPMC has a strong reputation in the financial industry, which would enhance my professional profile.

• JPMC is a global organization, providing opportunities to work with diverse teams and gain international exposure.

• JPMC offers excellent career growth prospects and a supportive work environment.

• JPMC's commitment to innovation and...read more
Answered by AI
Add your answer
Q4. Walk me through job description
Ans. 
The job description for an Analyst involves analyzing data, identifying trends, and providing insights to support decision-making.
• Analyze data from various sources

• Identify trends and patterns

• Create reports and presentations to communicate findings

• Collaborate with stakeholders to understand business needs

• Use statistical and analytical tools

• Provide insights and recommendations to support decision-making
Answered by AI
Add your answer
Q5. Walk me through your Cv
Ans. 
I have a diverse background in data analysis and have worked on various projects in different industries.
• Bachelor's degree in Statistics

• Internship at a financial institution, where I analyzed market trends and created reports

• Worked as a data analyst at a healthcare company, where I developed predictive models to improve patient outcomes

• Experience in using statistical software such as R and Python

• Strong analytical and p
Answered by AI
Add your answer

Q1. Given an array find the range with maximum sum
Ans. 
Find the range with maximum sum in an array of strings
• Iterate through the array and calculate the sum of each range

• Keep track of the maximum sum and corresponding range

• Return the range with maximum sum
Answered by AI
Add your answer
Q2. Explain data mining
Ans. 
Data mining is the process of analyzing large datasets to discover patterns, trends, and insights.
• Data mining involves extracting useful information from large datasets

• It uses various techniques such as machine learning, statistics, and database systems

• Examples include market basket analysis, customer segmentation, and fraud detection
Answered by AI
Add your answer
Q3. A few questions on queries
Add your answer

Q1. Why you want to join this organisation
Add your answer