Flow of project and flow of etl testing.
Etl Tester Interview Questions
192 etl tester interview questions shared by candidates
A table having data for employee joining date and end date. Find the date differents.
Aggregate functions, SCD 2, Star Schema,Joins, Informatica power center
first round: annotations, priority, dependsOn, dynamic xpath, dataprovider, frameworks, my current project, POM, utility class, property file, db connection in selenium, java program on reversing a string without using reverse function, types of testing, black box vs uat testing, verification vs validation, api testing questions on http status codes, authentication vs Authorization, what all tests i have done
Q. Most questions about what could be the result from two table data presented before us . Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc , Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?) Q. What is Surrogate Key Q. How did you validate Data from Stage to EDW - Example Q. What is your Validation Strategy on Large data set Q. SCD Type - Example pls
What are the types of ETL validations.
How to get unique records in SQL?
what is priority
sanity
Basic DWH concepts and swl queries
Viewing 111 - 120 interview questions