Senior QA Manual Data Integrity

Lean Solutions Group; Medellín; Remote; COP 100,440,000 - 167,400,000; Full time

Job summary

Global Technology Services in Medellín, Colombia, is seeking a Senior QA Engineer focused on Data Integrity to validate data across databases, APIs, and transformations within a large-scale AWS modernization program.

You will define validation scenarios, create SQL checks, and verify data flows involving AWS Glue and event streams, ensuring consistency across systems and accurate record management.

Qualifications

• Bachelor’s degree in CS, IS, Engineering, or equivalent.
• Experience in data-related testing, including ETL testing, data pipelines, and data transformation validation.
• Intermediate SQL skills for data validation, reconciliation, and discrepancy investigation.
• Understanding of data integrity concepts and data validation processes.
• Knowledge of data modeling, including data structures, relationships, and integrity rules.
• Experience testing APIs, including request payloads and responses.
• Familiarity with JSON data structures and formats.
• Professional proficiency in written and spoken English.

Responsibilities

• Define data validation scenarios and reconcile source and target results.
• Verify record counts, relationships, business rules, and transformation logic across workflows.
• Create SQL queries, document discrepancies, and coordinate fixes with engineers.
• Validate transformations in AWS Glue or event streams and ensure consistency across systems.

Skills

SQL

APIs testing

ETL testing

Data validation

Data integrity concepts

Data modeling

English proficiency

Documentation

Education

Bachelor's degree in CS/IS/Engineering

Tools

Python

PostgreSQL

Aurora PostgreSQL

DynamoDB

AWS Glue

Kafka / MSK

JSON

Job description

Company Overview:

Global Technology Services is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer many opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries.

We’re looking for a QA Engineer focused on Data Integrity to validate data accuracy and consistency within a large scale AWS modernization program. This role focuses on data behavior across databases, APIs, transformations, and integrated workflows.

Position Title: QA Engineer Data Integrity

Category: QA & Testing

Seniority: Senior

Location: Colombia and Mexico

What you will be doing:

You will define data validation scenarios, reconcile source and target results, and verify record counts, relationships, business rules, and transformation logic. You will test data changes and investigate missing, duplicated, or inconsistent records across application workflows.

You will create SQL queries and validation checks, document discrepancies, and work with engineers to verify fixes. Where data flows involve AWS Glue or event streams, you will help validate transformations, processing results, and consistency across participating systems.

Required Skills & Experience

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
• Experience in data-related testing, including ETL testing, data pipelines, and data transformation validation.
• Intermediate-level SQL skills for data validation, reconciliation, and discrepancy investigation.
• Understanding of data integrity concepts and data validation processes.
• Knowledge of data modeling, including data structures, relationships, and integrity rules.
• Experience testing APIs, including request payloads and responses.
• Familiarity with JSON data structures and formats.
• Ability to document test scenarios, validation results, and defects clearly.
• Professional proficiency in written and spoken English.

Nice to Have Skills

• Python scripting for test automation, data validation, or reconciliation.
• Experience with PostgreSQL, Aurora PostgreSQL, or DynamoDB.
• Experience validating AWS Glue workflows, Kafka, or Amazon MSK data streams.
• Additional knowledge of data modeling and data migration validation.

Soft Skills

• Strong analytical thinking and attention to data discrepancies.
• Ability to explain data issues and their business impact to delivery teams.
• Methodical investigation, documentation, and verification of fixes.