questions on their day to day work
Etl Engineer Interview Questions
780 etl engineer interview questions shared by candidates
1. As usual tell me about yourself. 2. roles and responsibilities in the previous project. 3. If you get text file how you connect to power center and load into DWH. 4. What Dimension you used in your project? 5. Types of SCD and difference between SCD1 and SCD2. 6. How you maintained SCD2 in your project. 7. Then they asked a SQL query (many to many relationships).
Tell us something about the ETL Tools used.
How would get specific number record to target like 1st and 3rd. SCD Types Schema Change Handling Aggregation Working on performance tuning in Informatica Powercenter
Informatica concepts and data warehouse
join between : 1 0 1 1 0 1
Basic sql join questions and project discussion
Describe your BSc. project.
Questions were pretty relevant to my experience.
Previous experience, projects and resume walk through. Some mid-level technical questions on ETL(ABINITIO), SQL, UNIX, AUTOSYS.
Viewing 231 - 240 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