Interview was pretty simple,good amount of basic questions were asked in the written test.
Tester Etl Interview Questions
192 tester etl interview questions shared by candidates
Sql query: There is a table, called alphabet, a column in it as alpha, there are 6 rows in that column as a,b,c,d,e,f. I want to display feabcd in output
Questions were on MDM testing... Process was good
Basic ETL process and some sql queries
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
Mainly on SQL
1. Describe your experience as an ETL tester
Questions were completely based on SQL and that too very restricted to Joins and some DWH concepts. No informatica, teradata, unix related questions were asked.
How to conduct various testing methods for ETL data transformation ?
1) Tricky/COmplex SQL questions 2)Testing concepts-Not much hard 3)Datastage and ETL concepts 4)ALM and JIRA
Viewing 1 - 10 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