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 Tester Interview Questions and Answers for Experienced

Updated 11 Oct 2024

Hexaware Technologies ETL Tester Interview Experiences for Experienced

1 interview found

ETL Tester Interview Questions & Answers

user image Gayathri Latha

posted on 25 Feb 2024

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

(3 Questions)

  • Q1. What is Scalar function with example.
  • Ans. 

    Scalar function is a function that returns a single value based on input parameters.

    • Scalar functions are used in SQL to perform calculations on input values and return a single result.

    • They can be used in SELECT statements, WHERE clauses, and other SQL queries.

    • An example of a scalar function is the ABS() function, which returns the absolute value of a number.

  • Answered by AI
  • Q2. Query to fetch only numbers from alphanumeric data from a table.
  • Ans. 

    Use regular expressions to extract numbers from alphanumeric data in a table.

    • Use the REGEXP_REPLACE function in SQL to replace all non-numeric characters with an empty string.

    • For example, SELECT REGEXP_REPLACE(column_name, '[^0-9]', '') FROM table_name;

    • This will return only the numbers from the alphanumeric data in the specified column.

  • Answered by AI
  • Q3. Query to fetch data greater than average, min and max salary.
  • Ans. 

    Query to fetch data greater than average, min and max salary.

    • Calculate average, min, and max salary first

    • Use a SELECT statement with WHERE clause to filter data greater than average, min, and max salary

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared on complex query and architecture of the your testing process.

Skills evaluated in this interview

ETL Tester Jobs at Hexaware Technologies

View all

What people are saying about Hexaware Technologies

View All
fascinatingsherlock
Verified Icon
2w
works at
Hexaware Technologies
Job switch
Trying to grab an opportunity in Mumbai in BlackRock Does anyone have a reference??
Got a question about Hexaware Technologies?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Simple aptitude
Easy group discussion topics
Logical thinking

Round 2 - Group Discussion 

Everyone will sit in a row and single topic with be given as a bedet

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview will be on logical thinking

I applied via Monster and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How to do work?

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing to share special
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Sep 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

Reasoning, english, quantitative aptitude, analysis,

Round 3 - Coding Test 

This round having 2 coding questions, can solve in desired programming language

Round 4 - Technical 

(1 Question)

  • Q1. Prepare for the skills you mentioned in resume
Round 5 - HR 

(1 Question)

  • Q1. Asked some personality related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared before giving an interview and with confidence.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Why we prefer that job to you
  • Ans. Firstly I am fresher so I am very excited to acquire knowledge about that post and contributing my new idea with full strategy.
  • Answered by Pritee Acharya
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected

I applied via Company Website and was interviewed in May 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Asked questions related to String manipulation and arrays

Round 3 - HR 

(2 Questions)

  • Q1. Introduce yourself
  • Q2. Strengths and weaknesses
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference between Test Scenario and Test cases
  • Ans. 

    Test scenarios are high-level descriptions of the functionality to be tested, while test cases are detailed steps to validate the scenarios.

    • Test scenarios are broad and cover multiple test cases.

    • Test cases are specific steps to validate a particular scenario.

    • Test scenarios are usually created at the beginning of testing, while test cases are derived from scenarios.

    • Test scenarios are used for high-level planning and est...

  • Answered by AI
  • Q2. Use cases for application
  • Ans. 

    Use cases for application involve identifying different scenarios in which the application can be used to meet user needs.

    • Testing different user interactions

    • Validating system functionality

    • Identifying edge cases

    • Ensuring compatibility with different devices

    • Verifying data integrity

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Details about you and profile
Round 2 - Technical 

(3 Questions)

  • Q1. Quality testing related questions
  • Q2. Describe automation framework
  • Ans. 

    Automation framework is a set of guidelines, coding standards, concepts, processes, practices, tools, and utilities that help in developing and executing automated tests.

    • Provides structure and organization for automated testing

    • Defines rules and best practices for test automation

    • Includes libraries, utilities, and tools for test script development and execution

    • Supports integration with test management tools and CI/CD pip...

  • Answered by AI
  • Q3. Brief day to day activities
  • Ans. 

    Day to day activities include writing test cases, executing tests, analyzing results, reporting bugs, and collaborating with developers.

    • Write test cases based on requirements

    • Execute test cases manually or using automation tools

    • Analyze test results and report bugs

    • Collaborate with developers to resolve issues

  • Answered by AI

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Coding Test 

String manipulation, oops, sql queries,

Round 2 - Technical 

(2 Questions)

  • Q1. What is selenium and components of it
  • Ans. 

    Selenium is a popular open-source automation testing tool used for web applications.

    • Selenium is used for automating web browsers.

    • Components of Selenium include Selenium IDE, Selenium WebDriver, and Selenium Grid.

    • Selenium IDE is a record and playback tool, WebDriver is for writing test scripts in various programming languages, and Grid is for parallel test execution.

    • Selenium supports multiple programming languages like ...

  • Answered by AI
  • Q2. What is use of annotations in testng
  • Ans. 

    Annotations in TestNG are used to provide additional information about test methods and classes, such as priority, dependencies, and data providers.

    • Annotations help in organizing and controlling the flow of test methods

    • Annotations can be used to set the priority of test methods

    • Annotations can be used to define dependencies between test methods

    • Annotations can be used to provide data for parameterized tests

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn

Round 1 - One-on-one 

(4 Questions)

  • Q1. Opps concepts Abrction
  • Q2. Testng annotatations
  • Q3. Java code for reverse the string
  • Ans. 

    Java code to reverse a string using StringBuilder

    • Create a StringBuilder object with the input string

    • Use the reverse() method of StringBuilder to reverse the string

    • Convert the reversed StringBuilder object back to a string using toString()

  • Answered by AI
  • Q4. They have given link on that ask to find xpath

Skills evaluated in this interview

Hexaware Technologies Interview FAQs

How many rounds are there in Hexaware Technologies ETL Tester interview for experienced candidates?
Hexaware Technologies interview process for experienced candidates usually has 1 rounds. The most common rounds in the Hexaware Technologies interview process for experienced candidates are Technical.
How to prepare for Hexaware Technologies ETL Tester interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Hexaware Technologies. The most common topics and skills that interviewers at Hexaware Technologies expect are ETL Testing, SQL Queries, SQL, DWH Testing and ETL.
What are the top questions asked in Hexaware Technologies ETL Tester interview for experienced candidates?

Some of the top questions asked at the Hexaware Technologies ETL Tester interview for experienced candidates -

  1. Query to fetch only numbers from alphanumeric data from a tab...read more
  2. Query to fetch data greater than average, min and max sala...read more
  3. What is Scalar function with examp...read more

Tell us how to improve this page.

Hexaware Technologies ETL Tester Interview Process for Experienced

based on 1 interview

Interview experience

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

ETL Tester Interview Questions from Similar Companies

View all
Hexaware Technologies ETL Tester Salary
based on 114 salaries
₹5 L/yr - ₹25.2 L/yr
86% more than the average ETL Tester Salary in India
View more details

Hexaware Technologies ETL Tester Reviews and Ratings

based on 4 reviews

4.6/5

Rating in categories

4.6

Skill development

4.3

Work-life balance

4.3

Salary

4.6

Job security

4.3

Company culture

4.6

Promotions

4.3

Work satisfaction

Explore 4 Reviews and Ratings
Hexaware Hiring_ETL Tester_5+years_Mumbai/Bangalore

Mumbai,

Bangalore / Bengaluru

5-10 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
3.8k salaries
unlock blur

₹5.5 L/yr - ₹20 L/yr

Software Engineer
3k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

System Analyst
2.9k salaries
unlock blur

₹7.7 L/yr - ₹29 L/yr

Technical Architect
2.1k salaries
unlock blur

₹10 L/yr - ₹38 L/yr

Senior Executive
1.9k salaries
unlock blur

₹0.8 L/yr - ₹6 L/yr

Explore more salaries
Compare Hexaware Technologies with

Cognizant

3.7
Compare

TCS

3.7
Compare

DXC Technology

3.7
Compare

Mphasis

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