Purpose of the Role
To validate data integrity, accuracy, and functionality during the migration of Client's 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 Client 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 Client 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.