Describe an ETL/ELT process step-by-step and some SQL questions (Leetcode easy category)
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Scenario based questions on Informatica that uses Aggregator and Expression Transformations
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
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
How long working in the ETL technology
What is ETL process
Time duration should be less for interview rather 1 hr
Pentaho Scenerio questions
technical stuffs
Viewing 941 - 950 interview questions