EPAM Systems Interview Questions, Process, and Tips

Two coding questions on codility. One was easy and second medium. 10 MCQ questions on Big Data related technologies.

Q1. This round was scheduled for 1.5 hours and lasted 1 hrs 5 minutes. Discuss about projects done for previous company and architecture of the same.
Add your answer
Q2. Write code for printing duplicate numbers in a list.
Ans. 
Code to print duplicate numbers in a list.
• Iterate through the list and keep track of the count of each number using a dictionary.

• Print the numbers that have a count greater than 1.
Answered by AI
View 2 more answers
Q3. Scala traits, higher order functions, currying
Add your answer
Q4. Connecting Spark to Azure SQL Database.
Ans. 
Spark can connect to Azure SQL Database using JDBC driver.
• Download and install the JDBC driver for Azure SQL Database.

• Set up the connection string with the appropriate credentials.

• Use the JDBC API to connect Spark to Azure SQL Database.

• Example: val df = spark.read.jdbc(jdbcUrl, tableName, connectionProperties)

• Ensure that the firewall rules for the Azure SQL Database allow access from the Spark cluster.
Answered by AI
Add your answer
Q5. Elaboration of Spark optimization techniques. Types of transformations, shuffling.
Ans. 
Spark optimization techniques include partitioning, caching, and using appropriate transformations.
• Partitioning data can improve performance by reducing shuffling.

• Caching frequently used data can reduce the need for recomputation.

• Transformations like filter, map, and reduceByKey can be used to optimize data processing.

• Shuffling can be minimized by using operations like reduceByKey instead of groupByKey.

• Broadcasting sma...read more
Answered by AI
Add your answer
Q6. Difference between cache and persist, repartition and coalesce.
Ans. 
Cache and persist are used to store data in memory. Repartition and coalesce are used to change the number of partitions.
• Cache stores the data in memory for faster access while persist allows the user to choose the storage level.

• Repartition increases the number of partitions while coalesce decreases the number of partitions.

• Cache and persist are transformations while repartition and coalesce are actions.

• Cache and persi...read more
Answered by AI
Add your answer
Q7. Spark components and job execution steps.
Add your answer
Q8. Hive types of tables and difference between them
Ans. 
Hive has two types of tables - Managed and External. Managed tables are managed by Hive, while External tables are managed outside of Hive.
• Managed tables are created using 'CREATE TABLE' command and data is stored in Hive's warehouse directory

• External tables are created using 'CREATE EXTERNAL TABLE' command and data is stored outside of Hive's warehouse directory

• Managed tables are deleted when the table is dropped, whi...read more
Answered by AI
Add your answer

Q1. This was the final round of 1 hour and lasted 45 minutes.I was asked technical questions along with last companies project description.
Add your answer
Q2. Discuss project and it's architecture.
Ans. 
Developed a data pipeline to process and analyze customer behavior data.
• Used Apache Kafka for real-time data streaming

• Implemented data processing using Apache Spark

• Stored data in Hadoop Distributed File System (HDFS)

• Used Tableau for data visualization
Answered by AI
Add your answer
Q3. Write code to print reverse of a sentence word by word.
Ans. 
Code to print reverse of a sentence word by word.
• Split the sentence into words using space as delimiter

• Store the words in an array

• Print the words in reverse order
Answered by AI
Add your answer
Q4. Difference between RDD, Dataframe, Dataset.
Ans. 
RDD, Dataframe, and Dataset are data structures in Apache Spark with different characteristics and functionalities.
• RDD (Resilient Distributed Datasets) is a fundamental data structure in Spark that represents an immutable distributed collection of objects. It provides low-level APIs for distributed data processing and fault tolerance.

• Dataframe is a distributed collection of data organized into named columns. It is simi...read more
Answered by AI
Add your answer
Q5. Lineage graph, DAG formation, RDDs characteristics
Add your answer

Aptitude test was good ,level was good , Data Base questions was there. Above to average .

Q1. How can you count the google pages shown on searching result of Google SE.?
Ans. 
To count the Google pages shown on search result, you can look at the page numbers at the bottom of the search results.
• Scroll to the bottom of the search results page to see the page numbers.

• Each page number represents a different page of search results.

• Count the total number of page numbers to determine the total number of Google pages shown.
Answered by AI
Add your answer
Q2. Can you explain the chat window coding?
Ans. 
Chat window coding involves creating a user interface for real-time messaging between users.
• Use HTML, CSS, and JavaScript to create the chat window layout and design.

• Implement WebSocket or AJAX for real-time communication between users.

• Store chat messages in a database for retrieval and display.

• Include features like message notifications, emojis, and file sharing.

• Consider security measures like encryption and authentic
Answered by AI
Add your answer
Q3. Basics Questions from SQL.
Add your answer
Q4. Write Selenium Code for automation for Gmail ?
Ans. 
Automate Gmail login and send email using Selenium WebDriver
• Create a new WebDriver instance

• Navigate to Gmail login page

• Enter username and password

• Click on the login button

• Compose and send an email
Answered by AI
Add your answer

Q1. Explain about the company that you have gained knowledge through google?
Add your answer
Q2. You are from Kanpur(up),Why Kanpur Central Railway station is famous for ?
Ans. 
Kanpur Central Railway station is famous for being one of the busiest and largest railway stations in India.
• One of the busiest and largest railway stations in India

• Serves as a major transportation hub for the region

• Connects Kanpur to various parts of the country

• Historical significance as an important railway junction
Answered by AI
Add your answer
Q3. Tell me something about your self?
Add your answer
Q4. You have mentioned that you have Php and Website design knowledge, Can you make website ?
Add your answer

Nothing

Nothing nothing nothing nothing nothing nothing nothing

Q1. What are microservices pattern?
Ans. 
Microservices pattern is an architectural style that structures an application as a collection of small, independent services.
• Microservices are independently deployable and scalable.

• Each microservice focuses on a specific business capability.

• Communication between microservices is usually done through APIs.

• Microservices can be developed using different programming languages and technologies.

• Examples of companies using m
Answered by AI
Add your answer
Q2. What is spring boot?
Ans. 
Spring Boot is a framework for building standalone, production-grade Spring-based applications.
• Spring Boot simplifies the process of creating and deploying Spring-based applications.

• It provides a set of pre-configured features and dependencies that can be easily integrated into the application.

• It includes an embedded web server, which eliminates the need for deploying the application to a separate server.

• It supports va...read more
Answered by AI
Add your answer

Q1. Android related questions
Add your answer
Q2. Kotlin questions
Add your answer

Q1. About Project delivery
Add your answer
Q2. Senior Management Reporting
Add your answer

Case study of a banking System

Q1. Android Basic & Advanced Questions
Add your answer
Q2. Love Coding test in the interview
Add your answer