Dimension table Fact table Full load n incremental load Query to find duplicates
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Star schema , snow flakes scheme, joins, transformations.
1st round is client round real time scenarios they asked and sql quations like stored procedures , indexing, joins and set operators and dwh concepts , etl process and roles and responsibilities and bug areporting
Three rounds of tests 1. Aptitude Round 2. Technical Round 3. HR Round
1. Scenario based SQL query questions 2. Scenario based python and sql development questions. 3. Guesstimate questions.
Asked about the project, implementation level questions and real time scenarios
if there is a performance issue in informatica. how will you go about it
what is sdlc process. explain it .
SQL queries testing basics unix aptitude
About project and my roles and resoinsibilites
Viewing 811 - 820 interview questions