Fulcrum - ETL Testing Interview Question - 3 to 6 Years Experience

Falcrum
3 to 6 ETL experience interview

1. How to find 3 highest salary from employee table?

2. Explain Referential integrity.

3.Tell me about your current role

4.Differences between  Agile vs other traditional software development models.

5. In Batch processing data from Table A is going to  Table B.  What will be your Test Approach?

6. What type of bug you faced in ETL testing. Explain the best bug you found so far

7. ETL testing scenario you used generally. What are challenges you faced in ETL Testing?

8. How to insert 100 records from table A table B.

9. How you access databases?

10. What is different between a datawharehouse testing ETL testing.

11. How to create CSV file and how you enter 10000 records.
- Also how you test this file.
- Once  this CSV insert through ETL job in data base how you will test.
- If any issue happend during loading like decimal value not inserted then what you do?
- If we want again insert same records again what will do?

12. There are 10 sequential files are kept in unix directory.
You need to process these files. Tell me positive and negative scenarios.

13.  Differences between delete and truncate.

14. What are the numeric function in oracle.

15. Do you know pl/sql

16.Case statement scenario query

17 .Group by and having clause query.

18 . How you rate your SQL  skills

19. Have you build CSV, flat file and pipe format files.