Open Financial Technologies Private Limited Product Support Engineer Interview Questions and Answers

Q1. Explain Concurrency
Ans. 
Concurrency is the ability of a system to execute multiple tasks simultaneously.
• Concurrency allows multiple tasks to run concurrently, improving performance and efficiency.

• Concurrency can be achieved through multithreading or multiprocessing.

• Example: A web server handling multiple requests simultaneously using multithreading.
Answered by AI
Add your answer
Q2. Explain Acid principles
Ans. 
ACID principles are a set of properties that guarantee database transactions are processed reliably.
• Atomicity: Transactions are all or nothing. If one part of the transaction fails, the entire transaction is rolled back.

• Consistency: Transactions bring the database from one valid state to another. All constraints are satisfied.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once...read more
Answered by AI
Add your answer

Basic DSA and android questions

Live coding round for android

Q1. Explain your past experiences?
Add your answer

Q1. Low Level Design: How to do rate limiting for a platform serving 100K requests per second.
Ans. 
Implement rate limiting for a platform serving 100K requests per second.
• Use a token bucket algorithm to limit the rate of incoming requests.

• Set a maximum number of tokens in the bucket to control the rate.

• Refill the bucket at a constant rate to allow bursts of requests.

• Track the timestamp of the last request to enforce the rate limit.

• Consider using a distributed rate limiting system for scalability.

• Monitor and adjust t...read more
Answered by AI
Add your answer

Q1. Find edge score of the nodes in a directed graph
Ans. 
Edge score of nodes in a directed graph
• Edge score is a measure of the importance of a node in a graph

• It is calculated by counting the number of edges that point to or from a node

• Nodes with higher edge scores are considered more important

• Edge score can be calculated using algorithms like PageRank or HITS
Answered by AI
Add your answer

Q1. Rotten oranges after every second in 2D matrix
Ans. 
Simulate rotting of oranges in a 2D matrix every second.
• Create a queue to store the coordinates of fresh oranges

• Iterate through the matrix and add the coordinates of fresh oranges to the queue

• Simulate the rotting process by iterating through the queue and rotting adjacent fresh oranges

• Keep track of the time taken for all oranges to rot

• Return -1 if there are any fresh oranges left after the simulation
Answered by AI
Add your answer
Q2. Java and Spring concepts, HTTP, HTTPS, OSI layers
Add your answer
Q3. DB design for air ticket booking system
Ans. 
DB design for air ticket booking system
• Create tables for flights, passengers, bookings, and payments

• Use foreign keys to establish relationships between tables

• Include fields for flight details, passenger information, and payment details

• Consider implementing a caching mechanism for frequently accessed data
Answered by AI
Add your answer

Technical MCQs (OS, CN, etc.), 2 coding questions (medium level)

Q1. Leetcode - Rainwater Harvesting
Add your answer
Q2. Leetcode - Array/String
Add your answer

Q1. HR + Resume Review (Technical)
Add your answer
Q2. Explain Projects/Experience
Add your answer

In round 1 we could only use Java

Q1. Interviewers are very friendly. Mostly the questions were based on SQL, dsa
Add your answer

Q1. Smallest difference pair of values between two unsorted arrays
Ans. 
Find the smallest difference pair of values between two unsorted arrays.
• Sort both arrays and compare elements to find the smallest difference.

• Use two pointers approach to iterate through both arrays simultaneously.

• Consider edge cases like empty arrays or arrays with only one element.
Answered by AI
View 1 more answer
Q2. 2D matrix iteration based question
Add your answer
Q3. What is normalisation in DBMS?
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• It helps in reducing data redundancy by storing data in a structured and organized manner.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules to follow.

• For...read more
Answered by AI
Add your answer
Q4. What is the difference between SQL and NoSQL?
Ans. 
SQL is a traditional relational database management system, while NoSQL is a non-relational database system.
• SQL is table-based, with a predefined schema, while NoSQL is document, key-value, wide-column, or graph-based, with dynamic schema.

• SQL is suitable for complex queries and transactions, while NoSQL is better for hierarchical data storage and real-time applications.

• SQL is ACID-compliant (Atomicity, Consistency, Iso...read more
Answered by AI
Add your answer

Q1. Design Dream 11 application in high level.
Ans. 
Dream 11 is a fantasy sports platform where users can create their own teams and compete in various sports leagues.
• User registration and login functionality

• Ability to create and join contests

• Player selection and team creation feature

• Real-time scoring and leaderboard updates

• Integration with payment gateway for transactions
Answered by AI
Add your answer

Q1. Explain your recent project in your current company.
Ans. 
Developed a web application for tracking employee attendance and generating reports.
• Used React for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Integrated authentication and authorization features for secure access
Answered by AI
Add your answer

Q1. Why do you want to join Yubi and leave Tavant?
Ans. 
I am excited about the innovative projects at Yubi and believe it aligns better with my career goals.
• Yubi offers more opportunities for growth and learning in cutting-edge technologies.

• I am drawn to Yubi's company culture and values, which resonate with my own.

• I see Yubi as a better fit for my long-term career aspirations compared to Tavant.
Answered by AI
Add your answer
Q2. What process do you follow to switch to a new technology?
Ans. 
I follow a structured approach to evaluate the new technology, learn it through online resources or courses, practice with small projects, and gradually incorporate it into larger projects.
• Research the new technology to understand its features, benefits, and use cases

• Take online courses or tutorials to learn the basics of the technology

• Practice by working on small projects or side projects to gain hands-on experience

• Gr...read more
Answered by AI
Add your answer

DP questions 1D DP and Array question

Q1. Java questions and technical questions from previous experience
Add your answer

Q1. Behavioural questions and standard HR questions
Add your answer
Q2. Why looking for job switch
Ans. 
Seeking new challenges and opportunities for growth in a different environment.
• Looking for new challenges and opportunities to learn and grow

• Interested in working with new technologies or industries

• Seeking a better work-life balance or company culture

• Want to expand my skill set and experience
Answered by AI
Add your answer