JPMorgan Chase & Co. Business Analytics Associate Interview Questions and Answers

Q1. 1. Macro quoting functions in SAS 2. ways to create macro variable in Data step 3. date functions-intck() and intnx() 4.situational scenario based questions 5.Automatic variables in SAS
Ans. 
The interview questions cover topics such as macro quoting functions, creating macro variables, date functions, situational scenario-based questions, and automatic variables in SAS.
• Macro quoting functions in SAS allow for the creation of macro variables with special characters.

• Macro variables can be created in the data step using the %LET statement or by using the CALL SYMPUTX routine.

• The date functions INTCK() and INT...read more
Answered by AI
Add your answer

Medium difficulty level. Good to go prepared with basics.

Q1. Resume based questions like what and how did you do this
Add your answer
Q2. Banking knowledge check like how bank works, different banking products etc
Add your answer

Q1. SQL hard questions
Add your answer

Q1. Question related to BFSI - mostly from resume, collection startegy, Sas, project handling
Add your answer

Q1. Case studies related to collection, segmentation, market based questions in contact strategy
Add your answer

Q1. Since this was management position leader was focussing questions on leadership experienced areas networking etc
Add your answer

Q1. Two US folks interviewed me .Both are in senior leadership positions. it was mix of technical and mgmnt
Add your answer

Q1. Logistic regression, modeling experience, choosing best model, SQL.. Find the third transaction of customer from dataset
Add your answer

Q1. What projects I worked before
Add your answer
Q2. Behavioural questions
Add your answer

Q1. What is the meaning of Data Aggregation?
Ans. 
Data aggregation refers to the process of combining and summarizing data from multiple sources into a single dataset.
• Data aggregation involves collecting and merging data from various sources.

• It aims to provide a consolidated view of the data for analysis and reporting.

• Aggregated data is typically summarized using statistical functions like sum, average, count, etc.

• Examples of data aggregation include calculating total...read more
Answered by AI
View 1 more amswer
Q2. Delete duplicate Records in SQL
Ans. 
To delete duplicate records in SQL, use the DELETE statement with a subquery to identify and remove the duplicates.
• Use the GROUP BY clause to group the records by the columns that define duplicates.

• Use the HAVING clause to filter the groups and keep only the duplicates.

• Use the DELETE statement with a subquery to delete the duplicate records.
Answered by AI
View 1 more amswer
Q3. What are the different types of Join used in SQL?
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and the matching rows from the right table

• Right join returns all rows from the right table and the matching rows from the left table

• Full outer join returns all rows from both tables, including unmatched rows
Answered by AI
View 2 more amswers
Q4. What is subquary ? Why it is required ?
Ans. 
Subquery is a query within another query. It is required to retrieve data from multiple tables or to perform complex calculations.
• Subquery is enclosed within parentheses and is executed first before the main query.

• It can be used in SELECT, FROM, WHERE, and HAVING clauses.

• Subquery can be correlated or non-correlated.

• Examples of subquery include finding the maximum or minimum value in a table, filtering data based on a c
Answered by AI
Add your answer
Q5. What is the meaning of Trigger in Python?
Ans. 
A trigger in Python is an event that causes a specific function or code to execute.
• Triggers can be used to automate tasks or respond to specific events.

• They are often used in web development to execute code when a user interacts with a webpage.

• Triggers can also be used in databases to execute code when certain data is inserted, updated, or deleted.

• Examples of triggers in Python include mouse clicks, keyboard inputs, an
Answered by AI
Add your answer
Q6. Componets of Tableau ? What are the different connection is there in Tableau ?
Ans. 
Tableau components include Desktop, Server, Prep, Online, Public. Different connections include live, extract, ODBC, cloud, etc.
• Tableau components: Desktop, Server, Prep, Online, Public

• Different connections: Live, Extract, ODBC, Cloud, etc.

• Live connection: Directly connects to the data source and updates in real-time

• Extract connection: Data is extracted and stored in Tableau's proprietary format for faster performance

• O...read more
Answered by AI
Add your answer
Q7. Find out Top 5 highest paid Employees ?
Ans. 
Top 5 highest paid employees are identified based on their salary.
• Identify all employees and their salaries

• Sort the employees based on their salary in descending order

• Select the top 5 employees with the highest salary
Answered by AI
Add your answer