Finastra Interview Questions, Process, and Tips

Logical reasoning questions along with the pseudo coding

Q1. Questions on manual testing and sql
Add your answer
Q2. What is manual testing
Ans. 
Manual testing is the process of manually testing software for defects, functionality, and usability.
• Manual testing involves testers executing test cases without the use of automation tools.

• Testers follow predefined test cases to ensure the software meets requirements.

• It includes exploratory testing to uncover unexpected issues.

• Examples: Regression testing, smoke testing, ad-hoc testing.
Answered by AI
Add your answer
Q3. Positive and negative scenarios on notepad, word
Add your answer
Q4. Queries on joints
Add your answer

Q1. Questions on testing and SQL queries
Add your answer

The test was good with few complex questions

The topic was easy and can be spoken of

Q1. Explain the difference between stock and share.
Ans. 
Stock represents ownership in a company, while share is a single unit of ownership in a company.
• Stock is the overall ownership of a company, while share is a single unit of that ownership.

• Stock can refer to all shares of a company, while share refers to a specific unit of ownership.

• Stock can include different classes of shares, such as common and preferred shares.

• Shares are bought and sold on stock exchanges, while sto...read more
Answered by AI
Add your answer
Q2. What are three financial statements?
Ans. 
The three financial statements are the income statement, balance sheet, and cash flow statement.
• Income statement: Shows a company's revenues and expenses over a specific period of time.

• Balance sheet: Provides a snapshot of a company's financial position at a specific point in time, showing assets, liabilities, and equity.

• Cash flow statement: Details the cash inflows and outflows of a company during a specific period, s...read more
Answered by AI
Add your answer

The first round was a coding + sql skill test. But i attended the interview in 2015, the process might have changed from then.

There were few questions related to SQL query writing for different scenerios, the test was around 1 hour. After that there was a email test to see the communication skills.

Q1. Which kind of data storage is easy for processing XML or Files?
Ans. 
XML databases are easy for processing XML data, while file systems are easy for processing files.
• XML databases are designed specifically for storing and querying XML data.

• They provide efficient indexing and querying capabilities for XML documents.

• Examples of XML databases include eXist-db, BaseX, and MarkLogic.

• File systems, on the other hand, are well-suited for storing and processing files of any type.

• They provide a h...read more
Answered by AI
Add your answer
Q2. How would you make sure a dead lock doesnt happen during sql transactions?
Ans. 
To prevent deadlocks in SQL transactions, use proper transaction management techniques.
• Use a consistent order for acquiring locks on resources to avoid circular dependencies.

• Keep transactions short and release locks as soon as they are no longer needed.

• Use lock timeouts to prevent transactions from waiting indefinitely.

• Implement deadlock detection and resolution mechanisms.

• Consider using higher isolation levels like Se
Answered by AI
Add your answer

Q1. Oops concepts,few coding questions
Add your answer

Basic aptitude questions