Purpose of the Role
To validate data integrity, accuracy, and functionality during the migration of SAS estate (including SAS 9.4 and Viya 3.5 components) to SAS Viya 4 on DPS AWS. The Data Test Analyst ensures that migrated data and processes meet business requirements and comply with customer's standards.
Key Responsibilities: Test Planning & Design:
- Develop detailed test plans and cases for data migration, transformation, and validation.
- Define acceptance criteria for migrated datasets and analytical workflows.
Data Validation: Perform data reconciliation between SAS 9.4 and SAS Viya 4 environments.
- Validate ETL processes, data pipelines, and reporting outputs for accuracy and completeness.
Automation & Tools: Implement automated data validation scripts using SQL, Python, or SAS.
- Support integration of automated tests into CI/CD pipelines.
Defect Management
Log, track, and manage defects related to data inconsistencies or migration issues.
- Collaborate with Data Engineers and developers to resolve issues promptly.
Compliance & Governance
Ensure all testing activities adhere to the customer's security, GDPR, and data governance standards.
Collaboration
Work closely with Business Analysts, Test Manager, and migration teams to align testing with requirements.
- Support UAT and provide evidence for sign-off.
Required Skills & Experience: Strong experience in:
- Data testing and validation for large-scale migrations.
- Writing and executing SQL queries for data comparison and profiling.
Knowledge of: SAS technologies (SAS 9.4, SAS Viya 3.x/4).
- ETL processes and data integration frameworks.
Familiarity with: Test automation tools and Scripting (Python, SAS).
- Agile delivery and defect management tools (Jira, Confluence).
Desirable Qualifications: ISTQB Foundation or Advanced Test Analyst certification.
- Experience in government or regulated environments.
- Understanding of cloud platforms (AWS) and containerized deployments.