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
About primary technology projects worked and challenges.
Self Introduction after that, Interviewer is asking for IBM MDM skill set. Totally unawareness and fault of talent acquisition team.
How to remove duplicates at mapping level
tell me about yourself
Viewing 51 - 60 interview questions