Premium Employer

i

This company page is being actively managed by Hexaware Technologies Team. If you also belong to the team, you can get access from here

Hexaware Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Hexaware Technologies ETL Testing Engineer Interview Questions and Answers

Updated 12 Feb 2024

Hexaware Technologies ETL Testing Engineer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How do you get the sum of consecutive numbers in a table
  • Ans. 

    To get the sum of consecutive numbers in a table, you can use SQL queries with aggregate functions like SUM() and window functions like ROWS BETWEEN.

    • Use the SUM() function to calculate the sum of consecutive numbers in a column.

    • Use window functions like ROWS BETWEEN to define the range of consecutive numbers.

    • Combine the SUM() function with window functions to get the desired result.

    • Here's an example query: SELECT SUM(c...

  • Answered by AI

Skills evaluated in this interview

What people are saying about Hexaware Technologies

View All
lustrousradish
Verified Icon
2d
works at
Hexaware Technologies
Java or python
I am Devops engineer I want to learn a programming language so which should I choose Java or python Which one have better market value
Got a question about Hexaware Technologies?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Dec 2024.

Round 1 - Aptitude Test 

Basic quant and reasoning questions
Selenium MCQ
Java programs with MCQ

Round 2 - Technical 

(23 Questions)

  • Q1. Tell me about yourself
  • Q2. Where you initialise driver
  • Ans. 

    The driver is typically initialized in the setup method of a test automation framework.

    • Driver initialization is usually done in a setup method before test execution.

    • Commonly used methods for driver initialization include WebDriverManager, System.setProperty, and driver instantiation.

    • Example: WebDriverManager.chromedriver().setup();

  • Answered by AI
  • Q3. Driver is static or non static
  • Ans. 

    Driver can be both static and non-static depending on the context of its usage.

    • Driver class can be static if it is used to initiate the WebDriver instance in a test automation framework.

    • Driver class can be non-static if it is used as an instance variable within a test class.

    • Static driver can be accessed directly without creating an object of the class.

    • Non-static driver requires an object of the class to be created befo

  • Answered by AI
  • Q4. Difference between static and non static
  • Ans. 

    Static variables belong to the class itself, while non-static variables belong to instances of the class.

    • Static variables are shared among all instances of a class

    • Non-static variables are unique to each instance of a class

    • Static variables are initialized only once, at the start of the program

    • Non-static variables are initialized separately for each instance of the class

  • Answered by AI
  • Q5. Disadvantages of static and non static
  • Ans. 

    Static and non-static have their own disadvantages in QA automation testing.

    • Static methods cannot be overridden or inherited, making it difficult to create flexible test cases.

    • Non-static methods require an instance of the class to be created, which can lead to increased memory usage.

    • Static methods can lead to tight coupling between classes, making it harder to maintain and update the code.

    • Non-static methods may have de...

  • Answered by AI
  • Q6. Parallel execution in TestNG
  • Ans. 

    TestNG allows parallel execution of test cases to save time and improve efficiency.

    • TestNG provides the 'parallel' attribute in the testng.xml file to specify the level of parallelism for test execution.

    • Parallel execution can be achieved at the test level, class level, method level, or suite level.

    • TestNG also supports parallel execution of tests across multiple classes or suites using the 'parallel' attribute in the sui...

  • Answered by AI
  • Q7. Write the code for Parallel testing in TestNG
  • Ans. 

    Parallel testing in TestNG allows running tests concurrently for faster execution.

    • Use 'parallel' attribute in testng.xml file to specify parallel execution mode.

    • Set 'parallel' attribute to 'methods', 'classes', or 'tests' based on the level of parallelism needed.

    • Example: <suite name='MySuite' parallel='tests'>

    • Use 'thread-count' attribute to specify the number of threads to use for parallel execution.

  • Answered by AI
  • Q8. Difference between parallel methods and parallel tests
  • Ans. 

    Parallel methods run multiple methods concurrently within a single test, while parallel tests run multiple tests concurrently.

    • Parallel methods execute multiple methods within a single test class concurrently.

    • Parallel tests execute multiple test classes concurrently.

    • Parallel methods are useful for speeding up the execution of a single test, while parallel tests are useful for running multiple tests faster.

    • Example: Runni...

  • Answered by AI
  • Q9. Upload file using rest assured
  • Ans. 

    Use Rest Assured to upload a file

    • Use the given file path to create a File object

    • Use MultiPartSpecBuilder to build the request with the file

    • Send the request using Rest Assured's given(), when(), and post() methods

  • Answered by AI
  • Q10. Postman basic questions
  • Q11. Parameter for post method in postman
  • Ans. 

    The parameter for a POST method in Postman is typically sent in the request body.

    • Parameters are sent in the request body in key-value pairs

    • Parameters can be sent as form-data, x-www-form-urlencoded, or raw JSON

    • Example: {"key": "value"}

  • Answered by AI
  • Q12. BDD Framework cucumber
  • Q13. Cucumber execution process
  • Q14. How cucumber know step defination file placed
  • Ans. 

    Cucumber knows the step definition file based on the annotations provided in the feature files.

    • Cucumber uses annotations like @Given, @When, @Then to map steps in feature files to corresponding step definition methods.

    • Step definition files are typically placed in a separate package or directory within the project structure.

    • Cucumber scans the project directory for step definition files based on the package structure and

  • Answered by AI
  • Q15. Parameters used in cucumber
  • Ans. 

    Parameters used in cucumber are used to pass values to the step definitions in feature files.

    • Parameters are defined in feature files using < > syntax

    • Parameters can be passed to step definitions using Regular Expressions

    • Parameters can be used to make scenarios more reusable and dynamic

  • Answered by AI
  • Q16. Datatable in cucumber
  • Ans. 

    Datatable in Cucumber is used to pass multiple sets of data to a step definition in a scenario.

    • Datatables are defined using pipes (|) to separate values

    • Each row in the datatable represents a set of data passed to the step definition

    • Datatables can be used for parameterization and data-driven testing

  • Answered by AI
  • Q17. Have u created the testplan document when porject was started
  • Ans. 

    Yes, I have created the test plan document at the start of the project.

    • Yes, I always create a test plan document at the beginning of a project to outline the testing approach and strategy.

    • The test plan document includes details on scope, objectives, resources, schedule, and test cases.

    • It helps in ensuring that all stakeholders are aligned on the testing process and expectations.

    • For example, in my previous project, I cr...

  • Answered by AI
  • Q18. Testing cycle when project was on initial level
  • Ans. 

    During the initial testing cycle of a project, focus is on establishing test cases, setting up test environments, and identifying potential issues.

    • Creating test cases based on requirements

    • Setting up test environments

    • Identifying potential issues and risks

    • Executing test cases and reporting defects

    • Collaborating with developers to resolve issues

  • Answered by AI
  • Q19. Risk management and risk based testing
  • Q20. Which estimate technique you follow , if fibonacci then why it is in 1 2 3 5 8 13 ?? Not in 12345678
  • Ans. 

    Fibonacci sequence is a mathematical pattern where each number is the sum of the two preceding ones.

    • Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones.

    • The sequence starts with 1, 2, then each subsequent number is the sum of the two previous numbers (1+2=3, 2+3=5, 3+5=8, and so on).

    • This sequence is used in estimating because it reflects natural growth patterns found in natur

  • Answered by AI
  • Q21. What is testing matrix and automation ROI
  • Ans. 

    Testing matrix is a tool used to track test coverage and automation ROI is the return on investment from implementing automation testing.

    • Testing matrix is a visual representation of test cases, test scenarios, and their coverage across different platforms, browsers, devices, etc.

    • Automation ROI is the measure of the benefits gained from automation testing compared to the costs incurred in implementing and maintaining th...

  • Answered by AI
  • Q22. Cicd tool
  • Q23. Handle team ?
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. 

    I am a QA Automation Testing Engineer with 5 years of experience in creating and executing test cases for software applications.

    • Experienced in creating automated test scripts using tools like Selenium and Appium

    • Proficient in writing test cases, executing test plans, and reporting bugs

    • Skilled in analyzing test results and providing recommendations for improvements

    • Strong knowledge of Agile methodologies and continuous in

  • Answered by AI
  • Q2. Program to count the occurrence of vowels
  • Ans. 

    Program to count the occurrence of vowels in an array of strings

    • Iterate through each string in the array

    • For each string, iterate through each character and check if it is a vowel (a, e, i, o, u)

    • Increment a counter for each vowel found in the string

    • Repeat for all strings in the array and return the total count of vowels

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - No communication regarding feedback after the interview
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Job Portal and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Transformations
  • Q2. Project related questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is referential integrity
  • Ans. 

    Referential integrity ensures that relationships between tables are maintained in a database.

    • It ensures that foreign key values in one table match primary key values in another table.

    • It helps maintain consistency and accuracy of data in the database.

    • If a foreign key value is deleted or updated, the corresponding primary key value should also be updated or deleted to maintain integrity.

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Write a java program to remove duplicate element from arrays
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is cypress ,difference between cypress and selenium
  • Ans. 

    Cypress is a JavaScript-based end-to-end testing framework. It differs from Selenium in terms of architecture, ease of use, and speed.

    • Cypress is a JavaScript-based testing framework for web applications.

    • It provides a simple and intuitive API for writing tests.

    • Cypress runs directly in the browser and can access everything on the page.

    • Unlike Selenium, Cypress does not use WebDriver and has a different architecture.

    • Cypres...

  • Answered by AI
  • Q2. Cypress folder structure and and its assertions
  • Ans. 

    Cypress folder structure and its assertions

    • Cypress follows a specific folder structure for organizing test files

    • The 'fixtures' folder contains static data used in tests

    • The 'integration' folder contains the actual test files

    • The 'plugins' folder contains custom plugins and tasks

    • The 'support' folder contains reusable functions and commands

    • Cypress provides various assertions for validating test results

    • Common assertions inc...

  • Answered by AI
  • Q3. What is assertions
  • Ans. 

    Assertions are statements that verify the expected behavior of a software application during testing.

    • Assertions are used to validate whether a certain condition is true or false.

    • They help in identifying bugs and ensuring the correctness of the software.

    • Assertions can be used to check the values of variables, compare expected and actual results, or verify the presence of certain elements.

    • Examples of assertions include a...

  • Answered by AI
  • Q4. Api testing using cypress
  • Ans. 

    Cypress is a powerful tool for API testing, allowing for easy automation and assertion of API endpoints.

    • Cypress provides a simple and intuitive syntax for writing API tests

    • It supports making HTTP requests and asserting responses

    • Cypress allows for easy mocking and stubbing of API calls

    • It provides detailed logs and error messages for debugging

    • Cypress integrates well with other testing frameworks and tools

  • Answered by AI
  • Q5. Architecture about cypress
  • Ans. 

    Cypress is a JavaScript-based end-to-end testing framework that runs directly in the browser.

    • Cypress allows for easy and fast testing of web applications.

    • It provides a rich set of APIs for interacting with elements and making assertions.

    • Cypress runs directly in the browser, eliminating the need for Selenium or other external drivers.

    • It supports modern JavaScript frameworks like React, Angular, and Vue.

    • Cypress provides ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Previous project experience
Round 2 - One-on-one 

(1 Question)

  • Q1. Jenkins Jira and Banking operations
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. What is your Name??
  • Q2. How is Python??
  • Ans. 

    Python is a versatile and powerful programming language known for its simplicity and readability.

    • Python is widely used for web development, data analysis, artificial intelligence, and automation.

    • It has a large standard library and a vibrant community of developers.

    • Python code is easy to read and write, making it a great choice for beginners and experienced programmers alike.

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. What is Network ??
  • Ans. 

    A network is a collection of computers, servers, mainframes, network devices, and other devices connected to one another to share data and resources.

    • Networks can be classified based on their size (LAN, WAN, MAN)

    • Networks can be wired (Ethernet, fiber optic) or wireless (Wi-Fi, Bluetooth)

    • Networks can be used for sharing files, printers, internet access, and communication

    • Examples of networks include the internet, company

  • Answered by AI
  • Q2. How is software testing
  • Ans. 

    Software testing is the process of evaluating a software application to ensure it meets specified requirements and functions correctly.

    • Software testing involves identifying defects or bugs in the software.

    • It helps in ensuring the quality and reliability of the software.

    • Types of software testing include unit testing, integration testing, system testing, and acceptance testing.

  • Answered by AI
  • Q3. How is command system network?
  • Ans. 

    Command system network is a centralized system that controls and coordinates various devices and processes.

    • Command system network typically consists of a central server or controller that communicates with multiple devices or subsystems.

    • It allows for centralized monitoring, control, and coordination of various processes or equipment.

    • Examples include industrial automation systems, smart home systems, and military comman

  • Answered by AI
  • Q4. What is server???
  • Ans. 

    A server is a computer or software program that provides functionality for other programs or devices, often over a network.

    • A server stores and manages data, files, or applications for clients to access remotely.

    • Servers can provide services such as email, web hosting, file sharing, and database management.

    • Examples of servers include web servers like Apache or Nginx, email servers like Microsoft Exchange, and file server

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - please job

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Coding Test 

I was asked to write
1. java program for move positive numbers first and negative numbers last
2. java program to reverse the words in a string without using split method.
3. Selenium coding questions.

Interview Preparation Tips

Topics to prepare for Publicis Sapient Qa Automation Testing Engineer interview:
  • Java
  • Selenium

Hexaware Technologies Interview FAQs

How many rounds are there in Hexaware Technologies ETL Testing Engineer interview?
Hexaware Technologies interview process usually has 1 rounds. The most common rounds in the Hexaware Technologies interview process are Technical.

Tell us how to improve this page.

Hexaware Technologies ETL Testing Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Hexaware Technologies Experience the impact across your digital ecosystem and beyond.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
DXC Technology Interview Questions
3.7
 • 808 Interviews
Mphasis Interview Questions
3.4
 • 802 Interviews
Nagarro Interview Questions
4.0
 • 777 Interviews
View all

Hexaware Technologies ETL Testing Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Software Engineer
3.8k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

System Analyst
3k salaries
unlock blur

₹7 L/yr - ₹29 L/yr

Software Engineer
2.9k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Senior Executive
2k salaries
unlock blur

₹0.8 L/yr - ₹6.1 L/yr

Technical Architect
2k salaries
unlock blur

₹9.9 L/yr - ₹36 L/yr

Explore more salaries
Compare Hexaware Technologies with

Cognizant

3.8
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview