Data QA Engineer

T
TruelogicData Analytics
Mexico CityFull-Time
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Required Skills
PythonSQLETLMicrosoft Power BIJiraTableauTestRailSelenium

Requirements

  • Advanced ability to write and execute complex SQL queries for 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.
  • Practical experience documenting full-lifecycle test plans, cases, results, and defects in JIRA or TestRail.
  • Hands-on experience with test automation tools and programming languages such as Python or Selenium.
  • Experience testing presentation layers, reports, and business logic in BI platforms such as Tableau or Power BI.
  • Familiarity with non-functional testing using tools like Apache JMeter for database load, stress, and performance testing.
  • Understanding of query execution plans, indexing strategies, and database performance tuning.

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 business intelligence reporting tools like Tableau and Power BI.
  • Build and maintain automated test scripts to execute 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 to track defects utilizing JIRA or TestRail.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now