ETL Tester

Responsibilities
•        Understand data flow and test strategy for ETL , Data warehouse and Business Intelligence testing
•        Data warehouse testing involving the testing of stored procedures, SSIS packages, slowly changing dimension tables, Change Data capture etc.
•        Business Intelligence testing involving the validation of DataMart, ODS, Data models and SSRS reports.
•        Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing
•        Identify test cases which have to be automated. Prepare test automation strategy. 

Qualifications and Skills 
•        Experience in Working with Star Schema, ODS, multi-dimensional models, slowly changing dimensions
•        Experience in working with ETL framework, Change Data capture, DataMart, Data models etc.
•        Familiarity with one or more SQL-on-Hadoop technology (Hive, Impala, Spark SQL, Presto)
•        Experience in Agile projects (Scrum, Kanban etc.).
•        Working Knowledge in Test Management software (JIRA, qTest/ALM).
•        Strong in SQL preparation in Oracle OR SQL Server OR NoSQL OR RDMS OR Big Data