ETL Testing Interview Question - Part 1

ETL Testing Interview Question - Part 1
#etltesting #interviewquestions #sql
1. Tell Me about Yourself?
2. How Data flow in your project?
3. What are the stages in your project? Access(Reporting Tool – Cognos)
4. What you will do in Landing, Staging and DWH Layer’s?
5. What Type of Logic applied in the Staging Area?
6. Do You Know about Set operators Explain. – union, union all, minus, intersect
7. Explain Joins -    • SQL Joins - Inner Join, Right Outer Join, ...  
8. What is the difference between the Inner join and intersect?
9. Rank and Dense Rank Explain
10. If you have full name RAMU.KUMAR, can you separate these two names from single name.
11. How to display last records from the table
12. How to display the lowest salary from the table
13. How to get Even and Odd records from the table – remainder =0 means even
14. How to display duplicate records
15. Difference between Drop, Delete, Truncate
16. Do you know about informatica?
17. What is Mapplet?
18. What is Workflow?
19. What is Session?
20. Do you know about the informatica Scheduler?
21. Test Management tool
22. Defect Life Cycle
23. NVL and NVL 2 Explain
24. How to display 4th and 7th records from the table
25. Positive and Negative Testing Scenarios
26. Suppose Source table having 1000 records but in target loaded only 800 records then How you Validate the Data
27. From Source to Staging how you are getting the Data
28. Can You tell some table names in your staging area?
29. Suppose we have 100 records in source, we have to do one to one mapping but in the staging, datatype is different other than that everything is same. Explain How you validate the data.?
30. Can you Explain what validations you have done in your project.
31. What are the Constraints you validated?
32. EMP Table

Emp_ID Emp_Name Manager_ID


Write A Query to Fetch the Employees who don’t have any managers.

Departments Table

Dept_id Dept_name Emp_name

2. Write a Query to fetch all the records from the Emp and Matching records from the department table