Abode TechZone, LLC · 5 months ago
ETL TESTER
San Antonio,, TX
Full-time
Onsite
Senior Level
7+ years expAbode TechZone, LLC is seeking an ETL Tester to manage the testing efforts for their projects. The role involves planning, deploying, and executing testing strategies to ensure quality standards are met, while also mentoring QA engineers and creating automated test scripts.
Human ResourcesRecruitingStaffing Agency
Responsibilities
To participate in functional as well as technical discussions with the client /team to understand functional /design specifications ,highlight performance concerns, inconsistencies ,prepare automated test scripts,maintain test case suite,ensure the appropriate test environments and infrastructures are in place/kept upto date
To develop and continuously improve automated tests as new system features/ enhancements are developed and accordingly create work plans| monitor and track the work schedule for on time delivery as per the defined quality standards
To create reusable /scalable test automation framework, develop test strategies/plans, maintain test data and to submit status reports for minimizing exposure and risks on the project or closure of escalations
To develop/guide and mentor QA engineers in the use of the testing framework , enhancing their technical capabilities and increasing productivity
Define QA strategy for a hybrid ETL stack involving Informatica, and dbt for transformationmodeling
Analyze STTMs (SourcetoTarget 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: o Source data extraction (flat files, RDBMS, mainframes, etc.) o Data transformations via mappings (joins, lookups, aggregations, filters, etc.) o Load strategies to stagingODS layers (insert/update strategies, truncate/load, CDC)
Use SQL queries and data comparison tools to perform reconciliation and transformation validation
Validate job dependencies and control table mechanisms (if used)
Monitor job runs via Informatica Monitor/Workflow logs, and ensure correct execution paths
Validate dbt models, tests, and documentation in the analytics layer
Review and test: o Model SQL logic for business rule accuracy and performance o YAML files for correct metadata and testing configurations o dbt tests (unique, not null, accepted values, relationships, custom tests)
Execute dbt test suites using dbt test and investigate failures
Collaborate with analytics engineers to validate , materialization strategies (table, view, incremental), and source freshness logic
Review generated SQL in target/compiled to ensure correct transformations
Perform full and sampled data validation across source ? staging ? ODS ? analytics data layers
Write complex SQL queries to compare record counts, aggregates, and field-level data across layers
Ensure data consistency and integrity using both manual validation and dbt tests
Validate PII masking and data obfuscation where applicable
Build and maintain reusable SQL-based test automation scripts for recurring validations
Integrate QA checks in CI/CD pipelines using git Actions
Monitor and validate Informatica batch schedules and dbt Cloud jobs (or CLI triggers)
Contribute to QA dashboards and test reporting automation
Log and track defects in JIRA, categorize by layer (Informatica/dbt), and severity
Facilitate daily defect triage calls with data engineering teams
Provide detailed test execution status reports and test coverage metrics by data domain
Qualification
Required
7+ years of experience in ETL testing
Experience with Informatica PowerCenter
Experience with dbt Data Build Tool
Proficient in SQL
Experience with Snowflake
Familiarity with Git
Experience with JIRA
Ability to participate in functional and technical discussions
Experience in creating automated test scripts and maintaining test case suite
Ability to develop and improve automated tests as new features are developed
Experience in creating reusable/scalable test automation frameworks
Ability to develop test strategies/plans and maintain test data
Experience in mentoring QA engineers
Ability to define QA strategy for hybrid ETL stack
Experience in analyzing STTMs and business rules
Ability to plan and manage test phases across Program Increments or releases
Experience in reviewing and validating Informatica mappings and workflows
Ability to validate source data extraction and data transformations
Experience in using SQL queries for reconciliation and transformation validation
Ability to monitor job runs via Informatica Monitor/Workflow logs
Experience in validating dbt models and tests
Ability to execute dbt test suites and investigate failures
Experience in performing data validation across data layers
Ability to write complex SQL queries for data comparison
Experience in building and maintaining SQL-based test automation scripts
Ability to integrate QA checks in CI/CD pipelines
Experience in logging and tracking defects in JIRA
Ability to provide detailed test execution status reports
Company
Abode TechZone, LLC
Abode TechZone LLC is fast growing staffing corporation, business growth depends on putting the right people in place — the professional talent that sets your organization apart from the competition.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase