American Express
200+ Interview Questions and Answers
Given an array/list of integers of length ‘N’, there is a sliding window of size ‘K’ which moves from the beginning of the array, to the very end. You can only see the ‘K’ nu...read more
You are given an array/list of ‘N’ integers. You are supposed to return the maximum sum of the subsequence with the constraint that no two elements are adjacent in the given ...read more
You are given a list of “N” strings A. Your task is to check whether you can form a given target string using a combination of one or more strings of A.
Note :
You can use any string of A multiple tim...read more
Given a source point (sx, sy) and a destination point (dx, dy), the task is to check if it is possible to reach the destination point using the following valid moves:
(a, b) -> (a + b, b) (...read more
You are given an array 'ARR' of 'N' positiv...read more
You are given a 2-dimensional array/list having N rows and M columns, which is filled with ones(1) and zeroes(0). 1 signifies land, and 0 signifies water.
A cell is said to be connected to...read more
You are given a singly Linked List of integers. Your task is to return true if the given singly linked list is a palindrome other...read more
You are given string S of length N, and an integer K. Your task is to find the length of the longest substring that contains at most K distinct characters.
I...read more
You are given an array 'ARR' of integers of length 'N' and a positive integer 'K'. You need to find the maximum elements for each and every contiguous subarray of size K of the array.
For exampl...read more
There is a directed graph consisting of ‘N’ nodes numbered from 0 to ‘N’-1. You are given a list ‘EDGES’ of size ‘M’, consisting of all the edges of this directed graph,...read more
You have been given a string STR and a non-empty string PTR. Your task is to find all the starting indices of PTR’s anagram in STR.
An anagram of a string is another string which contains the s...read more
You are Harshad Mehta’s friend. He told you the price of a particular stock for the next ‘N’ days. You can either buy or sell a stock. Also, you can only complete at most 2-transactions. Find ...read more
You are given an array of integers and a number ‘K’. You can pair two elements in the array 'ARR' if the absolute difference between them is strictly less than ‘K’. Your task...read more
- There is an island with 100 prisoners, all of who have green eyes.
- All 100 prisoners are perfect logicians.
- They all want to escape the island.
- The condition of escaping the island is that one can deduce one...read more
Q16. 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
Given a singly linked list, you have to detect the loop and remove the loop from the linked list, if present. You have to make changes in the given linked list itself and return the update...read more
You have been given an integer array/list(arr) and a number 'Sum'. Find and return the total number of pairs in the array/list which when added, results equal to the 'Sum'.
Note:
G...read more
Implement a Stack Data Structure specifically to store integer data using two Queues.
There should be two data members, both being Queues to store the data internally. You may use the inbuilt Q...read more
Given a list of cities numbered from 0 to N-1 and a matrix 'DISTANCE' consisting of 'N' rows and 'N' columns denoting the distances between each pair of cities, what is the shortest p...read more
Q21. 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
Ninja is learning tree data structure these days. While learning, she came across learn about the Binary Search tree. She found BST quite interesting. She decided to make her own Binary Search...read more
You have a robot currently standing at the origin (0, 0) of a two-dimensional grid and facing north direction. You are given a sequence of moves for the robot in the form of a string of size 'N'. Y...read more
You have been given two sorted arrays/lists of closed intervals ‘INTERVAL1’ and ‘INTERVAL2’. A closed interval [x, y] with x < y denotes the set of real numbers ‘z’ with x <= z <= y.
N...read more
You have been given an array 'ARR' of 'N' distinct elements.
Your task is to find the minimum no. of swaps required to sort the array.
For example:
For the given...read more
Given a binary tree. Print the Left View of the Tree.
Example :
If the input tree is as depicted in the picture:
The Left View of the tree will be: 2 35 2
Input format :
Elements in t...read more
Q28. 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
You are given Rs 100 every week. Every day you put Rs 5 in you piggy bank except on Sunday you put Rs 10. You take a bus to college, one side trip costs Rs 4, you do 2 trips a day. You have your lunch in ...read more
A man fell in a 50m deep well. He climbs 4 meters up and slips 3 meters down in one day. How many days would it take for him to come out of the well?
Q31. 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.
Given two integer N and K representing number of chips a person has and the number of chips he can use at max at a time, return the minimum number of rounds that are necessary for John to leave t...read more
Q33. 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
Q36. 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
Q37. 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
I was asked to generalize a puzzle for 'n' values from the previous round.
The puzzle was
You have 9 balls, equally big, equally heavy - except for one, which is a little heavier.
How would you identify th...read more
There is a room with a door (closed) and three light bulbs. Outside the room, there are three switches, connected to the bulbs. You may manipulate the switches as you wish, but once you open the door you ...read more
You have 9 balls, equally big, equally heavy - except for one, which is a little heavier.
How would you identify the heavier ball if you could use a pair of balance scales only twice?
Suppose you take 5 mins to think for a coding task, another 10 mins to code where you write 100 lines of code. You take a break of 5 mins every 10 mins. How much lines of code will you have written at the...read more
Q42. 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
1. SQL query to find second highest salary?
2. Join questions
3. Write a query to find the Nth highest salary from the table without using TOP/limit keyword.
Q44. 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
Q45. 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.
Q46. 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
Q47. 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
Given 2 linked lists which merge at some point. Find the node at which the lists merge.
Q49. 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
Q50. 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
Q51. 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
Q52. 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
Q53. 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
How to prevent breaking of singleton pattern using reflections?
Q55. 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
Q56. 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…
Q57. 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
How will you measure 4 litre of water from a 3 litre and 5 litre jug? There are no measurement lines on the jug. You can use any amount of water but only those 2 jugs.
1. Camel and Banana Puzzle
2. Tell me about the projects you worked on
3. Asked me some questions related to my projects
Q62. 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
Q63. 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
Q64. 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
Q65. 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
Q66. 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
Q67. 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
Q68. 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
Q69. 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
Q70. 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
Q71. 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
Q72. 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
Q73. 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
Q74. 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
Q75. 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
Q76. 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
Explain Natural Join, Cross Join, Right Outer and Left Outer Join with diagrams. Also write queries using GROUP BY and HAVING.
Q79. 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.
Q80. 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
Q81. 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
Q82. 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
Detect loop in a linked list.
Q84. 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
Q85. 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.
Q86. 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
Q87. 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
Q88. 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.
Q89. 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
Q90. 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
Q91. 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.
Q92. 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.
Q93. 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
Q94. 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
Q95. 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';
Q96. 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
Q97. 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.
Q98. 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
Q99. 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
Q100. 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
More about working at American Express
Top HR Questions asked in null
Interview Process at null
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month