1)SCD 2)union union all difference 3)joins
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Explain about Previous project experience
They asked a lot about databases and experience with ETL projects
80% of questions were technical about the position 20% personal but, did not care about
Briefly describe yourself and the work experience.
Coding
Technical
What is your work authorization in the United States?
Tell me about source tuning.
Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
Viewing 221 - 230 interview questions