Open Financial Technologies Private Limited Software Developer Interview Questions and Answers

In round 1 we could only use Java

Q1. Interviewers are very friendly. Mostly the questions were based on SQL, dsa
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. 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?
Add your answer
Q4. What is the difference between SQL and NoSQL?
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.
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

Q1. Pandas based questions
Add your answer
Q2. Sql with group by
Add your answer

Q1. Tech concepts and algo
Add your answer

Q1. Startup mindset
Add your answer

Q1. Speed and quality
Add your answer

Q1. Project questions
Add your answer
Q2. Coding questions
Add your answer

Profit and Loss, Numbers questions

Java related questions

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