Celandyne Software Solutions LLC
Software QA Engineer
Celandyne Software Solutions LLC, Clayton, California, United States, 94517
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 PlatformsReview requirements, specifications and technical design documents to provide timely and meaningful feedbackUnderstand data flow and test strategy for ETL , Data warehouse and Business Intelligence testingETL 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 casesIdentify, document and track software defectsWork closely with development teams to perform root cause analysis of issuesWrite advanced SQL queries for ETL/data warehousing/Business Intelligence testingIdentify 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 teamBe a self-starter and possess the ability to research issues and improve processesShow initiatives and accountability with strong time management skills with project teams.Must Have:
Experience in ETL testing techniquesGood understanding of Data Warehousing and business intelligence concepts and testing techniquesExperience in Working with Star Schema, ODS, multi-dimensional models, slowly changing dimensionsExperience in working with ETL framework, Change Data capture, DataMart, Data models etcEducation 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.
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 PlatformsReview requirements, specifications and technical design documents to provide timely and meaningful feedbackUnderstand data flow and test strategy for ETL , Data warehouse and Business Intelligence testingETL 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 casesIdentify, document and track software defectsWork closely with development teams to perform root cause analysis of issuesWrite advanced SQL queries for ETL/data warehousing/Business Intelligence testingIdentify 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 teamBe a self-starter and possess the ability to research issues and improve processesShow initiatives and accountability with strong time management skills with project teams.Must Have:
Experience in ETL testing techniquesGood understanding of Data Warehousing and business intelligence concepts and testing techniquesExperience in Working with Star Schema, ODS, multi-dimensional models, slowly changing dimensionsExperience in working with ETL framework, Change Data capture, DataMart, Data models etcEducation 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.