What do your day-to-day responsibilities look like at your current job?
Etl Developer Interview Questions
728 etl developer interview questions shared by candidates
Regular questions - work experience, reason for leaving etc.
Mostly SQL Questions (joins, rank, row nums, subqueries), Tuning queries, Data Modeling, Data Warehousing Concepts, Unix,
Basic Etl questions like lookup vs joiner , parameters etc
Challenge faced during project implementation
questions on their day to day work
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
Viewing 211 - 220 interview questions