Finastra Senior Software Engineer Interview Questions and Answers

Q1. Asked question on Java, Spring boot , SQL basic to advance
Add your answer

Q1. Array coding question. they are mainly checking on time complexity and space complexity
Add your answer

Linked list questions

Q1. What is small pointer and why we use it
Ans. 
A small pointer is a pointer that takes up less memory space and is used to optimize memory usage and improve performance.
• Small pointers are typically used in embedded systems where memory is limited

• They can also be used in data structures to reduce memory overhead

• Example: Using a small pointer instead of a regular pointer to store memory addresses
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. SQL , Stored Procedures, Transaction,
Add your answer

Q1. Where do you see yourself in 5 years?
Add your answer
Q2. Tell me about yourself.
Add your answer