More jobs:
ETL/Datawarehouse QA
Job in
San Antonio, Bexar County, Texas, 78208, USA
Listed on 2026-01-12
Listing for:
TechDigital Group
Full Time
position Listed on 2026-01-12
Job specializations:
-
IT/Tech
Data Analyst, IT QA Tester / Automation
Job Description & How to Apply Below
Responsibilities
- Define QA strategy for a hybrid ETL stack involving Informatica and dbt for transformation/modeling.
- Analyze STTMs (Source-to-Target Mapping documents), business rules, and dbt model definitions to derive test scope.
- Plan and manage test phases across Program Increments (PIs) or releases: unit testing support, system testing, integration testing, and UAT support.
- Review and validate Informatica mappings, workflows, sessions, and parameter files.
- Validate source data extraction (flat files, RDBMS, mainframes, etc.), data transformations, and load strategies to staging/ODS layers.
- Use SQL queries and data comparison tools for reconciliation and validation.
- Validate job dependencies, control table mechanisms, and monitor job runs via Informatica Monitor/Workflow logs.
- Validate dbt models, tests, and documentation.
- Review and test model SQL logic, YAML files, and dbt tests.
- Execute dbt test suites, investigate failures, and collaborate with analytics engineers on model strategies.
- Review generated SQL to ensure correct transformations.
- Perform data validation across source to analytics layers.
- Write complex SQL queries for data comparison and validation.
- Ensure data consistency, integrity, and validate PII masking where applicable.
- Build reusable SQL-based test automation scripts.
- Integrate QA checks into CI/CD pipelines using git Actions.
- Monitor and validate batch schedules and jobs, and contribute to QA dashboards and reports.
- Log and track defects in JIRA, categorize by layer and severity.
- Facilitate defect triage calls and provide status reports and coverage metrics.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×