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
Questions related to database modelling
Indexing, Data cleaning, aggregate functions
Viewing 941 - 950 interview questions