Data QA Engineer – Enterprise Data

Stack

Responsibilities

• ▹Ensure data accuracy, consistency, and completeness across pipelines by validating ETL processes, referential integrity, constraints, and data normalization
• ▹Perform comprehensive functional testing on core database objects, including stored procedures, triggers, views, and functions
• ▹Validate data migrations and write complex SQL queries to verify data correctness and system integrity
• ▹Test data pipelines, transformations, and business logic within BI reporting tools like Tableau and Power BI to guarantee accurate report generation
• ▹Build and maintain automated test scripts for seamless database regression and integration testing
• ▹Identify slow-running queries, monitor execution plans, evaluate database indexing, and collaborate with DBAs to fine-tune system performance
• ▹Partner with developers, data analysts, and product teams, tracking defects using JIRA or TestRail and driving data quality best practices

Requirements

• ▹Advanced ability to write and execute complex SQL queries for deep data verification, reconciliation, and troubleshooting
• ▹Proven track record of validating ETL and ELT data pipelines, transformation logic, and complex data warehousing environments
• ▹Hands-on experience testing database objects and structures, with a solid understanding of data normalization and schema validation
• ▹Hands-on experience documenting full-lifecycle test plans, cases, results, and defects in tools like JIRA or TestRail
• ▹Hands-on experience with test automation tools and programming languages such as Python, Selenium with SQL assertions, or custom database scripting
• ▹Familiarity with non-functional testing using tools like Apache JMeter for databases

Soft skills

About the company

Truelogic is a leading nearshore staff augmentation provider headquartered in New York, with over 600 highly skilled tech professionals in Latin America delivering digital transformation projects for U.S. companies.