Data warehouse concept,ETL,Facts,About project,SCD,SQL Advance
Etl Tester Interview Questions
192 etl tester interview questions shared by candidates
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
Flow of project and flow of etl testing.
A table having data for employee joining date and end date. Find the date differents.
Basic DWH concepts and swl queries
Explain about the ETL Architecture
ETL process and sql query writing
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.
Viewing 111 - 120 interview questions