Job Details

ID #43310272
State Michigan
City Detroit metro
Job type Contract
Salary USD USD0 - USD0 USD0 - USD0
Source Strategic Staffing Solutions
Showed 2022-06-19
Date 2022-06-18
Deadline 2022-08-17
Category Et cetera
Create resume

ETL Tester

Michigan, Detroit metro, 48201 Detroit metro USA

Vacancy expired!

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING!

Strategic Staffing Solutions is currently looking for an ETL Tester for a contract opportunity with one of our largest clients located in Detroit, MI!

Title: ETL Tester

Location: Detroit, MI

Duration: 12+ Months

Role Type: W2 contract engagement

Job Description/ Responsibilities:With general guidance and coaching, participates in developing and executing test scenarios for unit, process, function, system integration and acceptance testing. Develops test cases, scenarios, and scripts to ensure applications quality. Designs and develops usability testing scenarios and administers portions of testing process. Defines criteria for testing, analyzes results of testing sessions and presents results. Participates in selection of testing tools and approaches. Utilizes appropriate testing tools and testing processes on projects and assists in building test environments.

Qualifications/Skills:
  • 5+ years experience writing complex SQL queries
  • 5+ years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing
  • QA Testing experience must be in both manual and automated testing environments, with a strong focus in both as manual testing experience is required to create the automated test cases and SQL statements. Automated testing experience should be with IBM Rational Tools.
  • Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques.
  • 5+ years experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment.
  • 5+ years Oracle experience
  • 3+ Years experience with Unix
  • Advanced knowledge of MS Office suite tools required with a focus on advanced knowledge of Microsoft Excel for the purpose of creating test grids and using formulas to compare test results.
  • Ability to convert requirements documents (Business Requirements, Functional and Technical Requirements) into test strategies/plans, test scenarios and test cases, including appropriate SQL scripts to execute testing cases.
  • Ability to evaluate the “testability” of requirements and reports to project team member’s changes or additional information needed in requirements
  • Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.) and create a comprehensive test plan that supports the business and technological solutions being delivered
  • Ability to coordinate test execution across multiple teams
  • Defect tracking experience (i.e. ClearQuest or HP Service Center)
  • Experience in tuning SQL queries for performance improvements
  • Proficiency with the following Informatica tools
    • Informatica PowerCenter 10.2
    • Informatica PowerExchange 10.2
  • 2-3 years strong experience in:
    • Hadoop
    • RedShift Database
    • Tableau
    • Writing Test Scripts in:
  • Hive/Impala
  • PostGres

Preferred Skills/Experience
  • 2+ years current experience with the following Rational Tools
    • Rational ClearQuest (RCQ)
  • 2+ years experience with Cognos (Version 10 or higher)
  • General health care knowledge in any of the major subject areas listed below:
    • Medical claims
    • Memberships
    • Pharmacy claims
    • Customers
  • Knowledge of Toad for Oracle is a plus
  • Knowledge of Databricks is a plus
  • Specific experience working with the Enterprise Data Warehouse is a plus
  • Working knowledge of scheduling tools, such as Tivoli and Stonebranch
  • Prior Mainframe experience is a plus
  • Tableau experience is a plus

Vacancy expired!

Subscribe Report job