It's only single round of interview and it went for 21 minutes out of 30 minutes. It was easy one.Interviewer asked me about my roles and responsibilities in the current project.Also she asked me the project overview.After that she asked some SQL questions on analytical functions,Agile methodology and also test management tools.So interview was easy and I got selected.
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
few ETL concepts and SQL queries
Joins Partition Sql queries Agile
SQL queries testing basics unix aptitude
How to check duplicate
correlated subqueries
how to find duplicate records
Dimension table Fact table Full load n incremental load Query to find duplicates
Viewing 101 - 110 interview questions