Normal Interview Questions and Answers

Q1. Tell me about you & your family
Add your answer
Q2. Why should we hire you
Add your answer

Q1. Why do you leave your current company
Add your answer
Q2. Why did you choose JPmC
Add your answer
Q3. What motivates you to complete your day to day activities at work
Add your answer

Q1. Explain your last project and your role in this project
Ans. 
Led a team in implementing a new CRM system for a large retail company
• Managed project timeline and deliverables

• Collaborated with stakeholders to gather requirements

• Provided training and support to end users

• Ensured successful implementation and user adoption

• Improved customer data management and analytics
Answered by AI
Add your answer
Q2. Overall working experience with other companies
Ans. 
I have over 10 years of experience working with various companies in consulting roles.
• Managed client relationships and delivered successful projects on time and within budget

• Led cross-functional teams to drive business growth and improve operational efficiency

• Developed and implemented strategic plans to address client needs and achieve objectives
Answered by AI
Add your answer
Q3. Why choose kafka over MQ ? what challenges you faced during kafka implementation ?
Ans. 
Kafka is chosen for its scalability and fault tolerance compared to MQ.
• Kafka offers higher throughput and lower latency compared to MQ.

• Kafka is horizontally scalable, allowing for easy expansion as data volume grows.

• Kafka provides fault tolerance through replication of data across multiple brokers.

• Challenges faced during Kafka implementation may include setting up proper configurations, ensuring data consistency, and m...read more
Answered by AI
Add your answer
Q4. Monolith to microservice migration journey ? what all decisions needs to be taken and how the entire migration took place.
Ans. 
Monolith to microservice migration involves breaking down a large application into smaller, independent services.
• Evaluate the current monolith architecture and identify the components that can be decoupled into microservices.

• Define the boundaries of each microservice to ensure they are cohesive and loosely coupled.

• Choose the right technology stack for each microservice based on its requirements and scalability needs.

• Im...read more
Answered by AI
Add your answer
Q5. If worked for RestAPI ? what is the use of swagger ? what is the content of Swagger documentation ?
Ans. 
Swagger is a tool used for documenting and testing REST APIs.
• Swagger is used for documenting REST APIs by providing a user-friendly interface to view and interact with API endpoints.

• It allows developers to easily understand the functionality of an API, including available endpoints, request/response formats, and authentication methods.

• Swagger documentation typically includes information such as API endpoints, request p...read more
Answered by AI
Add your answer
Q6. Only this was asked to me , and rejected
Add your answer

Q1. What are derivatives in finance?
Ans. 
Derivatives in finance are financial instruments whose value is derived from the value of an underlying asset.
• Derivatives can be used for hedging against risk, speculating on price movements, or gaining exposure to assets without owning them.

• Common types of derivatives include options, futures, forwards, and swaps.

• Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price be...read more
Answered by AI
Add your answer
Q2. What are the different types of derivatives?
Ans. 
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
• Types of derivatives include options, futures, forwards, and swaps.

• Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price before or on a specified date.

• Futures are contracts to buy or sell an asset at a future date for a price agreed upon today.

• Forwards are similar to...read more
Answered by AI
Add your answer

Q1. What are the details of the stock market and its various products?
Ans. 
The stock market is a platform where investors can buy and sell shares of publicly traded companies.
• Stocks represent ownership in a company and can be bought and sold on stock exchanges like NYSE and NASDAQ.

• Bonds are debt securities issued by companies or governments to raise capital.

• Mutual funds pool money from multiple investors to invest in a diversified portfolio of stocks, bonds, or other securities.

• Options give i...read more
Answered by AI
Add your answer
Q2. Balance sheet,profit &loss account
Add your answer
Q3. Journal entries
Add your answer
Q4. Option in detail, economic crisis,
Add your answer

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Competitive

Was interesting and very tough to crack

Q1. Knowledge and related questions
Add your answer

Q1. Personal question
Add your answer
Q2. Situation question
Add your answer

Q1. Walk me thru your CV
Add your answer
Q2. Technical questions from Job description
Add your answer
Q3. Why switching your job?
Add your answer
Q4. Behavioral Questions
Add your answer
Q5. Projects and accomplishments
Add your answer
Q6. How do you align with the role?
Add your answer

Q1. Introduction, be prepared to have knowledge on your resume
Add your answer
Q2. Mathematical questions like percentage
Add your answer
Q3. Critical thinking. They asked a question with a given situation what you'll do .
Add your answer
Q4. The past 4 days been climate be stroming . And current was cut off due to rain and flood , you have a important assignment to finish, what you'll do
Add your answer