Senior QA Engineer - Data Integrity & ETL Validation

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

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.