Indus Valley Partners Interview Questions, Process, and Tips for Experienced

Coding Rount
DSA Round + Puzzle
SQL + Project Discussion
JS

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization helps in minimizing data redundancy by dividing the database into multiple tables.

• It ensures data integrity by avoiding update anomalies.

• Normalization is achieved through a series of rules called normal forms, such as 1NF, 2NF, 3NF, etc.

• Example: In a database, instead of storing customer details i...read more
Answered by AI
Add your answer
Q2. What is reflection
Ans. 
Reflection is the ability of a program to examine and modify its own structure and behavior at runtime.
• Allows accessing metadata of types and members at runtime

• Enables dynamic instantiation of objects

• Facilitates invoking methods dynamically
Answered by AI
Add your answer

Q1. What is singleton design pattern
Ans. 
Singleton design pattern restricts the instantiation of a class to a single instance and provides global access to it.
• Used when only one instance of a class is required throughout the application

• Provides a global point of access to the instance

• Implemented using a private constructor, static method, and static variable

• Example: Logger class, Database connection class
Answered by AI
Add your answer
Q2. C# LINQ queries for group and sum data from data table
Ans. 
C# LINQ queries for group and sum data from data table
• Use GroupBy() method to group data based on a specific column

• Use Sum() method to calculate the sum of a column

• Use Select() method to select the required columns
Answered by AI
Add your answer
Q3. Solid design principles
Ans. 
Solid design principles are a set of guidelines for writing maintainable and scalable code.
• Single Responsibility Principle (SRP) - each class should have only one responsibility

• Open/Closed Principle (OCP) - classes should be open for extension but closed for modification

• Liskov Substitution Principle (LSP) - subclasses should be able to replace their parent classes without affecting the program's correctness

• Interface Se...read more
Answered by AI
Add your answer
Q4. OOPS concepts ,like association and all
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. More question was related to past experience
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Questions related to past exp
Add your answer
Q3. Explain trade life cycle
Ans. 
Trade life cycle is the process of a trade from initiation to settlement.
• Trade initiation: Trade is proposed and agreed upon by parties involved.

• Trade execution: Trade is executed on the exchange or over-the-counter market.

• Trade confirmation: Parties confirm the details of the trade.

• Trade settlement: Payment and transfer of securities are completed.

• Trade reconciliation: Ensuring all details match between parties' recor...read more
Answered by AI
Add your answer

Q1. Generic questions which are asked in most hr rounds
Add your answer