Scenario based: Delete duplicates rows from that target table without having a primary key
Etl Engineer Interview Questions
780 etl engineer interview questions shared by candidates
what do you know about the SCD(Slowly changing dimension)?
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
Difference between ddl and dml command
Mostly general questions on Informatica, Data warehousing and SQL
Viewing 141 - 150 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