Talentica Software Associate Data Engineer Interview Questions and Answers

Round duration - 70 Minutes
Round difficulty - Hard

Q1. 
Candies Distribution Problem Statement
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...read more
Ans. 
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
• Create an array to store the minimum candies required for each student.

• Iterate through the students' ratings array to determine the minimum candies needed based on the adjacent ratings.

• Consider both left-to-right and right-to-left passes to ensure fair distribution.

• Keep track of the total candies dist...read more
Answered by AI
Add your answer
Q2. 
Merge Sort Problem Statement
You are given a sequence of numbers, ARR. Your task is to return a sorted sequence of ARR in non-descending order using the Merge Sort algorithm.
Explanation:
The Merge Sort...read more
Ans. 
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
• Use Divide and Conquer approach to recursively divide the input array into two halves.

• Merge the sorted halves to produce a completely sorted array.

• Ensure the implementation handles the constraints specified in the problem statement.

• Example: For input [3, 1, 4, 1, 5], the output should be [1, 1, 3, 4, 5].
Answered by AI
Add your answer

Coding Rount
DSA Round + Puzzle
SQL + Project Discussion
JS

Q1. What are BASE properties
Ans. 
BASE properties describe a model for distributed systems emphasizing availability and partition tolerance over strict consistency.
• B - Basically Available: Systems guarantee availability, meaning they respond to requests even if some nodes are down.

• A - Soft state: The state of the system may change over time, even without new input, due to eventual consistency.

• E - Eventually consistent: The system will become consistent...read more
Answered by AI
Add your answer
Q2. Explain the workflow of a Transaction in DBMS
Ans. 
A transaction in DBMS is a sequence of operations performed as a single logical unit of work, ensuring data integrity.
• 1. Transaction Initiation: A transaction begins with a request to perform a database operation, like inserting a record.

• 2. Execution: The DBMS executes the operations defined in the transaction, such as INSERT, UPDATE, or DELETE.

• 3. Logging: Changes are logged in a transaction log to ensure recovery in c...read more
Answered by AI
Add your answer

2 medium hard level questions. We just have to code and explain it. Platform doesn't have compilers.

Good Knowledge of DSA is required

Q1. Given an array Reverse array
Add your answer
Q2. Giaven a string Reverse string
Add your answer
Q3. Given array find sum of all elements
Add your answer

Q1. What is singleton design pattern
Ans. 
Singleton design pattern restricts the instantiation of a class to a single instance and provides global access to it.
• Used when only one instance of a class is required throughout the application

• Provides a global point of access to the instance

• Implemented using a private constructor, static method, and static variable

• Example: Logger class, Database connection class
Answered by AI
Add your answer
Q2. C# LINQ queries for group and sum data from data table
Ans. 
C# LINQ queries for group and sum data from data table
• Use GroupBy() method to group data based on a specific column

• Use Sum() method to calculate the sum of a column

• Use Select() method to select the required columns
Answered by AI
Add your answer
Q3. Solid design principles
Ans. 
Solid design principles are a set of guidelines for writing maintainable and scalable code.
• Single Responsibility Principle (SRP) - each class should have only one responsibility

• Open/Closed Principle (OCP) - classes should be open for extension but closed for modification

• Liskov Substitution Principle (LSP) - subclasses should be able to replace their parent classes without affecting the program's correctness

• Interface Se...read more
Answered by AI
Add your answer
Q4. OOPS concepts ,like association and all
Add your answer

Basic aptitude test and was unproctored

Q1. It was a online technical round
Add your answer