What are the responsibilities and job description for the QA Tester position at Dexian?
Background and Context
The Data Engineer in this role will support programs involving one or more of the following:
- Responsible for independently verifying that data transformations match business requirements, historical data is accurately archived, and the overall system is free of data defects prior to production go-live.
Scope of Work
Pipeline Development and Implementation
- Review STTMs, Data Quality Rulebooks, and business requirements to develop comprehensive test plans and edge cases.
- Design automated test scripts for data pipelines and migration loads.
Solution Design and Optimization
- Execute complex SQL queries to compare legacy source data against AWS/Azure target data to ensure 100% schema and value alignment.
- Validate the successful application of data masking, PII encryption, and RBAC rules.
- Test the rollback protocols and data refresh mechanisms.
Stakeholder Engagement and Change Management
- Coordinate closely with the Business Analyst to plan and execute User Acceptance Testing (UAT) cycles.
- Assist business users during UAT by explaining testing dashboards, reports, and how to verify data set
- Participate in triage meetings with developers to prioritize defect
Governance, Ethics, and Risk
- Log, track, and manage data defects in Jira/Azure DevOps, tracing them back to specific pipeline code or mapping errors.
- Validate that read-only archives comply with immutability requirements.
Documentation and Reporting
- Generate formal pre-migration and post-migration reconciliation reports.
- Document test execution results to serve as official audit artifacts for compliance teams.
Required Qualifications and Experience
Education
- Bachelor's or Master's in Computer Science, Data Engineering, or a related quantitative field.
Certifications (Preferred)
- STQB Certification or equivalent QA credentials.
Mandatory Experience
- 3-5 years as a QA Analyst or Data Tester, specifically focused on data warehouses, complex ETL pipelines, or massive data migrations.
Technical Knowledge
- Advanced to Expert SQL is mandatory.
- Experience with automated data testing frameworks (e.g., dbt tests, Great Expectations) and bug tracking tools.
Core Competencies
- Highly analytical mindset, uncompromising stance on data quality, and the ability to systematically investigate root causes of data discrepancies.
Dexian stands at the forefront of Talent Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.
Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.