EPAM Systems Interview Questions and Answers

My current day-to-day tasks involve designing and implementing data pipelines, optimizing data storage and retrieval, and collaborating with cross-functional teams.

• Designing and implementing data pipelines to extract, transform, and load data from various sources

• Optimizing data storage and retrieval processes for efficiency and scalability

• Collaborating with cross-functional teams to understand data requirements and del...read more

The end-to-end project architecture involves designing and implementing the entire data pipeline from data ingestion to data visualization.

• Data ingestion: Collecting data from various sources such as databases, APIs, and files.

• Data processing: Cleaning, transforming, and aggregating the data using tools like Apache Spark or Hadoop.

• Data storage: Storing the processed data in data warehouses or data lakes like Amazon S3 ...read more

Use Spark (Databricks) notebooks to migrate 1000s of tables efficiently.

• Utilize Spark's parallel processing capabilities to handle large volumes of data

• Leverage Databricks notebooks for interactive data exploration and transformation

• Automate the migration process using scripts or workflows

• Optimize performance by tuning Spark configurations and cluster settings

Understanding SQL joins is crucial for data retrieval and analysis in relational databases.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id.

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id.

• RIGHT JOIN: Returns all records from the right table and matched rec...read more

Seeking new challenges and opportunities for growth in a more dynamic environment.

• Desire for new challenges and learning opportunities

• Seeking a more dynamic work environment

• Looking to expand skill set and experience

• Interested in working on cutting-edge technologies

• Seeking better career advancement prospects

I expect EPAM to provide challenging projects, opportunities for growth, a collaborative work environment, and support for continuous learning.

• Challenging projects that allow me to utilize my skills and knowledge

• Opportunities for professional growth and advancement within the company

• A collaborative work environment where teamwork is valued

• Support for continuous learning through training programs and resources

Yes, I am willing to relocate for the right opportunity. I can join the company within 4 weeks.

• Willing to relocate for the right opportunity

• Can join within 4 weeks

• Open to discussing relocation assistance if needed

The code demonstrates exception handling, resulting in an output of 2 due to incrementing variable I in catch and finally blocks.

• The code throws a NullPointerException which is caught in the catch block.

• In the catch block, I is incremented from 0 to 1.

• The finally block executes regardless of exception, incrementing I from 1 to 2.

• The final output printed is the value of I, which is 2.

Identify and print duplicate names from a string array that start with 'B'.

• 1. Create a string array with names, e.g., ['Bob', 'Alice', 'Bill', 'Bob', 'Bobby'].

• 2. Use a HashMap or dictionary to count occurrences of each name.

• 3. Iterate through the array and check for names starting with 'B'.

• 4. Print names that have a count greater than 1, e.g., 'Bob' and 'Bill' if they are duplicates.

TestNG annotations are used to define test methods, configuration, and grouping in automated testing.

• @Test: Marks a method as a test method. Example: @Test public void testMethod() {}

• @BeforeSuite: Executes before the entire test suite. Example: @BeforeSuite public void setupSuite() {}

• @AfterSuite: Executes after the entire test suite. Example: @AfterSuite public void teardownSuite() {}

• @BeforeTest: Executes before any te...read more

In a runner class, tags help organize and filter test cases for execution in automation testing frameworks.

• Tags are used to categorize tests, e.g., @smoke, @regression.

• They allow selective execution, e.g., running only @smoke tests.

• Tags can be combined, e.g., @regression and @critical.

• In Cucumber, tags are specified in the feature file, e.g., @login.

• In TestNG, tags can be implemented using groups in XML configuration.

Regression testing checks existing features after changes, while smoke testing verifies basic functionality post-deployment.

• Regression testing ensures that new code changes do not adversely affect existing functionalities.

• Smoke testing is a preliminary test to check if the basic functions of an application work.

• Example of regression testing: After a new feature is added, testing all existing features to ensure they sti...read more

Custom exceptions enhance error handling in automation testing, while StaleElementReferenceException indicates a DOM element is no longer valid.

• Custom Exceptions: These are user-defined exceptions that allow developers to create specific error handling scenarios tailored to their application needs.

• Common Exceptions: In automation testing, I've encountered exceptions like NoSuchElementException, TimeoutException, and St...read more

Waits in automation testing manage timing issues between code execution and web element availability.

• Implicit Wait: Sets a default wait time for the entire session. Example: driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);

• Explicit Wait: Waits for a specific condition to occur before proceeding. Example: WebDriverWait wait = new WebDriverWait(driver, 10);

• Fluent Wait: Similar to explicit wait but allows p...read more

BDD is a software development approach that enhances collaboration between developers, testers, and non-technical stakeholders.

• Originated from Test Driven Development (TDD) to improve communication.

• Focuses on defining behavior in simple language, often using Gherkin syntax.

• Encourages collaboration through examples and scenarios, e.g., 'Given a user is logged in, when they click logout, then they should see the login pa...read more

Best practices for writing PowerShell scripts

• Use clear and descriptive variable names

• Comment your code to explain complex logic

• Handle errors gracefully with try/catch blocks

• Use functions to modularize your script

• Avoid hardcoding values whenever possible

To create a Private Endpoint for Azure Key Vaults, you need to configure a private link service.

• Navigate to the Azure portal and search for 'Key Vaults'.

• Select the Key Vault you want to create a Private Endpoint for.

• In the Key Vault settings, go to 'Private endpoint connections' and click on 'Add'.

• Choose the subscription, resource group, and private DNS zone for the Private Endpoint.

• Review and create the Private Endpoi...read more

AKS allows for network configuration during creation and provides options for managing it.

• During creation of AKS, network configuration options include specifying virtual network, subnet, and network policies.

• Network configuration can be managed through Azure portal, Azure CLI, or ARM templates.

• AKS supports network policies like Azure CNI, Kubenet, and Calico for network security and isolation.

• Network configuration can...read more