What are the responsibilities and job description for the Test Validation Engineer position at STONEGATE TECHNOLOGIES LLC?
Job Title: QA Tester — Jira Migration / Data Validation Testing
Location: Plano, Texas (Onsite) (only Local candidates)
Long term
Project description:
We are seeking a QA Tester to support end-to-end testing of a Jira data migration initiative involving multiple source repositories being normalized, deduplicated, staged, and migrated into a new Jira configuration. The QA Tester will be responsible for creating and executing test plans, validating migrated data, supporting regression testing, and confirming that archived source data in Snowflake is accurate and usable for reporting.
Responsibilities:
Develop QA test plans and test cases for Jira data migration activities.
Validate data extraction, transformation, deduplication, staging, loading, and archival processes.
Test migrated Jira entities including projects, issues, epics, stories, tasks, subtasks, users, comments, attachments, links, workflows, statuses, priorities, labels, custom fields, and history.
Execute functional testing in the target Jira environment to verify usability and configuration alignment.
Validate data completeness, record counts, field mappings, referential integrity, and business rules.
Perform negative testing and exception testing for invalid, missing, duplicate, or inconsistent data.
Support regression testing across multiple migration cycles and dry runs.
Track defects, document findings, retest fixes, and support defect triage.
Validate Snowflake archival data against source repositories and reporting requirements.
Support UAT preparation, execution, and business sign-off.
Produce QA execution summaries, defect reports, and final migration validation reports.
QA test strategy.
Test plans and test cases.
Source-to-target validation scripts.
Data reconciliation reports.
Defect logs and retest evidence.
UAT support materials.
Snowflake archival validation results.
Final migration QA sign-off report.
Must have skills :
Strong QA/testing experience in data migration, ETL, or enterprise application migration projects.
Strong SQL skills for data validation, reconciliation, and defect investigation.
Experience writing test plans, test cases, test scripts, and test execution reports.
Experience validating source-to-target mappings and transformation rules.
Familiarity with data quality testing, count reconciliation, duplicate detection, and referential integrity checks.
Experience using defect tracking tools, preferably Jira.
Ability to work closely with ETL developers, data analysts, Jira administrators, and business users.
Nice to have
Experience testing Jira migration or Atlassian platform implementations.
Experience with Snowflake validation and reporting data QA.
Experience testing APIs, file-based data loads, and semi-structured data.
Familiarity with tools such as Postman, Python, Excel, Power BI, Tableau, or data comparison utilities.
Experience with Agile testing, sprint-based QA, and UAT coordination.
Experience with migration dry runs, cutover testing, and post-production validation.