Tell me about a time you had a lot of things going on at once. What did you do to prioritize and finish the task?
Etl Engineer Interview Questions
1,581 etl engineer interview questions shared by candidates
Describe a situation when you had to challenge your leader and give the outcome
Tell me about a time you had competing priorities, how did you decide what to do first.
ETL Tuning methods - Oracle
Query for finding duplicated records
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
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
what all the set operations available in SQL
How do you evaluate the job in Unix . Test cases for running the job
Question were mainly related to previous projects done earlier company. Mostly on what was the complexity and how it was handled. There will be lot cross question on what you explain. Other then this they asked few technical questions on ETL tool.
Viewing 1051 - 1060 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant