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.
Junior Etl Developer Interview Questions
1,579 junior etl developer interview questions shared by candidates
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?
Questions related to my role that is tester. Tools used in the previous projects.
They asked a lot about databases and experience with ETL projects
Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
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
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