QA Engineer

Build and perform End to End QA effort on Data Warehouse/ETL/BI Platforms Review requirements, specifications and technical design documents to provide timely and meaningful feedback Understand data flow and test strategy for ETL , Data warehouse and Business Intelligence testing ETL testing of mapping, transformations and data pipelines. 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. Create detailed, comprehensive and well-structured test plans and test cases Identify, document and track software defects Work closely with development teams to perform root cause analysis of issues Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing Identify test cases which has to be automated. Prepare test automation strategy. Design and develop test automation for backend. Work with the team to continually improve test processes and practices based on inspection/adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team Be a self-starter and possess the ability to research issues and improve processes Show initiatives and accountability with strong time management skills with project teams. Must Have: Experience in ETL testing techniques Good understanding of Data Warehousing and business intelligence concepts and testing techniques 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 Education and Experience: Bachelor Degree in Science or Engineering or Equivalent with overall 5 years of experience or Masters Degree in Science or Engineering or Equivalent with overall 3 years of experience in IT fields.

#J-18808-Ljbffr