Wipro Senior ETL Tester Interview Questions and Answers

Q1. Olap oltp difference
Add your answer
Q2. How many tables in project
Add your answer

Q1. How to solve test cases?
Add your answer
Q2. What is test data?
Add your answer
Q3. What is positive and negative testing?
Add your answer

Q1. What is salary expectation?
Add your answer
Q2. What is your skills
Add your answer

Q1. Explain project architecture?
Ans. 
Project architecture refers to the overall structure of a software project, including components, modules, and their interactions.
• Project architecture defines how different components of a software project are organized and interact with each other.

• It includes the high-level design of the system, such as the database structure, data flow, and integration points.

• Project architecture also involves decisions on technologi...read more
Answered by AI
Add your answer
Q2. Explain challenges you faced in etl testing?
Ans. 
Challenges in ETL testing include data quality issues, complex transformations, and handling large volumes of data.
• Data quality issues such as missing or incorrect data can impact testing results

• Complex transformations can be difficult to validate and may lead to errors in the ETL process

• Handling large volumes of data can slow down testing processes and require efficient testing strategies
Answered by AI
Add your answer
Q3. What are roles and responsibilities?
Ans. 
Roles and responsibilities refer to the tasks and duties assigned to an individual within a specific job or position.
• Roles define the position or job title of an individual within an organization.

• Responsibilities outline the specific tasks, duties, and expectations associated with that role.

• Roles and responsibilities help clarify expectations, define boundaries, and ensure accountability.

• Examples include testing data e...read more
Answered by AI
Add your answer
Q4. How to find duplicate values in python?
Ans. 
Use a dictionary to find duplicate values in an array of strings in Python.
• Create an empty dictionary to store the count of each string in the array.

• Iterate through the array and for each string, check if it exists in the dictionary. If it does, increment the count. If not, add it to the dictionary with a count of 1.

• After iterating through the array, check the dictionary for any strings with a count greater than 1. The
Answered by AI
Add your answer

Q1. What is deferred bug
Ans. 
A deferred bug is a bug that is not fixed immediately but is scheduled to be fixed in a future release.
• Deferred bugs are usually lower priority bugs that do not impact the core functionality of the system.

• These bugs are documented and tracked for resolution in a later release.

• Examples of deferred bugs include cosmetic issues, minor usability problems, or non-critical functionality issues.
Answered by AI
Add your answer
Q2. Query to get 4th highest row based on a column
Ans. 
Use SQL query with ORDER BY and LIMIT to get 4th highest row based on a column
• Use ORDER BY clause to sort the column in descending order

• Use LIMIT 1 OFFSET 3 to get the 4th highest row

• Example: SELECT * FROM table_name ORDER BY column_name DESC LIMIT 1 OFFSET 3
Answered by AI
Add your answer

Q1. What is the performance testing
Ans. 
Performance testing is a type of testing to ensure software applications perform well under expected workload.
• Performance testing evaluates the speed, responsiveness, and stability of an application under various load conditions.

• It helps identify bottlenecks, performance issues, and areas for improvement in the application.

• Types of performance testing include load testing, stress testing, and scalability testing.

• Tools ...read more
Answered by AI
Add your answer
Q2. What is the correlation
Ans. 
Correlation is a statistical measure that describes the strength and direction of a relationship between two variables.
• Correlation values range from -1 to 1, with 0 indicating no correlation, 1 indicating a perfect positive correlation, and -1 indicating a perfect negative correlation.

• Positive correlation means that as one variable increases, the other variable also increases. Negative correlation means that as one var...read more
Answered by AI
Add your answer
Q3. Performance testing is used for checking the application behavior in terms of speed stability and scalability under various of work load
Add your answer
Q4. Correlation : Means replacing dynamic value by a parameter.In Correlation handling Dynamic Data generated by Server side.
Add your answer

Q1. Different types of waits
Ans. 
Different types of waits include implicit, explicit, and fluent waits in automation testing.
• Implicit wait: Waits for a certain amount of time before throwing a NoSuchElementException.

• Explicit wait: Waits for a certain condition to occur before proceeding further in the code.

• Fluent wait: Waits for a condition to be true with a specified frequency of checking.

• Example: WebDriverWait in Selenium is an example of explicit w
Answered by AI
Add your answer
Q2. Multiple window handles
Ans. 
Multiple window handles are used in automation testing to handle multiple browser windows or tabs simultaneously.
• Use getWindowHandles() method to get all the window handles

• Switch between window handles using switchTo().window(handle)

• Close a specific window handle using driver.close()

• Example: driver.getWindowHandles()

• Example: driver.switchTo().window(handle)
Answered by AI
Add your answer

Q1. Sallary expected
Add your answer
Q2. Location preference
Add your answer

Reasoning,numerical ,ratios

Basic coding questions

Q1. Sql Quires related question.
Add your answer
Q2. Data ware house related question
Add your answer
Q3. What is entry criteria & exit criteria
Ans. 
Entry criteria and exit criteria are conditions that must be met before and after testing, respectively.
• Entry criteria are the conditions that must be fulfilled before testing can begin

• Exit criteria are the conditions that must be fulfilled before testing can be considered complete

• Entry criteria can include having test data ready, test environment set up, and test cases prepared

• Exit criteria can include all test cases ...read more
Answered by AI
Add your answer