ETL / Data Warehouse Tester (Back-End) - W2 - Remote EST hours (Posted by SAM)

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

Data Warehouse
Datastage
Extract
Transform
Load
Informatica
Oracle
Microsoft SQL Server
SQL
Python
Snow Flake Schema
IBM InfoSphere DataStage

Job Details

Job Description & Requirement:

  • Create test automation scripts (Python) and leverage tools for validating data and application functionality.
  • Over 7 years of professional work experience (or equivalent experience) is required.
  • Build and execute test cases to ensure the integrity of all production solutions deployed on the enterprise data platform including data pipelines, data warehouses, data marts and data sharing repositories
  • Deep understanding of data warehousing concepts
  • Hands on testing experience on back-end data / data warehouses is required. Strong in data validation testing / ETL validation testing
  • Expert in SQL and knowledge on Python will be a plus.
  • Advanced SQL experience is required along with being an expert in writing SQL queries
  • Experience working on cloud technologies like Snowflake Snowflake will take preference over any other cloud
  • Strong knowledge of SDLC process
  • Experience with Enterprise Database technologies like SQL Server, Oracle, Data Integration (Informatica, DataStage), business intelligence, and reporting tools.
  • Experience creating test automation frameworks and test cases
  • Identify opportunities for productivity gains through quality engineering process improvements and in the Agile development lifecycle; develop procedures and proposals and lead the implementation of these changes.
  • Demonstrated experience performing functional, end-to-end and regression testing.
  • Document and analyze test results and recommend corrective action.
  • Isolate, reproduce, manage, and maintain defects and test case databases, and verify fixes.
  • Support user acceptance testing conducted by business partners or end users.
  • Identify opportunities to reduce testing time and effort by automating repeatable tests.
  • Define and champion quality and testing best practices among development teams
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.