Tester experienced with ETL pipeline testing, data model validation, BI testingKnowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, factsEnsure all sign offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirementsResponsible for ensuring quality of their work the work of the entire development teamStrong experience in of the following technologies preferred –Web API (MS ASP.Net), MVC, WCF, HTML5, CSS, JavaScript, JSON, SOAP, REST, JQuery, Java ,.Net Framework, C#, Ab InitioCreate SIT test cases/test data and perform Test executionReview Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test casesValidates data by running queries in the database and verify that the results match the expectationsAnalyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defectsWorks closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effortWriting queries to extract data for test case data comparison