• Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role.
United States Jobs Expertini

ETL/ Datawarehouse QA Job Opening In San Antonio – Now Hiring eTeam


Job description

Responsibilities
.

QA Strategy and Planning
• 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.
.

Informatica-Specific QA Responsibilities
• 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 staging/ODS 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.
.

dbt-Specific QA Responsibilities
• 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.
.

Data Validation & Reconciliation
• 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.
.

Automation and DevOps Integration
• 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.
.

Defect Management & Reporting
• 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.

Required Skill Profession

Computer Occupations


  • Job Details

Related Jobs

Apex Systems hiring QA ETL Tester Job in Charlotte, North Carolina, United States
Apex Systems
Charlotte, North Carolina, United States
Charles Schwab hiring ETL QA Engineer Job in Southlake, TX, United States
Charles Schwab
Southlake, TX, United States
Mitchell Martin hiring Etl qa tester Job in Charlotte, North Carolina, , United States
Mitchell Martin
Charlotte, North Carolina, , United States
Phaxis LLC hiring QA Lead - ETL Job in Chicago, Illinois, , United States
Phaxis LLC
Chicago, Illinois, , United States
Cynet Systems hiring QA ETL Test Engineer Job in Smithfield, Rhode Island, United States
Cynet Systems
Smithfield, Rhode Island, United States
Zelis hiring Senior ETL QA Engineer Job in , INDIA HYDERABAD, United States
Zelis
, INDIA HYDERABAD, United States
CYNET SYSTEMS hiring QA ETL Test Engineer Job in Smithfield, Rhode Island, , United States
CYNET SYSTEMS
Smithfield, Rhode Island, , United States
NTT DATA hiring Datawarehouse Architect Job in Oaks, Pennsylvania, , United States
NTT DATA
Oaks, Pennsylvania, , United States
Expert In Recruitment Solutions hiring ETL/SQL QA Test Analyst Job in Tampa, Florida, , United States
Expert In Recruitment Solutions
Tampa, Florida, , United States
Phaxis LLC hiring QA Lead - ETL & Kafka Job in New York County, New York, , United States
Phaxis LLC
New York County, New York, , United States
Saviance Technologies hiring QA Engineer   ETL & HL7 (Data Pipeline QA) Job in Boston, Massachusetts, , United States
Saviance Technologies
Boston, Massachusetts, , United States
Artech LLC hiring Snaplogic Datawarehouse Developer Job in Plano, Texas, United States
Artech LLC
Plano, Texas, United States
Artech LLC hiring Snaplogic Datawarehouse Developer Job in Plano, Texas, , United States
Artech LLC
Plano, Texas, , United States
Lorven Technologies hiring Datawarehouse Analyst-Tallahassee, FL- Onsite Job in Tallahassee, Florida, United States
Lorven Technologies
Tallahassee, Florida, United States
Stellar Professionals hiring ETL developer Job in Jackson, Mississippi, United States
Stellar Professionals
Jackson, Mississippi, United States
Red Hill Consulting Llc hiring ETL Developer Job in New York, New York, United States
Red Hill Consulting Llc
New York, New York, United States
QuEST Global Services Pte. Ltd hiring ETL Developer Job in united states, united states, United States
QuEST Global Services Pte. Ltd
united states, united states, United States
The Judge Group hiring ETL Developer Job in Los Angeles, California, United States
The Judge Group
Los Angeles, California, United States
MassGenics hiring ETL Sr.Developer Job in Santa Clara, California, United States
MassGenics
Santa Clara, California, United States
Confidential hiring ETL Developer Job in remote, us, remote, us, United States
Confidential
remote, us, remote, us, United States
Tata Consultancy Services hiring ETL Developer Job in Pleasanton, California, United States
Tata Consultancy Services
Pleasanton, California, United States
CGI Technologies and Solutions, Inc. hiring ETL Developer Job in Fairfax, VA, United States
CGI Technologies and Solutions, Inc.
Fairfax, VA, United States
CGI Technologies and Solutions, Inc. hiring ETL Developer Job in Fairfax, VA, United States
CGI Technologies and Solutions, Inc.
Fairfax, VA, United States
Virtusa hiring ETL Tester Job in New York, New York, United States
Virtusa
New York, New York, United States
Truist hiring ETL Lead Job in Charlotte, North Carolina, United States
Truist
Charlotte, North Carolina, United States
Zone IT Solutions hiring ETL Developer Job in Houston, Texas, United States
Zone IT Solutions
Houston, Texas, United States
Openkyber hiring ETL Developer Job in United States
Openkyber
United States
Citigroup hiring ETL Developer Job in Tampa, FL, United States
Citigroup
Tampa, FL, United States
Leidos hiring ETL Developer Job in Bethesda, MD, United States
Leidos
Bethesda, MD, United States
Steampunk hiring ETL Engineer Job in McLean, VA, United States
Steampunk
McLean, VA, United States
System One hiring ETL Lead Job in Farmers Branch, TX, United States
System One
Farmers Branch, TX, United States
ManpowerGroup hiring ETL Developer Job in New York, NY, United States
ManpowerGroup
New York, NY, United States

Unlock Your ETL Datawarehouse Potential: Insight & Career Growth Guide


Real-time ETL Datawarehouse Jobs Trends (Graphical Representation)

Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph here. Uncover the dynamic job market trends for ETL Datawarehouse in San Antonio, United States, highlighting market share and opportunities for professionals in ETL Datawarehouse roles.

300 Jobs in United States
300
9 Jobs in San Antonio
9
Download Etl Datawarehouse Jobs Trends in San Antonio and United States

Are You Looking for ETL/ Datawarehouse QA Job?

Great news! is currently hiring and seeking a ETL/ Datawarehouse QA to join their team. Feel free to download the job details.

Wait no longer! Are you also interested in exploring similar jobs? Search now: .

The Work Culture

An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at eTeam adheres to the cultural norms as outlined by Expertini.

The fundamental ethical values are:

1. Independence

2. Loyalty

3. Impartiapty

4. Integrity

5. Accountabipty

6. Respect for human rights

7. Obeying United States laws and regulations

What Is the Average Salary Range for ETL/ Datawarehouse QA Positions?

The average salary range for a varies, but the pay scale is rated "Standard" in San Antonio. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

What Are the Key Qualifications for ETL/ Datawarehouse QA?

Key qualifications for ETL/ Datawarehouse QA typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. The generic skills are mostly outlined by the . Be sure to check the specific job listing for detailed requirements and qualifications.

How Can I Improve My Chances of Getting Hired for ETL/ Datawarehouse QA?

To improve your chances of getting hired for ETL/ Datawarehouse QA, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

Interview Tips for ETL/ Datawarehouse QA Job Success

eTeam interview tips for ETL/ Datawarehouse QA

Here are some tips to help you prepare for and ace your ETL/ Datawarehouse QA job interview:

Before the Interview:

Research: Learn about the eTeam's mission, values, products, and the specific job requirements and get further information about

Other Openings

Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.

Dress Professionally: Choose attire appropriate for the company culture.

Prepare Questions: Show your interest by having thoughtful questions for the interviewer.

Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.

During the Interview:

Be Punctual: Arrive on time to demonstrate professionalism and respect.

Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.

Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.

Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.

Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.

Follow Up: Send a thank-you email to the interviewer within 24 hours.

Additional Tips:

Be Yourself: Let your personality shine through while maintaining professionalism.

Be Honest: Don't exaggerate your skills or experience.

Be Positive: Focus on your strengths and accomplishments.

Body Language: Maintain good posture, avoid fidgeting, and make eye contact.

Turn Off Phone: Avoid distractions during the interview.

Final Thought:

To prepare for your ETL/ Datawarehouse QA interview at eTeam, research the company, understand the job requirements, and practice common interview questions.

Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the eTeam's products or services and be prepared to discuss how you can contribute to their success.

By following these tips, you can increase your chances of making a positive impression and landing the job!

How to Set Up Job Alerts for ETL/ Datawarehouse QA Positions

Setting up job alerts for ETL/ Datawarehouse QA is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!