QA Engineering in Testing

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