ISSL Market Services Interview Questions and Answers

Q1. Introduce yourself
Add your answer
Q2. What has been your experience with framework design and implementation?
Add your answer
Q3. What is the tech and languages you are comfortable with? Rate yourself on each.
Add your answer
Q4. What is your experience with finance?
Add your answer
Q5. What is TDD and BDD? What are the differences and which one do you prefer?
Add your answer

Q1. Write a program to find the frequency of word in a sentence
Add your answer
Q2. Write a program to check if the sum of digits of.the given number is a prime number
Add your answer
Q3. Write an SQL query to get the second highest salary in the table
Add your answer
Q4. What is the difference between abstract class and interface? Give a use case for both.
Add your answer
Q5. Explain static and give it's use case.
Add your answer
Q6. Where are objects stored in memory?
Add your answer

Q1. 3 short programming questions(can solve in any language, just need to complete the missing code)
Add your answer
Q2. Aptitude and technical mcqs
Add your answer

Long programming round in the Chennai office - 3 hours.
use case scenario will be provided: need to sketch any diagrams like uml/class/ER diagrams but not flow chart.

45 min for diagram and presentation to Pannel(each Pannel: 10 students with 1-3 Pannel members) once your presentation and modifications are approved. van proceed with programming(implementation of the use case).

Q1. 30- 45 min of technical 1 Each Pannel consist of 2 to3 interviewers.
Add your answer
Q2. Questions from resume(projects,skillsets) solving problems with low time complexity possible
Add your answer
Q3. Database(sql Querys) Indepth Opps questions(with implementation)
Add your answer

Q1. Technical 2 DSA(data structures like linked list, trees) projects evaluating skills few os and cn questions
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

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. Skill knowledge
Add your answer
Q2. Practical skill testing
Add your answer

Q1. Salary discussion
Add your answer
Q2. Company rules
Add your answer

Q1. Every day to day updates
Add your answer
Q2. Willing to learn and teach
Ans. 
Yes, I am willing to learn new skills and knowledge, and also share my expertise with others.
• I am always eager to expand my skill set and knowledge through training and development opportunities.

• I am also willing to share my expertise with colleagues and assist them in learning new tasks or processes.

• For example, I recently attended a workshop on new software and then trained my team on how to use it effectively.
Answered by AI
Add your answer

Q1. Basic questions on python
Add your answer
Q2. Difference between list tuple
Ans. 
Lists and tuples are both data structures in Python, but lists are mutable while tuples are immutable.
• Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().

• Lists can be modified after creation, while tuples cannot be modified (immutable).

• Lists are typically used for collections of similar items, while tuples are used for fixed collections of items.

• Example: list = [1, 2, 3] and tuple = (4
Answered by AI
Add your answer
Q3. Area of room 6D
Ans. 
The area of a room can be calculated by multiplying the length by the width.
• Calculate the area by multiplying the length and width of the room.

• For example, if the length of the room is 10 feet and the width is 12 feet, the area would be 120 square feet.

• Make sure to use the same units for length and width when calculating the area.
Answered by AI
Add your answer
Q4. Most emberacing situation u faced in your life
Ans. 
Getting caught cheating on a test in high school
• Was copying answers from a classmate during a test

• Teacher caught me and called me out in front of the whole class

• Felt embarrassed and learned my lesson about cheating
Answered by AI
Add your answer
Q5. Behavior questions like what will u do if this happens
Add your answer

The test will comprise a total of 60 questions, divided as follows: 70% of the questions will focus on finance and accounting, while the remaining questions will cover aptitude and English.

Q1. Zero coupon bonds, long-term liabilities, return on equity, debt-equity ratio, captial budgeting and techniques, bonds and its types, debt instruments meaning, collateral, mortgage, spin off, demerger, mer...read more
Add your answer

There were three coding questions.

Q1. Could you provide a thorough explanation of the project?
Add your answer
Q2. OOps Concepts and question from the technical subjects
Add your answer
Q3. Why Spring Boot
Add your answer
Q4. JWT Authentication
Add your answer
Q5. Docker and Kubernetes
Add your answer