EPAM Systems Servicenow Developer Interview Questions, Process, and Tips

Q1. What is the different between =, ==, ===?
Ans. 
The different between =, ==, === is related to assignment, equality, and strict equality in programming.
• = is used for assignment in programming languages.

• == is used for equality comparison, it checks if two values are equal.

• === is used for strict equality comparison, it checks if two values are equal in both value and data type.
Answered by AI
Add your answer
Q2. Writ a quay that should retrieve all the the columns but show only 10 records and ordered by name
Ans. 
Use SQL query to retrieve all columns, show only 10 records, and order by name
• Use SELECT * to retrieve all columns

• Use LIMIT 10 to show only 10 records

• Use ORDER BY name to order the results by name
Answered by AI
Add your answer

Q1. Regarding General ServiceNow Functionality and Scenario based Questions
Add your answer

Q1. Ticketing system design
Ans. 
Ticketing system design involves creating a platform for users to submit, track, and resolve issues or requests.
• Design a user-friendly interface for submitting tickets

• Implement a system for assigning tickets to appropriate teams or individuals

• Include features for tracking ticket status and communication with users

• Consider scalability and performance of the system

• Integrate with other tools or systems for seamless workfl
Answered by AI
Add your answer
Q2. Aws ec2 and jenkins
Add your answer

Q1. Asp.net, C#, Coding questions
Add your answer

Q1. Salary discussion
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

2 Programing Questions and 30 MCQs. 
Programing questions were medium with one being array manipulation and other being graph based. 

MCQ were from OOPs concepts, SQL, Operating System and Network, prepare in depth knowledge for all the topics.

Q1. 
Count Pairs Problem Statement
You are given an array A of length N consisting only of integers. Additionally, you are provided with three integers X, Y and SUM. Your task is to count the number of pairs (...read more
Ans. 
Using HashMap or self balancing BST for fastest result.
Answered Anonymously
Add your answer
Q2. 
Longest Substring Without Repeating Characters Problem Statement
Given a string S of length L, determine the length of the longest substring that contains no repeating characters.
Example:
Input:
"abac...read more
Ans. Brute Force
In the brute force approach, we will use two nested loops. The outer loop is used to select the starting index of the substring and the inner loop is used to fix the ending index of the substring. After selecting the substring, we will use another loop (or a method) to check whether the substring contains all unique characters or not using a HashSet.
Space Complexity: O(n)Explanation:
O(L), where L is the len...read more
Answered Anonymously
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Questions on SQL and DBMS were asked in this round

Q1. What are the ACID properties in DBMS?
View 1 more answer
Q2. Can you explain the different levels of data abstraction in a DBMS?
Add your answer
Q3. What are constraints in SQL?
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

HR round was pretty much a casual conversation about why optum, work location, joining availablity and what qualities you would like to highlight about yourself.

Q1. Why do you want to work at Optum, and what qualities would you like to highlight?
Ans. 
Tip 1 : Go through wiki page or google about the working of the company
Tip 2 : Qualities should more aligned to the company's values.
Tip 3 : Show your interest in working with the organisation and how will you contribute to the team.
Answered Anonymously
Add your answer

Not that much difficult

Data structure

Q1. Normal questions like where do you see yourself
View 1 more answer

Medium label coding questions and some MCQ questions related to IT

Q1. Mainly focus on DSA, project explanation , OOPs concept, DBMS
Add your answer

Q1. Also focus on DSA and some puzzle questions
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

In this round, the interviewer asked me 2 coding questions , the first one was related to Simple Hashing and the second one was to implement Kadane's Algorithm. I coded both the solutions in the given time and at the end was also asked some questions revolving around OOPS and C#.

Q1. 
Find All Pairs Adding Up to Target
Given an array of integers ARR of length N and an integer Target, your task is to return all pairs of elements such that they add up to the Target.
Input:
The first line ...read more
Add your answer
Q2. 
Maximum Subarray Sum Task
Given an array or list ARR consisting of N integers, your objective is to compute the maximum possible sum obtainable from a non-empty subarray (a contiguous sequence) within thi...read more
Add your answer
Q3. What do you mean by data encapsulation?
Add your answer
Q4. What are the different ways in which a method can be overloaded in C#?
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This round was preety much mixed and had questions from LINQ , .NET framework, DBMS, OOPS and Design Patterns.

Q1. What is LINQ, and what are the advantages of using LINQ in a Dataset?
Add your answer
Q2. What are the differences between LINQ and Stored Procedures?
Add your answer
Q3. What is an Expression Tree in LINQ?
Add your answer
Q4. What is the difference between a trigger and a procedure in a Database Management System (DBMS)?
Add your answer
Q5. What are abstraction and data encapsulation in object-oriented programming?
Add your answer
Q6. What are the types of design patterns in Java?
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This is a cultural fitment testing round. HR was very frank and asked standard questions. Then we discussed about my
role.

Q1. What is something about you that is not included in your resume?
Add your answer