Dnyanesh G. Bhave MEP Consultant Interview Questions and Answers

To understand customer behaviour based on credit card transaction, I would analyze spending patterns, transaction frequency, and purchase categories.

• Analyze spending patterns to identify high and low spenders

• Analyze transaction frequency to identify regular and irregular customers

• Analyze purchase categories to identify customer preferences and interests

• Use data visualization tools to identify trends and patterns

• Compare customer behavior to industry benchmarks and competitors

• I...read more

Different types of join include inner, outer, left, right, cross, and self join.

• Inner join returns only the matching rows from both tables.

• Outer join returns all rows from both tables and null values for non-matching rows.

• Left join returns all rows from the left table and null values for non-matching rows from the right table.

• Right join returns all rows from the right table and null values for non-matching rows from the left table.

• Cross join returns the Cartesian product of b...read more

Banking products include savings accounts, checking accounts, loans, credit cards, and investment accounts.

• Savings accounts: earn interest on deposited funds

• Checking accounts: used for daily transactions and bill payments

• Loans: borrowed money with interest

• Credit cards: allows purchases on credit with interest

• Investment accounts: used to invest in stocks, bonds, and mutual funds

Derivatives are financial instruments whose value is derived from an underlying asset or benchmark.

• Types of derivatives include futures contracts, options contracts, swaps, and forward contracts.

• Futures contracts are agreements to buy or sell an asset at a predetermined price and date in the future.

• Options contracts give the holder the right, but not the obligation, to buy or sell an asset at a specified price within a certain timeframe.

• Swaps involve the exchange of cash flow...read more

Data pipeline flow involves data ingestion, processing, storage, and analysis.

• Data is first ingested from various sources such as databases, APIs, or files.

• The data is then processed to clean, transform, and enrich it for analysis.

• Processed data is stored in a data warehouse, data lake, or other storage solutions.

• Finally, the data is analyzed using tools like SQL, Python, or BI platforms to derive insights.

• Example: Data is ingested from a CRM system, processed to remove dupli...read more