Skip to contentSkip to footer

Etl Engineer Interview Questions

Salaries
Interviews

1,581 etl engineer 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

3.6★
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

Mostly the questions are from UNIX & Abinitio. 1. List the frequently used unix commands 2. How to copy single file into multiple copies 3. How to find the particular string occurrences in a file 4. How to view the content of a zipped file 5. Difference between Incremental Load & Full Load 6. How to find out the user created files in a directory
avatar

ETL Tester

Interviewed at TransUnion

3.6★
Jul 9, 2019

Mostly the questions are from UNIX & Abinitio. 1. List the frequently used unix commands 2. How to copy single file into multiple copies 3. How to find the particular string occurrences in a file 4. How to view the content of a zipped file 5. Difference between Incremental Load & Full Load 6. How to find out the user created files in a directory

Viewing 931 - 940 interview questions

Glassdoor has 1,581 interview questions and reports from Etl engineer interviews. Prepare for your interview. Get hired. Love your job.