American Express
100+ Salesforce Interview Questions and Answers
Q1. Sliding Window Maximum Problem Statement
You are given an array/list of integers with length 'N'. A sliding window of size 'K' moves from the start to the end of the array. For each of the 'N'-'K'+1 possible wi...read more
The problem involves finding the maximum element in each sliding window of size 'K' in an array of integers.
Iterate through the array and maintain a deque to store the indices of elements in the current window.
Remove indices from the deque that are outside the current window.
Keep the deque in decreasing order of element values to easily find the maximum element in each window.
Q2. Unique Frequency Problem Statement
Given a string 'STR' with lowercase letters, determine the minimum number of deletions required to ensure that every letter in the string appears a unique number of times.
Exa...read more
The task is to find the minimum number of deletions needed in a string to ensure each character appears a unique number of times.
Iterate through the string and count the frequency of each character
Track the frequencies in a hashmap
Identify the characters with duplicate frequencies and calculate the minimum deletions needed
Return the minimum number of deletions for each test case
Q3. Maximum Non-Adjacent Subsequence Sum
Given an array of integers, determine the maximum sum of a subsequence without choosing adjacent elements in the original array.
Input:
The first line consists of an integer...read more
Find the maximum sum of a subsequence without choosing adjacent elements in an array.
Use dynamic programming to keep track of the maximum sum at each index, considering whether to include or exclude the current element.
At each index, the maximum sum can be either the sum of the current element and the element two positions back, or the sum at the previous index.
Iterate through the array and update the maximum sum accordingly.
Example: For input [3, 2, 7, 10], the maximum non-a...read more
Q4. Reach the Destination Problem Statement
You are given a source point (sx, sy) and a destination point (dx, dy). Determine if it is possible to reach the destination point using only the following valid moves:
- ...read more
Determine if it is possible to reach the destination point from the source point using specified moves.
Use depth-first search (DFS) to explore all possible paths from source to destination.
Keep track of visited points to avoid infinite loops.
Check if the destination point is reachable by following the valid moves.
Return true if destination is reachable, false otherwise.
Q5. Word Break Problem Statement
You are given a list of N
strings called A
. Your task is to determine whether you can form a given target string by combining one or more strings from A
.
The strings from A
can be u...read more
Given a list of strings, determine if a target string can be formed by combining one or more strings from the list.
Iterate through all possible combinations of strings from the list to form the target string.
Use recursion to try different combinations of strings.
Check if the current combination forms the target string.
Return true if a valid combination is found, otherwise return false.
Q6. Number of Islands Problem Statement
You are provided with a 2-dimensional matrix having N
rows and M
columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in this ma...read more
Count the number of islands in a 2D matrix of 1s and 0s.
Use Depth First Search (DFS) or Breadth First Search (BFS) to traverse the matrix and identify connected groups of 1s.
Maintain a visited array to keep track of visited cells to avoid revisiting them.
Increment the island count each time a new island is encountered.
Consider all eight possible directions for connectivity between cells.
Handle edge cases like out of bounds indices and water cells (0s).
Q7. Longest Switching Subarray Problem Statement
Determine the length of the longest contiguous subarray in a given array of positive integers, where the subarray qualifies as 'switching'. An array is defined as sw...read more
Find the length of the longest switching subarray in a given array of positive integers.
Iterate through the array and keep track of the longest switching subarray found so far.
Check if the numbers at even and odd positions are identical to determine a switching subarray.
Return the length of the longest switching subarray.
Example: For input [1, 4, 1, 4, 3, 2, 3, 0], the longest switching subarray is [1, 4, 1, 4] with length 4.
Q8. All Paths From Source Lead To Destination Problem Statement
In a directed graph with 'N' nodes numbered from 0 to N-1, determine whether every possible path starting from a given source node (SRC) eventually le...read more
Determine if all paths from a source node lead to a destination node in a directed graph.
Check if there is at least one path from source to destination.
If a node has no outgoing edges, it should be the destination.
Ensure the number of paths from source to destination is finite.
Traverse the graph to validate all paths lead to the destination.
Q9. Find All Anagrams Problem Statement
Given a string STR and a non-empty string PTR, identify all the starting indices of anagrams of PTR within STR.
Explanation:
An anagram of a string is another string that can...read more
Given a string STR and a non-empty string PTR, find all starting indices of anagrams of PTR within STR.
Create a frequency map of characters in PTR.
Use sliding window technique to check anagrams in STR.
Return the starting indices of anagrams found.
Q10. What would happen to AMEX's income if petrol and diesel prices decrease?
If petrol and diesel prices decrease, AMEX's income may decrease due to reduced fuel surcharges and lower transaction volumes.
AMEX earns revenue through fuel surcharges on transactions made using their cards.
Lower petrol and diesel prices may lead to reduced fuel surcharges, resulting in a decrease in AMEX's income.
Decreased fuel prices may also impact consumer spending habits, leading to lower transaction volumes and further impacting AMEX's income.
However, if lower fuel pri...read more
Q11. Palindrome Linked List Detection
Given a singly linked list of integers, determine if it is a palindrome. A linked list is considered a palindrome if it reads the same forward and backward.
Example:
Input:
The ...read more
Check if a singly linked list is a palindrome by comparing elements from both ends.
Traverse the linked list to find the middle point
Reverse the second half of the linked list
Compare the first half with the reversed second half to check for palindrome
Example: Input: 1 2 3 2 1 -1, Output: true
Q12. Travelling Salesman Problem
Given a list of cities numbered from 0 to N-1 and a matrix DISTANCE
consisting of 'N' rows and 'N' columns, representing the distances between each pair of cities, find the shortest ...read more
Q13. What is the difference between customer service and customer Support ?
Customer service focuses on providing assistance and guidance to customers, while customer support focuses on resolving specific issues or problems.
Customer service involves helping customers with general inquiries, providing information, and offering solutions to their problems.
Customer support is more specialized and involves addressing specific issues or problems that customers may encounter.
Customer service is proactive and focuses on building relationships with customers...read more
Q14. Sliding Maximum Problem Statement
Given an array of integers ARR
of length 'N' and a positive integer 'K', find the maximum elements for each contiguous subarray of size K.
Example:
Input:
ARR = [3, 4, -1, 1, 5...read more
Implement a function to find maximum elements for each contiguous subarray of size K in an array of integers.
Iterate through the array and maintain a deque to store the indices of elements in decreasing order.
Pop elements from the deque that are out of the current window and add the maximum element to the result array.
Return the result array containing maximum elements for each subarray of size K.
Q15. Longest Substring with At Most K Distinct Characters
Given a string S
of length N
and an integer K
, find the length of the longest substring that contains at most K
distinct characters.
Input:
The first line co...read more
Find the length of the longest substring with at most K distinct characters in a given string.
Use a sliding window approach to keep track of the characters and their counts in the substring.
Maintain a hashmap to store the characters and their frequencies within the window.
Update the window size and characters count as you iterate through the string.
Keep track of the longest substring length with at most K distinct characters.
Return the length of the longest substring for each...read more
Explaining a complex joins problem in DBMS
Discussing the use of different types of joins like inner join, outer join, self join, etc.
Explaining how to handle null values and duplicates during joins
Demonstrating a scenario where multiple tables need to be joined based on different keys
Q17. Interval List Intersection Problem
You are provided with two sorted lists of closed intervals, INTERVAL1
and INTERVAL2
. A closed interval [x, y] (x < y) signifies the set of real numbers z such that x <= z <= y...read more
Find the intersections of two sorted lists of closed intervals.
Iterate through both interval lists to find intersections
Compare the intervals and find the common range
Handle cases where there is no intersection between intervals
Q18. Ninja And The Tree Problem Statement
Ninja, while learning Binary Search Trees (BST), accidentally swapped two nodes in her self-constructed BST. Your task is to help Ninja by correcting the BST so that all pro...read more
The task is to correct a Binary Search Tree by swapping two nodes in the tree.
Parse the input level order tree and construct the BST
Identify the two nodes that are swapped incorrectly
Swap the values of the incorrectly swapped nodes to correct the BST
Return the corrected BST in level order form
Q19. Buy and Sell Stock Problem Statement
Imagine you are Harshad Mehta's friend, and you have been given the stock prices of a particular company for the next 'N' days. You can perform up to two buy-and-sell transa...read more
The task is to determine the maximum profit that can be achieved by performing up to two buy-and-sell transactions on a given set of stock prices.
Iterate through the array of stock prices to find the maximum profit that can be achieved by buying and selling stocks at different points.
Keep track of the maximum profit that can be achieved by considering all possible combinations of buy and sell transactions.
Ensure that you sell the stock before buying again to adhere to the con...read more
Q20. Count Pairs with Given Sum
Given an integer array/list arr
and an integer 'Sum', determine the total number of unique pairs in the array whose elements sum up to the given 'Sum'.
Input:
The first line contains ...read more
Count the total number of unique pairs in an array whose elements sum up to a given value.
Use a hashmap to store the frequency of each element in the array.
Iterate through the array and for each element, check if (Sum - current element) exists in the hashmap.
Increment the count of pairs if the complement exists in the hashmap.
Divide the count by 2 to avoid counting duplicates like (arr[i], arr[j]) and (arr[j], arr[i]) separately.
Q21. Stack using Two Queues Problem Statement
Develop a Stack Data Structure to store integer values using two Queues internally.
Your stack implementation should provide these public functions:
Explanation:
1. Cons...read more
Implement a stack using two queues to store integer values with specified functions.
Use two queues to simulate stack operations efficiently.
Maintain one queue for storing elements and another for temporary storage during push operation.
Ensure proper handling of edge cases like empty stack or invalid operations.
Example: Push operation involves transferring elements from one queue to another before adding the new element.
Example: Pop operation removes and returns the top elemen...read more
Q22. Maximum Sum With Specific Difference Problem Statement
Given an array of integers and a number 'K', your task is to find the maximum possible sum of disjoint pairs of numbers where the absolute difference betwe...read more
Find maximum sum of disjoint pairs with absolute difference less than K in an array.
Iterate through the array and sort it.
Find all possible disjoint pairs with absolute difference less than K.
Calculate the sum of these pairs to get the maximum sum.
Q23. Detect and Remove Loop in Linked List
For a given singly linked list, identify if a loop exists and remove it, adjusting the linked list in place. Return the modified linked list.
Expected Complexity:
Aim for a...read more
Detect and remove loop in a singly linked list in place with O(n) time complexity and O(1) space complexity.
Use Floyd's Cycle Detection Algorithm to identify the loop in the linked list.
Once the loop is detected, use two pointers to find the start of the loop.
Adjust the pointers to remove the loop and return the modified linked list.
Q24. Minimum Number of Swaps to Sort an Array
Find the minimum number of swaps required to sort a given array of distinct elements in ascending order.
Input:
T (number of test cases)
For each test case:
N (size of the...read more
The minimum number of swaps required to sort a given array of distinct elements in ascending order.
Use a graph-based approach to find cycles in the array
Count the number of swaps needed to fix each cycle
Sum up the swaps needed for all cycles to get the total minimum swaps
Q25. What does fraud mean if you have to explain to explain it to a 12-year kid
Fraud is when someone tricks or deceives others to steal their money or personal information.
Fraud is a type of dishonest behavior where someone tries to take advantage of others for their own gain.
It involves tricking or deceiving people to steal their money, personal information, or belongings.
Fraud can happen in different ways, such as online scams, identity theft, or fake products.
For example, if someone pretends to be a bank representative and asks for your credit card d...read more
Q26. Circular Move Problem Statement
You have a robot currently positioned at the origin (0, 0) on a two-dimensional grid, facing the north direction. You are given a sequence of moves in the form of a string of len...read more
Determine if a robot's movement path is circular on a 2D grid based on a given sequence of moves.
Iterate through the sequence of moves and keep track of the robot's position and direction.
Check if the robot returns to the starting position after completing the moves.
Use a counter-clockwise rotation (L) and clockwise rotation (R) to update the direction of the robot.
Use 'G' to move the robot one unit in the current direction.
Q27. Puzzles- A deck of cards (52 cards) with 4 aces. How many cards do you need to flip on an average to get the first ace?
On average, you need to flip 13 cards to get the first ace from a deck of 52 cards with 4 aces.
The probability of getting an ace in one flip is 4/52 or 1/13.
The probability of not getting an ace in one flip is 48/52 or 12/13.
Using the formula for geometric distribution, the expected number of flips to get the first ace is 1/(1/13) = 13.
Q28. What data would you collect from costumers to improve the sales of your super market?
To improve sales, we would collect data on customer preferences, demographics, and shopping habits.
Collect data on customer preferences for products, brands, and packaging
Gather demographic information such as age, gender, income, and location
Track shopping habits like frequency of visits, time of day, and purchase history
Use surveys, loyalty programs, and social media to gather data
Analyze data to identify trends and make informed decisions on product offerings and marketing...read more
Q29. In a desert you have infinite fuel stocked at a place, and you have a car which gives 1 mile per litre., desert is 100 miles long, and car can hold 20 litres, how to reach the end in most optimized way.
Drive 60 miles, refill, and repeat until the end of the desert.
Drive 60 miles, which will use 60 litres of fuel
Refill the car with 20 litres of fuel
Repeat until the end of the desert is reached
Q30. 1. Why amex 2. what is closed loop model of amex 3. What are the factors that you look into for setting the credit limit of a customer. Give an optimization equation 4. Give an instance of when you have worked...
read moreAnswers to questions asked in an interview for Management Trainee at Amex
1. Amex is a reputed financial services company with a strong focus on customer service and innovation.
2. Closed loop model of Amex refers to the fact that Amex issues its own cards, processes transactions, and provides customer service, all within its own network.
3. Factors for setting credit limit include credit score, income, debt-to-income ratio, and payment history. Optimization equation: Credit Lim...read more
Q31. a+b = 10, a+b+c = 10, a+b+c+d = 10. Total number of Possible combinations in the same order was asked
Find the total number of possible combinations in the given order.
The value of a+b is 10, so a and b can be any two numbers that add up to 10.
The value of a+b+c is also 10, so c can be any number that makes the sum of a, b, and c equal to 10.
Similarly, the value of a+b+c+d is 10, so d can be any number that makes the sum of a, b, c, and d equal to 10.
To find the total number of possible combinations, we need to consider all the possible values of a, b, c, and d that satisfy t...read more
Q32. Left View of a Binary Tree Problem Statement
Given a binary tree, your task is to print the left view of the tree.
Example:
Input:
The input will be in level order form, with node values separated by a space. U...read more
Print the left view of a binary tree given in level order form.
Traverse the tree level by level and print the first node encountered at each level
Use a queue to perform level order traversal
Keep track of the current level and the maximum level seen so far
Q33. How many airplanes take off from the Delhi airport each day?
The number of airplanes taking off from Delhi airport daily is not available.
The exact number of airplanes taking off from Delhi airport each day is not publicly available.
The number of flights can vary depending on the day of the week and time of day.
Factors such as weather conditions and air traffic can also affect the number of flights.
However, Delhi airport is one of the busiest airports in India and handles a large number of domestic and international flights.
In 2019, th...read more
Q34. What do you mean by fraud risk and how will identify a fraud in which a person steals your customer’s credit card?
Fraud risk refers to the potential for fraudulent activities to occur. Identifying credit card fraud involves monitoring transactions and detecting suspicious patterns.
Fraud risk is the possibility of fraudulent activities happening, such as unauthorized use of credit cards.
To identify credit card fraud, monitor transactions for any suspicious or unusual activity.
Look for patterns like multiple transactions from different locations or large purchases that are inconsistent wit...read more
Q35. In a deck of 52 cards, there are four aces. If you are picking one card after the other, at what position the first Ace card will appear in the long run?
The first Ace card will appear, on average, at the 13th position.
The probability of drawing an Ace card in a single draw is 4/52.
The probability of not drawing an Ace card in a single draw is 48/52.
The probability of not drawing an Ace card in the first 12 draws is (48/52)^12.
Therefore, the probability of drawing an Ace card for the first time on the 13th draw is 1 - (48/52)^12.
Q36. So now you have come up with the supply of autorickshaws. Now tell me what is the actual demand of these autorickshaws and see if the number is matching with supply or not. Had it been a different product, what...
read moreTo determine if supply of autorickshaws matches demand, we need to conduct market research and analyze data. Approach for a different product would depend on the nature of the product.
Conduct market research to determine the demand for autorickshaws
Analyze data to compare demand with supply
If demand is higher than supply, increase production or import more autorickshaws
If demand is lower than supply, decrease production or find new markets to sell autorickshaws
Approach for a ...read more
Q37. How would you analyse his internet surfing history to plan what type of card should be given to him? Suggest some promotions that can be offered to customer
Analysing internet surfing history to plan card type and promotions for customer.
Analyse the customer's search history for keywords related to shopping, travel, dining, etc.
Identify the customer's spending patterns and preferences based on their browsing history.
Offer promotions and discounts on products or services that the customer has shown interest in.
Suggest a credit card with rewards and benefits that align with the customer's interests and spending habits.
Consider the ...read more
Q38. What do you know about credit card and how it works?
Credit card is a payment card issued to users as a method of payment.
Credit cards allow users to borrow money up to a certain limit to make purchases.
Users are required to pay back the borrowed amount along with interest and fees.
Credit cards offer rewards and cashback programs to incentivize usage.
Credit card companies charge merchants a fee for accepting payments through their network.
Credit card fraud is a common issue and users should take precautions to protect their inf...read more
Q39. A person is described. He comes and asks for credit card. How do you decide to give him a credit card?
The decision to give a person a credit card is based on their creditworthiness and ability to repay the credit.
Evaluate the person's credit history and credit score.
Assess their income and employment stability.
Consider their debt-to-income ratio.
Review their payment history on previous loans or credit cards.
Check if they have any outstanding debts or bankruptcies.
Verify their identity and address.
Assess their financial responsibility and spending habits.
Consider any reference...read more
Q40. Why does a specific algorithm work/Doesn't work for your problem?
A specific algorithm works for a problem if it is designed to handle the problem's characteristics effectively.
The algorithm should be able to process the input data efficiently.
It should consider the problem's constraints and requirements.
The algorithm should produce correct and accurate results for the problem.
The algorithm's complexity should be suitable for the problem's scale.
If applicable, the algorithm should be able to handle edge cases or exceptions.
Example: A sortin...read more
Q41. There are fifteen bowls of steel in front of you. All are of the same shape and size, but one of those bowls is slightly less in weight. You have to identify which one is it without holding them or using the we...
read moreIdentify the slightly lighter bowl among fifteen identical steel bowls without using a weighing scale or holding them.
Observe the bowls closely for any visible differences in shape or size.
Tap each bowl gently and listen for any differences in sound.
Place each bowl on a flat surface and observe if any wobble or spin longer than others.
Use a magnet to check if any bowl is made of a different material.
Check the temperature of each bowl with your hand to see if any is cooler or ...read more
Prevent breaking singleton pattern using reflections by throwing an exception in the private constructor.
Throw an exception in the private constructor if an instance already exists.
Use a flag to track if an instance has been created and throw an exception if an attempt is made to create another instance.
Use enums to create a singleton to prevent reflection attacks.
Q43. What are inorganic and organic results in digital marketing
Inorganic results are paid ads in search engines while organic results are the natural listings.
Inorganic results are paid advertisements that appear at the top or bottom of search engine results pages (SERPs).
Organic results are the natural listings that appear in SERPs based on relevance to the search query.
Inorganic results are marked as 'Ad' while organic results are not.
Examples of inorganic results include Google Ads, Bing Ads, and social media ads.
Examples of organic r...read more
Q44. Assume that there are 1 lac prospective credit cards clients available in a city. Design a strategy based on five parameters/basis to approach clients i.e. which clients should be approached first, second etc…
Q45. What is the importance of soft skills in customer dealing business?
Soft skills are crucial in customer dealing business as they help in building rapport, resolving conflicts, and ensuring customer satisfaction.
Soft skills like communication, empathy, and active listening help in understanding customer needs and concerns.
They also aid in conflict resolution and problem-solving, which are essential in dealing with dissatisfied customers.
Soft skills like patience and positivity help in maintaining a calm and professional demeanor, even in stres...read more
Q46. Explain the classification algorithms you used in your project?
I used multiple classification algorithms in my project.
Decision Tree: Used for creating a tree-like model to make decisions based on features.
Random Forest: Ensemble method using multiple decision trees to improve accuracy.
Logistic Regression: Used to predict binary outcomes based on input variables.
Support Vector Machines: Used for classification by finding the best hyperplane to separate data points.
Naive Bayes: Based on Bayes' theorem, used for probabilistic classificatio...read more
Q47. What is c,c++,tokens, statement, function, array,pointer, constructor,types of constructor ,destructor etc.
This question is about basic concepts in C and C++ programming languages.
C and C++ are programming languages used for system and application software development.
Tokens are the basic building blocks of a program, such as keywords, identifiers, operators, and literals.
Statements are instructions that perform a specific task.
Functions are blocks of code that perform a specific task and can be called from other parts of the program.
Arrays are collections of similar data types st...read more
Q48. What do you mean by Credit Risk and how will you try to analyse a person’s credit risk?
Credit risk refers to the potential for loss due to a borrower's failure to repay a loan or meet their financial obligations.
Credit risk is the risk that a borrower may default on their loan or fail to meet their financial obligations.
To analyze a person's credit risk, various factors are considered such as their credit history, income level, employment stability, and debt-to-income ratio.
Credit risk analysis involves assessing the likelihood of default and determining the ap...read more
Q49. What does American Express do? What is the AmEx Credit Card Model?
American Express is a financial services company known for its credit card offerings.
American Express is a global financial services company headquartered in New York City.
It is known for its charge cards, credit cards, and traveler's cheques.
AmEx operates a closed-loop network, meaning it both issues cards and processes transactions.
The company offers a range of credit card products, including rewards cards, cashback cards, and premium cards.
AmEx has a strong focus on custom...read more
Q50. Explain the solution which won you the third prize in “Analyze this” competition
The solution that won me the third prize in the 'Analyze this' competition was a machine learning model.
I developed a machine learning model using Python and scikit-learn library.
The model was trained on a large dataset of customer data and their purchasing behavior.
It used various features such as age, gender, income, and previous purchase history to predict the likelihood of a customer making a purchase.
I used cross-validation techniques to evaluate the model's performance ...read more
Q51. Why customer service?
Customer service allows me to help people and provide excellent support.
I enjoy assisting and solving problems for customers.
I have strong communication and interpersonal skills.
I find satisfaction in providing excellent service and exceeding customer expectations.
I believe in building positive relationships with customers.
Customer service allows me to contribute to the success of a company by ensuring customer satisfaction.
Example: I once helped a frustrated customer resolve...read more
Q52. What is a credit card and what is CIBIL score?
A credit card is a payment card issued by a financial institution that allows the cardholder to borrow funds for purchases.
Credit cards are a convenient form of payment that allows users to make purchases and pay for them later.
They provide a line of credit, which is essentially a loan from the issuing bank.
Cardholders can use credit cards to make purchases online, in stores, or over the phone.
Credit cards often come with rewards programs, such as cashback or travel points.
CI...read more
Q53. Q1. Case study for Number of Green T-shirts sold in US?
A case study on the number of green T-shirts sold in the US.
Identify the target audience for green T-shirts
Analyze the market demand for green T-shirts
Study the sales data of green T-shirts in the US
Identify the popular brands and styles of green T-shirts
Analyze the impact of seasonality on sales
Consider the pricing strategy of green T-shirts
Identify potential marketing opportunities to increase sales
Q54. how do you think you can contribute to HNI merchant sales
I can contribute to HNI merchant sales by leveraging my strong network, strategic partnerships, and proven track record in driving revenue growth.
Utilizing my extensive network of high-net-worth individuals to generate leads and referrals
Establishing strategic partnerships with key players in the industry to expand market reach
Implementing targeted marketing campaigns to attract HNI clients
Leveraging my experience in driving revenue growth through effective sales strategies
Pr...read more
Q55. What is the difference between charge card & credit card?
Charge cards require full payment each month, while credit cards allow for carrying a balance.
Charge cards require the full balance to be paid off each month, while credit cards allow for carrying a balance over time.
Charge cards typically have no pre-set spending limit, while credit cards have a credit limit.
Charge cards often charge an annual fee, while credit cards may or may not have an annual fee.
Examples of charge cards include American Express and Diners Club, while ex...read more
Q56. What is vlookup, how to dashboards, pivot table use, difference btw hlookup and vlookup, if you have some knowledge of VBA then its a plus.
VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.
Dashboards are visual representations of data that allow users to quickly analyze and make decisions based on the information presented.
Pivot tables are used to summarize and analyze large amounts of data in a table format.
HLOOKUP is similar to VLOOKUP, but searches for a value in a row instead of a column.
VBA (Visual Basic for Applications) is a programming language...read more
Q57. What is the difference between a fraud and a dispute?
Fraud is an intentional act of deception, while a dispute is a disagreement between two parties.
Fraud involves intentional deception, while disputes arise from disagreements between parties.
Fraud is a criminal offense, while disputes can be resolved through negotiation or legal means.
Fraud involves misrepresentation or concealment of information, while disputes involve differences in interpretation or understanding.
Examples of fraud include identity theft, credit card fraud, ...read more
Q58. How you used data management and analytics in your last role?
I utilized data management and analytics to track project progress, identify trends, and make data-driven decisions.
Implemented data management systems to organize and store project data efficiently
Utilized analytics tools to analyze project performance and identify areas for improvement
Generated reports and dashboards to track key metrics and communicate findings to stakeholders
Used data insights to make informed decisions and drive project success
Q59. How you can make business decisions from data in your last role?
I used data analysis tools to identify trends, patterns, and correlations to inform strategic business decisions.
Utilized data visualization tools to present key findings to stakeholders
Conducted regression analysis to predict future outcomes based on historical data
Collaborated with cross-functional teams to gather and analyze data from multiple sources
Q60. What is digital marketing?
Digital marketing is the practice of promoting products or services using digital channels and technologies.
Digital marketing involves various strategies such as search engine optimization (SEO), social media marketing, email marketing, and content marketing.
It aims to reach and engage with a target audience through online platforms like websites, social media platforms, search engines, and mobile apps.
Digital marketing allows businesses to measure and analyze their marketing...read more
Q61. Guesstimate on the number of active flights over India during a particular instance.
There are approximately 2,000 active flights over India at any given time.
India has a busy aviation industry with major airports in cities like Delhi, Mumbai, and Bangalore.
On average, there are around 2,000 flights in the air over India at any given time.
This number can fluctuate depending on the time of day, day of the week, and season.
Factors like weather conditions, air traffic control, and airline schedules can also impact the number of active flights.
Q62. guesstimate: no. of amex credit card users in India. Follow up questions to test business acumen and understanding of the business
Estimating the number of American Express credit card users in India based on business acumen
Consider the market share of American Express in India compared to other credit card companies
Analyze the population size and income levels in India to estimate the potential number of credit card users
Look at the growth trends in the credit card industry in India to make a projection
Consider the marketing strategies and partnerships of American Express in India
Q63. how they use data analytics in their field of work.
Data analytics is crucial in my field of work as it helps in making informed decisions and identifying patterns.
We use data analytics to track customer behavior and preferences.
We analyze sales data to identify trends and adjust our marketing strategies accordingly.
We use predictive analytics to forecast demand and optimize inventory levels.
We monitor website traffic and engagement metrics to improve user experience.
We use data visualization tools to present insights in a cle...read more
Q64. What do you think about Amex Bluebox Value - "Doing it the right way"?
Amex Bluebox Value focuses on ethical business practices and transparency.
Amex Bluebox Value emphasizes the importance of integrity and honesty in business operations.
They prioritize transparency and accountability in their decision-making processes.
By 'Doing it the right way', Amex Bluebox Value aims to build trust with customers and stakeholders.
Examples of 'Doing it the right way' include fair pricing strategies, ethical sourcing practices, and clear communication with cus...read more
Q65. What is difference between charge card and credit card?
Charge cards require full payment each month while credit cards allow for carrying a balance.
Charge cards require full payment each month while credit cards allow for carrying a balance.
Charge cards typically have higher annual fees and stricter credit requirements.
Credit cards offer rewards programs and cash back incentives while charge cards do not.
Examples of charge cards include American Express Platinum and Centurion cards while examples of credit cards include Visa and ...read more
Q66. Concept of depreciation along with journal entries.
Depreciation is the decrease in value of an asset over time. Journal entries are made to record the depreciation expense.
Depreciation is a non-cash expense that reduces the value of an asset over its useful life.
The journal entry for depreciation includes a debit to Depreciation Expense and a credit to Accumulated Depreciation.
Accumulated Depreciation is a contra asset account that shows the total amount of depreciation taken on an asset.
For example, if a company purchases a ...read more
Q67. A cricket match is going on at Eden Gardens. Estimate the number of 10 rupee notes in entire stadium
Estimating the number of 10 rupee notes in a cricket stadium is challenging due to various factors such as crowd size and ticket prices.
Consider the seating capacity of the stadium
Estimate the percentage of attendees who carry 10 rupee notes
Take into account the average number of notes carried by each person
Factor in the number of vendors and their transactions
Consider the duration of the match and the frequency of note exchanges
A loop in a linked list can be detected using Floyd's Cycle Detection Algorithm.
Use two pointers - slow and fast, where slow moves one step at a time and fast moves two steps at a time.
If there is a loop, the two pointers will eventually meet at some point within the loop.
To detect the start of the loop, reset one pointer to the head and move both pointers one step at a time until they meet again.
Q69. Write a program to find 2nd highest number in an unsorted array.
Program to find 2nd highest number in an unsorted array.
Sort the array in descending order and return the second element.
Iterate through the array and keep track of the two highest numbers.
Handle edge cases like duplicates and small array sizes.
Q70. Write a query to find the common values from two SQL tables.
Use SQL JOIN to find common values in two tables.
Use INNER JOIN to combine the two tables based on a common column
Select the columns you want to display in the result
Add a WHERE clause to filter out non-matching values
Q71. How do you iterate only once in the linkedlist to get the mid element?
To find the mid element in a linked list while iterating only once, we can use the two-pointer approach.
Use two pointers, one moving at twice the speed of the other.
When the faster pointer reaches the end of the list, the slower pointer will be at the mid element.
Q72. how to use data analytics for credit cards.
Data analytics can be used to identify spending patterns, detect fraud, and personalize offers for credit card users.
Analyze transaction data to identify spending patterns and preferences of customers
Use predictive analytics to detect and prevent fraud
Leverage machine learning algorithms to personalize offers and rewards for customers
Monitor credit scores and credit utilization rates to identify potential risks
Track customer feedback and complaints to improve customer satisfa...read more
Q73. How would you deal with a difficult customer?
I would listen to their concerns, empathize with their situation, and offer a solution to their problem.
Remain calm and professional
Listen actively to their concerns
Empathize with their situation
Offer a solution to their problem
If necessary, escalate the issue to a supervisor
Q74. What are the 3 pillars of data management?
The 3 pillars of data management are data quality, data governance, and data security.
Data quality ensures that data is accurate, complete, and reliable.
Data governance involves establishing policies and procedures for managing data assets.
Data security focuses on protecting data from unauthorized access or breaches.
Q75. 1. Explain SCD Type 2 Implementation in Informatica
SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.
SCD Type 2 maintains a separate row for each change in data, with a start and end date.
It requires a surrogate key to uniquely identify each row.
Informatica provides a built-in SCD Type 2 transformation to implement this technique.
Example: tracking changes in customer addresses over time.
Q76. What do you mean by blue box values?
Blue box values refer to a set of predefined values used in data analysis and decision-making processes.
Blue box values are predetermined values that are used as benchmarks or thresholds in analytical models.
These values are often based on industry standards, best practices, or regulatory requirements.
Blue box values help analysts make informed decisions by comparing data against these predefined values.
For example, in financial analysis, blue box values can include threshold...read more
Q77. What is the Technical tools you have used.
I have experience using tools such as Microsoft Excel, SQL, Tableau, and Jira.
Microsoft Excel
SQL
Tableau
Jira
Q78. How would you approach designing a credit management strategy for credit cards?
I would approach designing a credit management strategy for credit cards by analyzing customer behavior, setting credit limits, monitoring transactions, and implementing fraud detection measures.
Analyze customer behavior to determine credit risk
Set appropriate credit limits based on income and credit history
Monitor transactions for any suspicious activity
Implement fraud detection measures such as real-time alerts and security features
Offer credit education and counseling to h...read more
Q79. What is the business model of Amex? (open loop vs close loop)
Amex operates on an open loop business model.
Amex operates as a payment network that partners with various merchants and banks to process transactions.
Open loop systems allow for transactions to be made at a wide range of merchants, both online and offline.
Examples of open loop systems include Visa, Mastercard, and Discover.
Q80. How will you pull data from a table, given a time interval?
Use SQL query with WHERE clause to pull data from a table based on a time interval.
Use SQL query with SELECT statement to specify the columns you want to retrieve.
Add a WHERE clause with the condition for the time interval, using appropriate date/time functions.
Example: SELECT * FROM table_name WHERE timestamp_column BETWEEN 'start_time' AND 'end_time';
Q81. How would you run a business on a state level to maximize your sales?
To maximize sales on a state level, focus on market research, targeted marketing strategies, strong customer service, and strategic partnerships.
Conduct market research to understand the local consumer behavior and preferences
Implement targeted marketing strategies based on the research findings
Provide excellent customer service to build loyalty and attract repeat business
Form strategic partnerships with local businesses or organizations to expand reach and customer base
Q82. How many traffic signals are there in Mumbai?
It is not possible to determine the exact number of traffic signals in Mumbai without available data.
The number of traffic signals in Mumbai can vary over time due to construction, removal, or changes in traffic management.
The Mumbai Traffic Police or Municipal Corporation may have the most accurate data on the number of traffic signals.
Estimating the number of traffic signals in Mumbai would require a comprehensive survey or analysis of the city's road network.
Factors such a...read more
Q83. Financial due diligence financial statement analysis how to write credit report
Financial due diligence involves analyzing financial statements to write a credit report.
Start by gathering all relevant financial statements and documents
Analyze the income statement, balance sheet, and cash flow statement for key financial ratios and trends
Assess the company's financial health, profitability, liquidity, and solvency
Write a detailed credit report summarizing your findings and recommendations
Include an executive summary, analysis of financial performance, and...read more
Q84. How would you decide if a person can be a customer of a private jet company
To determine if a person can be a customer of a private jet company, factors such as income level, travel frequency, and location must be considered.
Consider the individual's income level to determine if they can afford private jet services
Evaluate the person's travel frequency to see if they would benefit from the convenience of private jet travel
Take into account the person's location and travel destinations to assess the need for private jet services
Q85. What challenges one person faced while making payments
One of the challenges faced while making payments is the risk of fraud and security breaches.
Fraudulent transactions
Stolen credit card information
Phishing scams
Identity theft
Lack of secure payment options
Technical glitches
Insufficient funds
Design an LRU cache to store and retrieve data based on least recently used policy.
Use a doubly linked list to keep track of the order of usage of the cache entries.
Maintain a hash map to quickly access the cache entries based on their keys.
When a new entry is accessed, move it to the front of the linked list to mark it as the most recently used.
If the cache is full, remove the least recently used entry from the end of the linked list.
Implement methods like get(key) and put(k...read more
Q87. Difference between depreciation and amortization.
Depreciation is the decrease in value of tangible assets over time, while amortization is the decrease in value of intangible assets over time.
Depreciation applies to tangible assets like buildings, machinery, and vehicles.
Amortization applies to intangible assets like patents, copyrights, and trademarks.
Depreciation is calculated based on the useful life of the asset.
Amortization is calculated based on the estimated useful life of the intangible asset.
Both depreciation and a...read more
Q88. What is the difference between Bagging and boosting ?
Bagging and boosting are ensemble learning techniques used to improve the performance of machine learning models by combining multiple weak learners.
Bagging (Bootstrap Aggregating) involves training multiple models independently on different subsets of the training data and then combining their predictions through averaging or voting.
Boosting involves training multiple models sequentially, where each subsequent model corrects the errors made by the previous ones. Examples inc...read more
Q89. find if array of numbers, which are prime, using streams
Use streams to find prime numbers in an array
Use Java streams to filter out non-prime numbers from the array
Check if a number is prime by dividing it by all numbers less than its square root
Create a method to check if a number is prime
Q90. Explain the mathematics involved in recognising speech data
Mathematics involved in recognizing speech data
Speech recognition involves statistical modeling and pattern recognition techniques
Mathematical algorithms are used to convert speech signals into digital representations
Signal processing techniques like Fourier analysis and wavelet transforms are used
Hidden Markov Models (HMMs) are commonly used for speech recognition
Statistical language models are used to improve recognition accuracy
Q91. How do you prioritise work?
I prioritise work based on urgency, importance, and deadlines.
I assess the urgency of each task and prioritize accordingly
I consider the importance of each task and its impact on the project
I take into account any deadlines and ensure they are met
I communicate with team members and stakeholders to ensure alignment on priorities
I regularly review and adjust priorities as needed
Q92. How would you design a marketing campaign to target millenials?
To target millennials, design a marketing campaign with a strong social media presence, influencer partnerships, personalized content, and interactive experiences.
Utilize social media platforms popular among millennials such as Instagram, TikTok, and Snapchat
Collaborate with influencers who have a strong millennial following to promote the campaign
Create personalized content that resonates with millennial values and interests
Offer interactive experiences such as contests, qui...read more
Q93. How would you sell a pen to a person who is handicapped
I would highlight the ease of use and comfort of the pen for someone with limited mobility.
Emphasize the ergonomic design of the pen for comfortable grip
Highlight the smooth writing experience for effortless use
Demonstrate how the pen can be easily operated with one hand
Q94. Spring java and how do you leverage in your project
I leverage Spring Java for dependency injection, MVC framework, and transaction management in my projects.
Utilize Spring's dependency injection to manage object dependencies and improve code maintainability
Leverage Spring MVC framework for building web applications with clean separation of concerns
Use Spring's transaction management to ensure data integrity and consistency in database operations
Q95. what are the eval metrics of a classification model?
Evaluation metrics of a classification model include accuracy, precision, recall, F1 score, and area under the ROC curve.
Accuracy: measures the overall correctness of the model's predictions
Precision: measures the proportion of true positive predictions among all positive predictions
Recall: measures the proportion of true positive predictions among all actual positive instances
F1 score: combines precision and recall into a single metric
Area under the ROC curve: measures the m...read more
Q96. What is ratio analysis interpretation of borrower industry
Q97. imagine any stat from Covid time, what all thing you can derive based on that =
Analyzing Covid-19 vaccination rates to derive insights on population immunity and vaccine distribution effectiveness.
Vaccination rates can indicate the level of immunity within a population.
Disparities in vaccination rates can highlight areas that may need more resources or targeted outreach.
Tracking vaccination rates over time can show the effectiveness of vaccine distribution strategies.
Analyzing vaccination rates by demographics can reveal disparities in access to healthc...read more
Q98. Explain XGBoost and how it works
XGBoost is a popular machine learning algorithm known for its speed and performance in handling large datasets.
XGBoost stands for eXtreme Gradient Boosting, which is an optimized implementation of gradient boosting.
It is based on the gradient boosting framework and uses decision trees as base learners.
XGBoost is known for its speed and performance due to its efficient implementation of parallel processing and tree pruning techniques.
It is widely used in machine learning compe...read more
Q99. What is SEO
SEO stands for Search Engine Optimization. It is the process of optimizing a website to rank higher in search engine results pages.
SEO involves optimizing website content, structure, and HTML code.
Keyword research and analysis is a crucial part of SEO.
Link building and social media marketing can also improve SEO.
Examples of search engines include Google, Bing, and Yahoo.
SEO helps businesses increase their online visibility and attract more organic traffic to their website.
Q100. Project deployment strategy in current project
We use a continuous deployment strategy with automated testing and manual approval.
We have a Jenkins pipeline set up for continuous integration and deployment.
Our code is automatically tested using unit tests and integration tests.
Once the tests pass, the code is deployed to a staging environment for manual testing.
If the staging tests pass, the code is deployed to production.
We also have rollback procedures in place in case of issues.
We use Docker containers to ensure consis...read more
More about working at American Express
Top HR Questions asked in Salesforce
Interview Process at Salesforce
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month