Software Development Engineer in Test (SDET) – Automated Migrated Data Validation Testing
Share
Job Location:
Algona, WA - USA
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
Objectives(s)
- Contractor successfully perform automated data level validation testing
- Contractor shall perform automated Data Quality Validation Testing
Roles/Responsibilities:
- Automated testing verifies that data has been migrated from multiple databases to a common database without any discrepancies.
- Automated Business/Scenarios based Validations
- Automated Data and Reports Integrity Validations
- Automated Data Performance Validations
Mandatory Skills:
- 8 year of SQL and Database Expertise
Why it matters: Data migration testing heavily involves validating data integrity completeness and transformation logic.
Key skills:
- Writing complex SQL queries
- Understanding of relational databases (e.g. SQL Server Oracle PostgreSQL)
- Data comparison and reconciliation techniques
- Scripting and Programming (e.g. Python Java C# JMeter)
Why it matters: Automation of data validation and transformation checks often requires custom scripts.
Key skills:
- Writing reusable test scripts
- Parsing and comparing large datasets
- Integrating with APIs or ETL tools
- Test Automation Frameworks
Why it matters: Automating regression tests for migrated data ensures consistency and saves time.
Key skills:
- Experience with tools like Selenium TestNG PyTest or JUnit
- Building data-driven test cases
- CI/CD integration (e.g. Azure DevOps GitHub)
- ETL and Data Pipeline Testing
Why it matters: Understanding how data is extracted transformed and loaded is crucial for validating the migration process.
Key skills:
- Familiarity with ETL tools (e.g. SSIS Informatica Azure Dataverse)
- Validating transformation logic
- Monitoring and logging data flows
Desirable Skills: N/A
Key Skills
- Python
- SOC
- Debugging
- C/C++
- FDA Regulations
- Minitab
- Technical Writing
- GAMP
- OS Kernels
- Perl
- cGMP
- Manufacturing
