American Express Product Development Analyst Interview Questions and Answers

Q1. Resume questions
Add your answer

It was good but prepared on technical basis

Q1. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: In a table of students, student ID can be a primary key
Answered by AI
Add your answer
Q2. What is foreign key
Ans. 
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
• A foreign key establishes a relationship between two tables in a database.

• It ensures referential integrity by enforcing a link between the data in the two tables.

• Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.

• Example: In a dat...read more
Answered by AI
Add your answer

Work / task prioritisation

Q1. About qualifications
Add your answer

Interview with people with different roles

Case study was regarding Banking sector

Q1. What are different type of payment files you worked on?
Ans. 
I have worked on various types of payment files including ACH, wire transfers, and credit card transactions.
• ACH (Automated Clearing House) files

• Wire transfer files

• Credit card transaction files
Answered by AI
Add your answer
Q2. What is the minimum response time?
Ans. 
The minimum response time is the shortest amount of time it takes for a system to respond to a request.
• The minimum response time can vary depending on the system and its capabilities.

• Factors that can affect the minimum response time include network latency, server load, and processing speed.

• For example, a high-performance website may have a minimum response time of 100 milliseconds, while a slower system may have a min
Answered by AI
Add your answer

5 sections - Quant, DI LR, English, Stats and Big fata coding

Q1. Based on Resume and past experience
Add your answer
Q2. Situation based question - how to risk profile credit card customers
Add your answer
Q3. Python based basic coding question
Add your answer

Q1. Resume based question
Add your answer
Q2. Questions about Machine Learning
Add your answer
Q3. Leadership questions
Add your answer

Q1. Job discussion, quality questions
Add your answer

GD with panel of 6 members

Auto lending case study and framework used

Q1. Pay related questions
Add your answer
Q2. How to ensure quality
Ans. 
Ensuring quality involves implementing strict quality control measures and continuous monitoring of production processes.
• Implementing quality control measures such as regular inspections and testing

• Training employees on quality standards and procedures

• Utilizing quality management systems to track and analyze production data

• Addressing any issues or defects promptly to prevent reoccurrence
Answered by AI
Add your answer

Panel of 6 members were present