Types of schema ? What is snowflake schema?
Junior Etl Developer Interview Questions
1,263 junior etl developer interview questions shared by candidates
Data warehouse concept.. What is fact ? What are its type ?
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
Describe Yourself
Questions related to database modelling
Remove duplicates in SQL, SCD type 2 flow, Dynamic lookup, Department wise highest salary query in SQL, How to consider list of files in Informatica PC
SQL scenario based queries and unix
Basic Informatica concepts, PLSQL, UNIX
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.
Tell me about your project
Viewing 641 - 650 interview questions
See Interview Questions for Similar Jobs
Junior Sql DeveloperSenior Etl DeveloperDatastage Etl DeveloperSenior Sql DeveloperData Warehouse EngineerJunior Bi DeveloperJunior Data EngineerData Warehouse Etl DeveloperMsbi DeveloperSenior Etl Developer / TesterEtl DeveloperTalend Etl DeveloperPower Bi DeveloperPl Sql Developer JúniorJunior Cognos DeveloperSql Bi DeveloperDatastage DeveloperJunior Sql Server Database Administrator