ETL file validations
Tester Etl Interview Questions
225 tester etl interview questions shared by candidates
Questions were related to ETL testing concepts and SQL
Basics related to ETL
Unix based question
Little complex
Briefly describe yourself and the work experience.
Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
- Couple of related to SQL - UI/Web testing (now this is not a good question to ask to a DWH/ETL tester, you can't ask a fish how to fly) - Rest were puzzles about temple-flowers, sheep-tiger, bucket-water.
Questions related to my role that is tester. Tools used in the previous projects.
Joins and join types. Data warehouse concepts. What is OLAP and OLTP. SQL Quires like Duplicate records. Case and Decode. Rank and Dense Rank. Difference between SCDtype1,SCD type2,SCDtype3.
Viewing 21 - 30 interview questions
See Interview Questions for Similar Jobs
Collaudatore Di DatabaseAnalista Di Sistemi Di Data Warehouse EtlSviluppatore Di Bi CognosAnalista Programmatore CobolSviluppatore Di Data Warehouse EtlAnalista It Di Dati Per Sviluppatori SqlProgrammatore Di CobolAnalista Programmatore MainframeSas Analista ProgrammatoreSviluppatori Di Cobol Mainframe In RemotoProgrammatore Di Database ClinicoAnalista Del Data Warehouse QaAnalista Di Data Entry Analista Programmatore Sas Analista Di DatiSpecialista Di DatabaseCollaudatore HadoopAnalista Dei Dati Di Garanzia Della QualitàSviluppatore Analista Programmatore