Job Title: Software QA Engineer
Location State :
San Jose, CA
Date of Posting:
09/21/2023
Terms:
W2
Duration:
Long Term
Number of Positions Available:
Multiple
Job Requirements:
- 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.