operating systems kernel mode and user mode
Junior Etl Developer Interview Questions
1,579 junior etl developer interview questions shared by candidates
related to ETL testing
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
What is ETL process
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
How long working in the ETL technology
Time duration should be less for interview rather 1 hr
Pentaho Scenerio questions
technical stuffs
Indexing, Data cleaning, aggregate functions
Viewing 941 - 950 interview questions