NESS Interview Questions

1.ETL Architecture


2. Things we need to test in ETL (Ans : Count, Data, Duplicates, Special Char)

3. Difference between group by and order by

4. Having clause

5. Elements of star schema

6. What is fact and dimension

7. 23rd Rank – SQL query

8. Documents we need for testing

9. What we test in Database testing (Ans : Data consistency – count check, Data Validity – data check, Data Integrity- FK check)

10. Process followed in your project

TANGOE Tech Interview Questions

1.What is metadata?


2.ETL Architecture used in your project.

3.Can ETL Testing be used in all domains?(Healthcare and all?)

ANS:Yes

4.Which ETL tool used in your project?

5.How did you load the data from source till datawarehouse??

Using Control M Job scheduler tool

6.What kind of testing you do in your project?

Sistem integration testing-V-model

7.What are the testings you do?

Regression testing,Retesting,Adhoch testing,

8.Explain Defect lifecycle

9.How will you validate the data in ETL testing??Scenarios?

10.Write the query to get minimum,maximum,and avg of col2 of table A in a single query.

11.How will you validate duplicates?

12.What is the difference b/w Where and Having clause???

13.Difference b/w Truncate and Duplicate.Explain in detail

14.Left outer join,inner join and right outer join.

15.Where will you find the log files after job run ? how will you test log files?

16.How will you validate flat files.

17.List out the commands you know in unix

18.what is GREP in unix ?

19.What is PS ?

20.What is cd ?

21.How will you connect to Oracle SQL developer?

DELOITTE INTERVIEW Questions

1.Explain ETL Architecture used in your project


2. How to delete duplicate rows in a table

3. How to find third highest salary

4. Different types of indexes

5. Difference between partition by and group by

6. What is Test Plan? What are the contents in it?

7. Difference between Test strategy and test plan

8. How the sampling would be done for a table with 1million records

9. How the setting up of data had done, and how you identify which all data are needed to test?

10. What is boundary value analysis, and how it can be used in ETL testing

11. Explain about your one day in office

12. The incident which made you to frustrate a lot, and provided happiness at the end

13. What all risks identified in the project

14. What is smoke testing, whether it can be implemented in ETL testing, and how?

15. Why we need foundation tables, while the reporting is mapped to Semantic layer, and why we cannot design without foundation?

16. Why landing area is required, if it is the mirror of source and no transformations are applied between sources and landing?

17. Write test cases that can be used between landing and staging

18. In your project effort estimation is done on the basis of which method.