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