Scenario based: Delete duplicates rows from that target table without having a primary key
Etl Engineer Interview Questions
1,579 etl engineer interview questions shared by candidates
what do you know about the SCD(Slowly changing dimension)?
Comment vous tenez vous a jour dans votre domaine de compétence
Sample Queries to write on Joins, Rank Functions
They asked just one technical question that how would you add a Header , Detail and Footer to a target flat file.. ? Would you require 3 different target files to do that or you can do it in one? HOW?
all of the questions are the easiest questions I have met ever, some thing like what is SSIS, what is the component of SSIS, what is the data profile... And I guess they are expecting the exact answer like Interview-answer books.
Previous project experience and difficulties faced in that
About transformations and SQL queries
To solve some hypothetical data questions on a whiteboard
Describe different ytpes of SCD
Viewing 261 - 270 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