THIS OPENING IS AVAILABLE FOR CANDIDATES IN LATIN AMERICA, NOT LIMITED TO ONLY MEXICO.
Sonatafy Technology , headquartered in Scottsdale, Arizona, is an award-winning nearshore software development company with a strong reputation. They have a dedicated in-house team of engineers, offering end-to-end software solutions and supporting client development staff augmentation. Catering to companies of all sizes and industries, including some of the world's largest brands, Sonatafy Technology is a trusted provider of nearshore enterprise-level cloud and mobile application software development services.
Responsibilities:
Planning
- Collaborate with the engineering team to refine work requests in an agile development system, translating requirements into testable data quality criteria.
- Develop comprehensive test plans and test cases as part of project planning, including test strategy for validation, reconciliation, regression, and monitoring.
- Provide accurate estimates of effort and duration of QA tasks.
Testing
- Create and maintain automated tests to validate pipeline requirements, transformation logic, and downstream analytics/report outputs.
- Write and optimize SQL queries for automated validations (such as row counts, uniqueness, referential integrity, reconciliation, business-rule checks, etc.)
- Build regression suites for critical datasets and dashboards to ensure consistent numbers across releases and backfills.
- Create and maintain deterministic test datasets (fixtures) and “golden” expected results for repeatable validation.
- Assist with the verification and recreation of user-reported data issues, including data lineage/traceback from report to source.
- File detailed and actionable defect reports, including reproduction steps, expected outcomes, and evidence (queries, sample records, screenshots of report values when relevant).
- Work collaboratively with engineers to troubleshoot defects, validate fixes, and prevent recurrence via new tests and monitoring.
- Continuously improve QA processes, frameworks, and tools for data testing and validation to align with best practices.
Integration & Monitoring
- Integrate test automation with deployment automation, work tracking, and test tracking systems to enforce automated quality gates
- Schedule and manage automated test runs (PR/CI, nightly, and post-deploy), ensuring consistent and reliable execution.
- Implement data observability checks and alerting for freshness, volume, distribution/anomaly detection, and schema drift; tune alert thresholds to reduce noise.
- Collect, consolidate, and analyze test and monitoring results to identify trends, systemic issues, and opportunities to improve data reliability.
- Define and develop key performance indicators (KPIs) for measurin