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