ETL/Data tester

Info-Ways; Phoenix (AZ); On-site; USD 48,216 - 75,768; Full time

Job summary

A leading software solutions provider is looking for an experienced ETL/Data tester in Phoenix, AZ. The role requires 5-8 years of Software Quality Assurance experience on enterprise-level applications, alongside complex SQL querying and data warehouse testing knowledge. Ideal candidates should have expertise in ETL testing, familiarity with Informatica tools, and the capability to analyze large datasets. This position is full-time and includes responsibilities across different testing types within a team environment.

Qualifications

• 5-8 years of experience in Software Quality Assurance on enterprise-level applications.
• Experience writing complex SQL queries for comprehensive test plans.
• Understanding of data warehouse and data mart testing.

Responsibilities

• Determine necessary testing types like data validation and regression.
• Support business and technological solutions through testing.
• Conduct thorough back-end/ETL testing.

Skills

Software Quality Assurance

Complex SQL querying

Data Warehouse Testing

ETL testing

Data analysis

Defect tracking

Ability to tune SQL queries

Data Quality Framework understanding

Tools

Informatica PowerCenter

Jira

SQL Server

Oracle

Linux

Job description

Role: ETL/Data tester
Location: Phoenix, AZ
Duration: 6+ Months

Only GC or Citizens. Background verification will be performed for selected candidates.

Responsibilities & Qualifications

• 5-8 Years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.
• Experience writing complex SQL queries and evaluating the testability of requirements to create comprehensive test plans.
• Ability to determine necessary testing types (data validation, regression, etc.) and support business and technological solutions.
• Experience testing multiple phases in medium to large projects.
• Clear understanding of data warehouse and data mart testing.
• Strong test process orientation and familiarity with test scenario identification and test data preparation techniques.
• Thorough knowledge of the Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle, and proficiency with test case preparation and execution.
• Extensive exposure to back‑end/ETL testing with advanced SQL skills.
• Experience using the Informatica suite of tools, including PowerCenter, Workflow Manager, Workflow Monitor, and PowerExchange.
• Informatica DVO experience and familiarity with data masking methodologies.
• Experience with large data sets and understanding of a Data Quality Framework.
• Proficiency in data analysis, profiling, auditing, balancing, and reconciliation within an IT operating environment.
• Experience with Oracle, SQL Server, and Linux.
• Defect tracking experience (e.g., Jira, ClearQuest, HP Service Center).
• Ability to tune SQL queries, stored procedures, and views for performance improvements.
• Knowledge of data models and entity‑relationship diagrams.
• Familiarity with metadata management tools.
• Strong multi‑tasking skills, adaptability to change, and urgency in task completion.
• Detail‑oriented with an analytical mindset.

Application Instructions

Please provide your resume and the requested details below:

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