BankBazaar Associate Analyst Interview Questions and Answers

Q1. Machine learning and Java programming questions
Add your answer

Q1. Tell about your self
Add your answer

Q1. Salary detatil of old company
Add your answer

Q1. Brief about yourself
Add your answer
Q2. Experience about Hitachi services
Add your answer

Q1. What is the structure of iso 8583
Ans. 
ISO 8583 is a messaging standard used for financial transactions in the banking industry.
• ISO 8583 defines the format of messages exchanged between devices in a financial transaction network.

• It consists of a message header, a bitmap indicating which data elements are present, and data elements containing transaction information.

• Each data element has a specific format and length, such as the card number, transaction amou...read more
Answered by AI
Add your answer
Q2. Message flow of iso 8583
Ans. 
ISO 8583 is a messaging standard used for financial transactions.
• ISO 8583 defines the format of messages exchanged between devices in a financial transaction network.

• The message flow typically includes message type indicators, data elements, and network-specific headers.

• Example: A customer swipes their credit card at a point of sale terminal, which then sends an ISO 8583 message to the acquiring bank for authorization.
Answered by AI
Add your answer
Q3. What isevents and store and forword queue
Ans. 
Events and store and forward queue are concepts related to managing data and communication in a system.
• Events are occurrences or happenings within a system that trigger actions or processes.

• Store and forward queue is a method of storing data temporarily before forwarding it to the next destination.

• Example: In a retail store, an event could be a customer making a purchase, triggering the store to update inventory. Store...read more
Answered by AI
Add your answer

Q1. Types of card production system and how they are working
Ans. 
There are various types of card production systems, each with their own unique features and functionalities.
• Direct-to-card printers: Print directly onto the surface of the card using dye-sublimation or thermal transfer technology.

• Retransfer printers: Print the card image onto a clear film which is then thermally bonded to the card surface for higher quality and durability.

• Embossing machines: Create raised characters on...read more
Answered by AI
Add your answer
Q2. SQL server and database
Add your answer

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

General SQL Question

Q1. General puzzle questions from GFG
Add your answer
Q2. Normal interview level SQL Question
Add your answer

Q1. There were lot of behavioral questions
Add your answer
Q2. Then there were few questions related to how to navigate through the data
Add your answer