few ETL concepts and SQL queries
Junior Etl Developer Interview Questions
1,245 junior etl developer interview questions shared by candidates
Past work related to Pyspark and how I implemented those. How I used AWS to create a data pipeline.
Star schema s. Snowflake Schema
Case vs decode Scd 1 scd 2 How to test old loaded data in DW which is not present in source Join condition on null, empty and duplicate
What is SCD and what are its type?
1. Normalizer transformation 2. How do you read from message queues in Informatica? 3. Scenarios for oracle SQL's and Informatica logic
what is a batch load
Few SQL based question.
Cast function in SQL - how would you validate your data if datatypes are changing from src to target
How much time do spend mentoring juniors
Viewing 711 - 720 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