Are you flexible with working on weekends?
Junior Etl Developer Interview Questions
1,579 junior etl developer interview questions shared by candidates
For example, the question would go like this....Tell me about a time that you had to work with someone that you disagreed with. They are looking for a situation, how you handled it and the response from the other person.
Tell me about a time you made a mistake.
- Couple of related to SQL - UI/Web testing (now this is not a good question to ask to a DWH/ETL tester, you can't ask a fish how to fly) - Rest were puzzles about temple-flowers, sheep-tiger, bucket-water.
What is the most complex SSIS package you designed?
on basic ETL concepts Data Warehousing concepts
L1 technical round - basic sql , whole project concept and working. ( 30 mins ) L2 technical round - Thorough technical discussion, very less questions from informatica , more from dwh and sql. (30-45 mins) Mangerial Round - The interviewer asked a hell lot of questions and explained well about the role and firm. This is where you come to know that they will take you ( an experienced professional with more than 3 years of experience) and train as a fresher on different technologies and deploy you as shadow in project . In case if you agree and even if the whole process appears to have gone well, the contact person calls you and tells you that they want to conduct another managerial round as they think your skillset is different . I don't understand the concept of one more managerial round for skill assessment.
project explanation and compensation details ?
All etl testing related questions
Joins and join types. Data warehouse concepts. What is OLAP and OLTP. SQL Quires like Duplicate records. Case and Decode. Rank and Dense Rank. Difference between SCDtype1,SCD type2,SCDtype3.
Viewing 241 - 250 interview questions