second round: cross join scenario, browser compatibility testing vs cross browser testing, how to check data of 5000 rows between db and a website(no download/export option), tell me about some etl errors, 3-4 scenario based questions on writing test cases, what to do when we cannot reproduce bugs, regression vs sanity testing
In first round: Joins, rank
tool specific questions
Create a table, enter data and perform joining and other thing.
Tell me about yourself and project
1st round is client round real time scenarios they asked and sql quations like stored procedures , indexing, joins and set operators and dwh concepts , etl process and roles and responsibilities and bug areporting
SQL queries testing basics unix aptitude
few ETL concepts and SQL queries
Case vs decode Scd 1 scd 2 How to test old loaded data in DW which is not present in source Join condition on null, empty and duplicate
correlated subqueries
Viewing 81 - 90 interview questions