Objectives(s)

1. Contractor successfully perform automated data level validation testing
2. Contractor shall perform automated Data Quality Validation Testing

Roles/Responsibilities:

1. Automated testing verifies that data has been migrated from multiple databases to a common database without any discrepancies.
2. Automated Business/Scenarios based Validations
3. Automated Data and Reports Integrity Validations
4. Automated Data Performance Validations

Mandatory Skills:

1. 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

2. 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

3. 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)

4. 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