Data QA Engineer

2 data validation test engineers strong A2 or B1 resources for mid-April start for ~14 month engagementDatagaps to be leveraged as automation toolIdentify data sources and destinations & get the access to source datasetsDefine testing approach, Operational readiness checklistUnderstand compliance, security, risk, performance and data quality objectivesRetrieve META attributes of the dataset & data mappingDevelop SQL Scripts for the validation and Automate data validation checks using python based libraries or through Datagaps DataOps suiteExecute the Database/ETL Scripts, including for the assigned releases and reporting of issues and status reports.Maintain Data Validation scripts and assets as required by HCA coding standards.Support in defect analysis and regression testing.Data Accuracy Testing: Verifying the correctness of data values. Data Completeness Testing: Ensuring that all required data is present. Data Consistency Testing: Validating data integrity across systems. Data Transformation Testing: Verifying the correctness of data transformations. Data Quality Testing: Identifying and resolving data quality issues. Functional Testing: Verifying the functionality of Data processes from Snowflake to S3 and ADW datamarts and OBIEE reports. Regression Testing: Ensuring that changes do not introduce new defects for 1 or 2 regression cycles if open source-based data testing approach is selected. If Automated testing through Datagaps DataOps Suite is approved, Regression testing would be configured to validate for nightly / daily incremental data testing across environments.OBIEE Report Layout and Format Testing: Ensuring correct formatting and layout. Entitlements Testing: Validation of Role based access and features for Dealer Management PortalTest Data Management: Generating and managing test data required for ensuring data correctness and consistency with varying datatypes, null values and special character formats in HGI data feeds. Test Reporting and Analytics: Providing comprehensive test reports and dashboards. Orchestration: Orchestrating the testing process within a CI/CD pipeline.3 must havesETL 4/5Datagaps 4/5