ETL/Data tester
Phoenix, AZ, United States
- Pay
- Pay not listed
- Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting- Employment
Contract — employment source
Employment type in the employer’s posting: Contract
From the employer’s posting
What you’ll work on
Full postingWrite and execute test cases for ETL and data warehouse loads
Create comprehensive test plans and identify the test types needed
Validate data through profiling, auditing, balancing and reconciliation
Tune SQL queries, stored procedures and views for performance
Log and track defects in tools such as Jira
From the employer’s posting
Proficiency with Test Case Preparation & Execution
Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.)
Experience in data analysis, including profiling, auditing, balancing, and reconciliation
Experience in tuning SQL queries, Stored Procedures, Views, etc for performance improvements
Defect tracking experience (i.e. Jira, ClearQuest or HP Service Center)
What you’ll bring
All qualificationsCore experience
- 5 to 8 years of software QA experience, including data warehouse testing
- Strong SQL skills and experience writing complex queries
- Hands-on Informatica experience, including PowerCenter and DVO
- ETL and back-end testing experience with Oracle and SQL Server on Linux
- Knowledge of data warehouse and data mart testing
Qualification wording
5 -8 Years of Software Quality Assurance experience on enterprise level applications which includes some Data Warehouse Testing
Experience writing complex SQL queries
Must have Informatica DVO experience
Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required
Should have adequate experience and clear understanding of data warehouse and data mart testing
Tools in this posting
- SQL
- Oracle
- SQL Server
Source — Tool mentions in context
BGV will be done for the selected candidates. 5 -8 Years of Software Quality Assurance experience on enterprise level applications which includes some Data Warehouse Testing. · Experience writing complex SQL queries Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements, and create a comprehensive test plan that supports the business and technological solutions being delivered Required Should have experience testing multiple test phases in medium to large projects. Should have adequate experience and clear understanding of data warehouse and data mart testing. Should have strong Test Process orientation and familiarity with Test Scenario Identification and Test Data Preparation Techniques. Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation & Execution. Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required. Possess experience in using Informatica suite of tools. Should have exposure to large data sets and understand Data Quality Framework. Must have Informatica DVO experience. Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment – Experience with Oracle, SQL Server experience and Linux Defect tracking experience (i.e. Jira, ClearQuest or HP Service Center) - Experience in tuning SQL queries, Stored Procedures, Views, etc for performance improvements – Proficiency with the following Informatica tools PowerCenter Workflow Manager Workflow Monitor PowerExchange – Knowledge of data models and entity relationship diagrams – Knowledge and experience in data masking methodologies - Familiar with Meta Data Management tools Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks. Should be detail oriented with analytical mind set. Please respond with your word resume and requested details:
Posting record
Report an errorOpen 3 monthsWe first saw this posting 118 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
- Status in our records
- Live
- First seen by us
- Jul 3, 2026 · 118 days ago
- Recorded sightings
- 99
- Last seen by us
- Oct 29, 2026
- Employer says posted
- Jun 14, 2017
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
- Ask the employer about the pay range before committing time to the process.
Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.
Already applied? Track this application
Job description
Job Description
Role: ETL/Data tester
Location: Phoenix, AZ
Duration: 6+ Months
Only GC or Citizens
BGV will be done for the selected candidates.
5 -8 Years of Software Quality Assurance experience on enterprise level
applications which includes some Data Warehouse Testing. ·
Experience writing complex SQL queries Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements, and create a comprehensive test plan that supports the business and technological solutions being delivered Required
Should have experience testing multiple test phases in medium to large projects.
Should have adequate experience and clear understanding of data warehouse and data mart testing.
Should have strong Test Process orientation and familiarity with Test Scenario
Identification and Test Data Preparation Techniques.
Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation & Execution.
Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required.
Possess experience in using Informatica suite of tools.
Should have exposure to large data sets and understand Data Quality Framework.
Must have Informatica DVO experience.
Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment –
Experience with Oracle, SQL Server experience and Linux
Defect tracking experience (i.e. Jira, ClearQuest or HP Service Center) - Experience in tuning SQL queries, Stored Procedures, Views, etc for performance improvements –
Proficiency with the following Informatica tools PowerCenter Workflow Manager Workflow Monitor PowerExchange –
Knowledge of data models and entity relationship diagrams –
Knowledge and experience in data masking methodologies - Familiar with Meta Data Management tools
Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks.
Should be detail oriented with analytical mind set.
Please respond with your word resume and requested details:
Full Name :
Work Authorization:
Contact Number :
Email ID :
Skype ID:
Current location:
Willing to relocate :
Rate/hr :
Additional Information
All your information will be kept confidential according to EEO guidelines.
Company Description
IT
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Phoenix, AZ, United States
Working pattern and location restrictions need checking in the full posting.
- Work authorization
Role: ETL/Data tester Location: Phoenix, AZ Duration: 6+ Months Only GC or Citizens BGV will be done for the selected candidates.
More source context
Please respond with your word resume and requested details: Full Name : Work Authorization: Contact Number : Email ID : Skype ID: Current location: Willing to relocate : Rate/hr : Additional Information
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.