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...
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

[@user-yp6ni1hz2r]

thanks madam

[@ShivShwetaVlogs]

Thank you very much for making this video 🙂

[@testerhoon28]

😇

[@kalyaniponnada7623]

thank you so much for making this video,Please make more videos as same

[@testerhoon28]

okay 🙏

[@SandeepSingh-ru6dx]

Mam you are doing excellent work for beginners and experience also.plz make a video immediately part-2

[@testerhoon28]

thank you🙏... okay👍

[@English_raj2020]

nice information

[@testerhoon28]

thank you 🙏

[@sandeepkumarsingh4645]

Plz make a video immediately part-2.very helpful for us

[@testerhoon28]

okay 👍

[@ipsitapradhan1672]

Pls make videos on how to automate etl testing techniques.

[@testerhoon28]

okay 👍

[@dipakshinde3233]

Thanks a lot Ma'am for informative videos. I have faced most of questions in Inerviews. Few Questions which I have came across are: 1. Difference between CASE and DECODE? 2. Can we join 2 tables without joins? 3. What us CDC? 4. How do you validates Data between file which is placed on unix server and data loaded in the table? Basically how to validate data between file and table in database? 5. What are biggest challenge you have faces during ETL testing and how you overcome that? 6. What is difference between Pre-staging and Staging? If you could cover these questions in next video then would be very beneficial. I will keep adding as soon as I remember more questions. Thanks in advance 😊

[@testerhoon28]

thanks for sharing... 🙏 will cover all questions in cmg vdos

[@dipakshinde3233]

@@testerhoon28 Thanks a lot 🙂

[@sumanththanneru9581]

please make videos with bit more voice clarity :)

[@testerhoon28]

Sure 😊

[@user-gq8wj7cp9x]

your doing well oe us but voice is not clear mam

[@testerhoon28]

yes, now i will make sure voice is clear in nxt vdo... 🙏

[@user-vt7py5vd2u]

I'm using your playlist for interview preparation, you're very good at it maam, and for first question we can write in this was right..? "Select * from employee where date in ( select max(date) from employee group by empid)"

[@testerhoon28]

thank you 🙏.. pls type question as well...

[@prashantkamble5651]

One quick question if I have more than 100 columns in source and target then how you can compare ? Need to check only column name

[@testerhoon28]

You need to validate all the data and data types

[@prashantkamble5651]

@@testerhoon28 I just want to compare source and target column name

[@testerhoon28]

use below query for both source and target to match the column and data type select column_name, data_type from information_schema.columns where table_namw = 'give ur table name'

[@kumaraslkumar3912]

Nxt time plz explain louder.. ur voice is very low.

[@testerhoon28]

yes voice not recorded properly... iwill take care of it nxt tym... 🙏