how to work with etl pipeline explain spark context difference bw dataset and data frame hive optimization
Etl Engineer Interview Questions
1,579 etl engineer interview questions shared by candidates
How can the mapping be fine-tuned in ETL?
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.
Sql related questions joins, sub queeies
simple transformations in informatica and some SQL questions
All basics about DW ,ODI ,SQL and projects worked . scenario based questions as well
How to remove duplicates at mapping level
1. Describe your experience as an ETL tester
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
tell me about yourself
Viewing 61 - 70 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant