Skip to contentSkip to footer

Developer Sql Server Etl Interview Questions

Salaries
Interviews

728 developer sql server etl interview questions shared by candidates

This is a written exam with no multiple-choice or true/false questions. there were very basic-advanced T-SQL development questions - like text-book questions - dmvs, indexing, keys, define a relational db… Nothing to do with the job requirements- 0 ETL or BI questions. They asked 2-3 questions where you will need to revise and create code.
avatar

ETL Developer

Interviewed at Cardlytics

2.9★
Sep 4, 2014

This is a written exam with no multiple-choice or true/false questions. there were very basic-advanced T-SQL development questions - like text-book questions - dmvs, indexing, keys, define a relational db… Nothing to do with the job requirements- 0 ETL or BI questions. They asked 2-3 questions where you will need to revise and create code.

1. dataware housing concepts : difference between OLTP/OLAP ,difference between Fact/Dim 2. Informatica : difference between lookup/Joiner,types of tranformations , more on lookup and file loading 3. Database : how to delete dups from table, Cross join function , difference between delete/truncate ,difference between intersect/inner join, query approch 4. Informatica scenarios : read bulls raider for the same
avatar

Informatica ETL Developer

Interviewed at Accenture

3.7★
Dec 28, 2017

1. dataware housing concepts : difference between OLTP/OLAP ,difference between Fact/Dim 2. Informatica : difference between lookup/Joiner,types of tranformations , more on lookup and file loading 3. Database : how to delete dups from table, Cross join function , difference between delete/truncate ,difference between intersect/inner join, query approch 4. Informatica scenarios : read bulls raider for the same

Viewing 471 - 480 interview questions

Glassdoor has 728 interview questions and reports from Developer sql server etl interviews. Prepare for your interview. Get hired. Love your job.