DataTrained Information Technology Support Engineer Interview Questions and Answers

Python technical SQL basic

Q1. Check if string is palindrome
Ans. 
Check if a string is the same forwards and backwards
• Iterate through the string from both ends and compare characters

• Use built-in functions like reverse() to check for palindrome

• Ignore spaces and punctuation when checking for palindrome
Answered by AI
Add your answer

Two dynamic programming challenges at the hard level on LeetCode and 10 medium-level SQL challenge.

Two Medium DSA problem to solve

Q1. Design scalable Streaming pipeline and
Ans. 
Design a scalable streaming pipeline for processing large volumes of data.
• Use a distributed streaming framework like Apache Kafka or Apache Flink for real-time data processing.

• Implement data partitioning and parallel processing to handle high data throughput.

• Utilize cloud services like AWS Kinesis or Google Cloud Pub/Sub for scalability and reliability.

• Include fault tolerance mechanisms like checkpointing and data repl...read more
Answered by AI
Add your answer

Q1. LLD round , write classes and its methods
Add your answer

Q1. Salary and benefits discussion
Add your answer

Q1. Basics of js and react
Add your answer
Q2. What are closures and give an example
Ans. 
Closures are functions that have access to variables from their outer scope even after the outer function has finished executing.
• Closures are created when a function is defined within another function and has access to the outer function's variables.

• They can access variables from the outer function even after the outer function has returned.

• Closures are commonly used in event handlers and callbacks in JavaScript.
Answered by AI
Add your answer
Q3. What is event loop and features of es5
Ans. 
Event loop is a mechanism that allows JavaScript to perform non-blocking operations by handling asynchronous events.
• Event loop is responsible for executing code, collecting and processing events, and executing queued sub-tasks.

• ES5 features include strict mode, JSON object, Array methods like forEach, map, filter, and reduce, and Object.create method.

• ES5 also introduced new methods for manipulating strings, such as trim
Answered by AI
Add your answer

Q1. General management round and past experience
Add your answer

Coding test around front end using react

Basic aptitude questions

Linked list, array, tree and graph questions

Round duration - 120 minutes
Round difficulty - Easy

It was a mix of mathematical aptitude, logical ability, and puzzles along with 2 programming questions of easy and medium level. Time was enough and no sectional time was present. 1-2 MCQs on SQL were also present.

This round was immediately followed by an SHL aptitude test which was basically a quick limited time check of your verbal ability and math because many questions were to be done in 1 hour.

Q1. 
Boolean Matrix Transformation Challenge
Given a 2-dimensional boolean matrix mat of size N x M, your task is to modify the matrix such that if any element is 1, set its entire row and column to 1. Specifi...read more
Ans. 
Modify a boolean matrix such that if any element is 1, set its entire row and column to 1.
• Iterate through the matrix and mark rows and columns to be modified

• Use additional arrays to keep track of rows and columns to be modified

• Update the matrix in-place based on the marked rows and columns
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

It was an online video interview round on HackerEarth with simultaneous code option. It was mostly justifying your resume in the first 15 minutes. After that OOPS was majorly asked. Basics of programming including questions on STL were asked. A class which required inheritance was asked by the interviewer to write. I was helped by the interviewer if i got stuck somewhere, Some questions on implementation of hashmaps and priority queues were also asked. A puzzle was asked which luckily struct to me at that moment.