Types of schema ? What is snowflake schema?
Etl Engineer Interview Questions
1,579 etl engineer 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
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
Informatica scenario based questions and data warehousing concept
Viewing 951 - 960 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant