All basics about DW ,ODI ,SQL and projects worked . scenario based questions as well
Senior Etl Developer Interview Questions
1,579 senior etl developer interview questions shared by candidates
what is chmod 755 command in unix
A stupid case is given. They give same case to everyone. There is data of some bass electronic goods selling company now you have to design data mart, complete architecture, reports design, analytics report design, granularity of data. These guys are so stubborn with their cases, all of them have crammed that solution and expect the same from the candidate. They are not going to ask you anything apart from the questions and solutions they have crammed.
how to work with etl pipeline explain spark context difference bw dataset and data frame hive optimization
How can the mapping be fine-tuned in ETL?
Questions was good on SQL,Unix and DW concepts. Below are some questions : 1. Difference in DM and ODS 2. Star Schema and Snowflake schema 3.Data verification process 4.Sql Queries a. Delete Query b. Duplicate Query etc 5. Union and Union all difference with the example 6. All Joins 7. Project description 8. Analytic Functions
1. Describe your experience as an ETL tester
Mainly on SQL
How to remove duplicates at mapping level
tell me about yourself
Viewing 61 - 70 interview questions