EPAM Systems Senior Software Development Engineer Interview Questions and Answers

Q1. What is Dependency Injection?
Add your answer
Q2. How does angular components communicate with each other?
Add your answer
Q3. How can you optimize a stored procedure in MSSQL?
Add your answer
Q4. What is Kestrel in .net Core?
Add your answer

It was an aptitute round and 2 coding questions was there

Q1. Tell me about yourself
Add your answer
Q2. We had discussion on projects than mentioned in my resume
Add your answer
Q3. Then he moved to DSA question in which he told to how you will insert node in doubly linked list ,I answered all correctly he appreciated me also but after 5 min one person came and told you can go . I was...read more
Add your answer

Q1. What is Dependency Injection?
Ans. 
Dependency Injection is a design pattern in which components are given their dependencies rather than creating them internally.
• Allows for easier testing by providing mock dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Examples: Constructor injection, Setter injection, Interface injection
Answered by AI
Add your answer
Q2. How to handle exception in java
Ans. 
In Java, exceptions can be handled using try-catch blocks to catch and handle specific exceptions.
• Use try-catch blocks to catch exceptions and handle them gracefully

• Use multiple catch blocks to handle different types of exceptions

• Use finally block to execute code regardless of whether an exception is thrown or not

• Throw custom exceptions using throw keyword
Answered by AI
Add your answer

Q1. In Java8, different between flatmap and map
Ans. 
map transforms each element in a stream, while flatMap transforms each element into multiple elements
• map applies a function to each element in a stream and returns a new stream of the results

• flatMap applies a function that returns a stream for each element in the original stream, then flattens the streams into a single stream

• Example: map - stream.map(x -> x * x), flatMap - stream.flatMap(str -> Arrays.stream(str.split(
Answered by AI
Add your answer
Q2. How to handle the ConcureentModificationException
Ans. 
ConcurrentModificationException occurs when a collection is modified while iterating over it.
• Use Iterator to iterate over the collection instead of foreach loop.

• If modification is necessary, use Iterator's remove() method instead of collection's remove() method.

• Consider using synchronized collections or ConcurrentHashMap to avoid ConcurrentModificationException.
Answered by AI
Add your answer

Q1. Java programs related to strings
Add your answer
Q2. Collections question in java
Add your answer

OS questions, locking and threads etc

Basic questions on Linked list

Q1. IPC mechanisms in OS, process management
Ans. 
IPC mechanisms in OS facilitate communication between processes, while process management involves creating, scheduling, and terminating processes.
• IPC mechanisms include shared memory, message passing, and sockets.

• Shared memory allows processes to share a portion of memory for communication.

• Message passing involves sending and receiving messages between processes.

• Sockets enable communication between processes over a ne...read more
Answered by AI
Add your answer
Q2. Fibonacci series code
Add your answer

Q1. What challenging work you did in previous company
Ans. 
Implemented a real-time data processing system to handle large volumes of data efficiently.
• Designed and implemented a distributed system using Apache Kafka for real-time data processing.

• Optimized data processing algorithms to handle large volumes of data without impacting performance.

• Collaborated with cross-functional teams to ensure seamless integration of the system with existing infrastructure.
Answered by AI
Add your answer

Q1. All the questions were from SQL server.
Add your answer
Q2. How to get 3rd highest salary ?
Ans. 
To get the 3rd highest salary, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query to select distinct salaries in descending order.

• Use the 'LIMIT' keyword to limit the results to 3.

• Use the 'OFFSET' keyword to skip the first 2 highest salaries.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q3. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1,1]
Ans. 
The inner join of two tables with duplicate values results in a combined set of common values.
• Inner join combines rows from both tables where the key columns match

• In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables
Answered by AI
Add your answer
Q4. SSIS Package creation.
Add your answer
Q5. Latest project explanation
Ans. 
Developed a web application for tracking and managing project tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express

• Utilized MongoDB for database management

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer

Q1. What is difference between SQL and NoSQL
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores

• SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages

• SQL databases are vertically scalable, NoSQL databases are horizontally scalable

• SQL databa...read more
Answered by AI
Add your answer
Q2. Why is NoSQL better then SQL
Ans. 
NoSQL is better for handling unstructured data, providing scalability and flexibility.
• NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.

• NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.

• NoSQL databases offer more flexibility in terms of data model, allowing fo...read more
Answered by AI
Add your answer
Q3. Explain the data pipeline you have worked on.
Ans. 
Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.
• Used Apache Kafka for real-time data streaming

• Utilized Apache Spark for data processing and analysis

• Implemented data transformations and aggregations using Scala

• Stored processed data in a data warehouse like Amazon Redshift

• Built monitoring and alerting systems to ensure data pipeline reliability
Answered by AI
Add your answer
Q4. Managing team
Add your answer
Q5. What will you do if you have conflict with your manager.
Ans. 
I would address the conflict directly and professionally, seeking to understand the root cause and find a mutually beneficial solution.
• Schedule a private meeting with the manager to discuss the conflict

• Listen actively to the manager's perspective and express your own calmly

• Seek to find common ground and propose potential solutions

• If necessary, involve HR or a mediator to help resolve the conflict
Answered by AI
Add your answer
Q6. What do you love to do when you are free
Ans. 
I love to spend my free time hiking, reading, and trying out new recipes in the kitchen.
• Hiking in the mountains or local trails

• Reading fiction and non-fiction books

• Experimenting with new recipes and cooking techniques
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Family background
Add your answer

Q1. Ask for basic dot net questions
Add your answer

Fibonacci series and program to find the max number in list

Q1. What is oops and explain each of the terms
Ans. 
OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.
• OOPs consists of four main principles: Inheritance, Encapsulation, Abstraction, and Polymorphism.

• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation refers to the bundling of data and methods that operate on the data into a single unit.

• Abstraction focuses on hiding the int...read more
Answered by AI
Add your answer
Q2. What is list, dictionary, set and tuple and difference between them
Ans. 
List, dictionary, set, and tuple are data structures in Python with different characteristics and use cases.
• List: ordered collection of items, mutable (can be changed), represented by square brackets []

• Dictionary: unordered collection of key-value pairs, mutable, represented by curly braces {}

• Set: unordered collection of unique items, mutable, represented by curly braces {}

• Tuple: ordered collection of items, immutable ...read more
Answered by AI
Add your answer