Open Financial Technologies Private Limited Test Engineer Interview Questions and Answers

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

Coding test was conducted in hacker earth

Q1. In technical interview they asked the current company work and asked the Instagram db design and usecases and api response of the comment section
Add your answer
Q2. They asked about the coding test question in round 1
Add your answer

Q1. Tech concepts and algo
Add your answer

Q1. Startup mindset
Add your answer

Q1. Speed and quality
Add your answer

Basic DS Question, Medium level difficulty , followed with some puzzles

Q1. System Design : Design in memory Database
Ans. 
Designing an in-memory database involves optimizing data storage and retrieval for fast performance.
• Use data structures like hash tables or B-trees for efficient indexing and searching

• Implement caching mechanisms to reduce disk I/O and improve read/write speeds

• Consider data durability and consistency mechanisms to prevent data loss in case of system failures
Answered by AI
Add your answer

Q1. Discussion with Manager, on projects/work experience and questions around challenges, more on resume /work experience
Add your answer

Q1. LLD/Machine coding - Design a social media application with users, posts, comments, likes, etc. There is also an admin who needs to approve post creation and can delete any post they want. Create appropria...read more
Add your answer

Q1. High-level design - Design a chat-based application like WhatsApp with only user-to-user chat feature (no group chats). Explain and draw out the E2E design by mentioning all the components and design decis...read more
Add your answer

Q1. Hiring Manager - basic questions like why Razorpay, what are your career goals, what does career growth look like for you, etc.
Add your answer