KFintech Senior Data Engineer Interview Questions and Answers

Q1. Basics of SQL python
Add your answer

Python sql skills were tested and candidates are selected

Q1. Spark optimisation
Add your answer

Q1. What are the best and worst solutions for the coding problem "Longest Substring Without Repeating Characters," including a detailed explanation of each solution along with their time and space complexity?
Ans. 
The Longest Substring Without Repeating Characters problem involves finding the length of the longest substring without any repeating characters.
• Best solution: Sliding Window approach with HashSet to track unique characters. Time complexity O(n), space complexity O(min(n, m)) where n is the length of the string and m is the size of the character set.

• Worst solution: Brute force approach checking all substrings for uniqu...read more
Answered by AI
Add your answer

Q1. Questions regarding Redis and cache eviction policies, and how would you implement a low-level design for the Least Recently Used (LRU) cache algorithm?
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

Was of 1 hour, got asked about 3 sum as well as a medium level problem

Q1. Releated to IOS
Add your answer
Q2. About multithreading, deep dive
Add your answer

A test that covers all fundamental topics, including networking, object-oriented programming (OOP), and data structures and algorithms (DSA).

Q1. Write code for quick sort
Add your answer
Q2. Puzzle
Add your answer

Q1. System design basics
Add your answer
Q2. Java 8 stream api code
Add your answer
Q3. Current project
Add your answer

Q1. Only arrogance related stuff
Add your answer
Q2. Only arrogance related stuff happened
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