Many technical questions related to the job role
Etl Testing Analyst Interview Questions
71 etl testing analyst interview questions shared by candidates
Grain of fact, olap, oltp, cube concepts etc. Questions on etl flow
Etl basics Data acccuracy,data quality testing,joins,functions
should be well versed with sql.
any critical moment during current work and turnaround
current job profile
related to ETL testing
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
ETL tool related questions if you have hands-on
Interview process was Moderate, Panel was friendly
Viewing 41 - 50 interview questions