Job Description :
Role:Data Warehouse/ETL/BackendTester
Duration: Long Term Contract

Write SQL queries for Back-End Testing to ensure data integrity, validating database consistency and verifying accurate transaction
Prepare Test Plan/Test Scripts with Business positive/negative scenarios with SQL, UI and MicroStrategy Reporting
Provide End-to-End data validation for ETL and Bl systems - Utilize robust ETL, Bl processes and data warehousing concepts
Create test plans and test strategies
Create queries (medium to complex) using SQL Developer and document with each test case to validate ETL for various BI projects
Create and document in Application LifeCycle Management test cases - Execute Test Procedures and document results for each step. (verifying and validating DDL, ETL, and any code migrated to Test environment)

7+ yrs. Experience
Experience in both AGILE(Scrum) and Waterfall testing models
Strong in ETL data validation using Informatica
Strong in Bl report validation using MicroStrategy
Exposure to DB tools: Toad for Oracle/ PL SQL Developer; Rapid SQL; SQL Plus; SOAPUI; Mulesoft; Selenium