Senior Test Lead

Title : Senior Test Lead

Location : San Antonio, TX

Exp : 9+

Job Summary

To develop comprehensive test plans based on project requirements and objectives in collaboration with project stakeholders to define testing scope, goals, and deliverables.

Key Responsibilities

1. To participate in functional as well as technical discussions with the client / team to understand functional / design specifications ,highlight performance concerns, inconsistencies ,ensure the appropriate test environments and infrastructures are in place / kept upto date.

2. To Identify opportunities for process improvement in testing methodologies / tools and Implement best practices to enhance the efficiency and effectiveness of the testing process.

3. To oversee the creation and execution of automated test scripts ensuring consistency and alignment with quality standards to minimize exposure.

4. To develop / guide and mentor QA engineers in the use of the testing framework , enhancing their technical capabilities and increasing productivity.

Additional requirement : Tech Stack : ETL testing Informatica PowerCenter, dbt Data Build Tool, SQL, Snowflake , Git, JIRA

Responsibilities

1 . QA Strategy and Planning

• 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.

2 . Informatica-Specific QA Responsibilities

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).

3. dbt-Specific QA Responsibilities

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)

4. Data ValidationReconciliation

5. Automation and DevOps Integration

6. Defect ManagementReporting

7. Coordination & Stakeholder Engagement

Candidate must have : -

Valid visa with min 8-10 months validity

Must be good with 5 days onsite working as per customer expectation along with 6 months contract to hire

Vendor SPOC must enter his contact details (Name, Email, Phone#) so that TAG can reach out for next steps if profile get shortlisted