Scenario based: Delete duplicates rows from that target table without having a primary key
Etl Developer Interview Questions
728 etl developer 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 131 - 140 interview questions