SQL Stored Procedures with variable
Etl Engineer Interview Questions
1,581 etl engineer interview questions shared by candidates
Interview process was Moderate, Panel was friendly
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.
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.
Tell me about a time you received feedback you weren't expecting and how you handled it.
Tell me about a time you failed
why do you feel that you can make target a better company
Tell me about a time when your long term goals affected your everyday actions.
example of a time when you gave exceptional customer service. time when you managed conflict time when you made a mistake time when you went beyond the call of duty time when you took initiative time when gave feedback time when you had to tell someone about a decision that would affect them
Viewing 971 - 980 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