Tell me about yourself
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
How you handle a disagreement with you peer
how to work with etl pipeline explain spark context difference bw dataset and data frame hive optimization
simple transformations in informatica and some SQL questions
Lots of technical questions about a specific software being used by this team.
About ETL testing releted, Unix, SQL
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.
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
Sql related questions joins, sub queeies
Self Introduction after that, Interviewer is asking for IBM MDM skill set. Totally unawareness and fault of talent acquisition team.
Viewing 61 - 70 interview questions