QA Test Engineer – DW/ETL/BI (BHJOB22048_593)

ITmPowered    Denver, CO
Job Description
QA Test Engineer – Data Warehouse, ETL, BI The Data Warehouse Quality Assurance Test Engineer will perform full QA lifecycle on the Data Warehouse ETL and BI systems using; Informatica Powercenter 10, Mappings, Mapplets, ETL Transformations, Cognos BI Reporting, and Tableau BI Analytics platforms. Build ETL DW QA Test Plans, Test approach, test cases, test […]

QA Test Engineer – Data Warehouse, ETL, BI

The Data Warehouse Quality Assurance Test Engineer will perform full QA lifecycle on the Data Warehouse ETL and BI systems using; Informatica Powercenter 10, Mappings, Mapplets, ETL Transformations, Cognos BI Reporting, and Tableau BI Analytics platforms. Build ETL DW QA Test Plans, Test approach, test cases, test scripts, and QA Automation. Focus will be on QA Testing the Data warehouse (Oracle, SQL Server) and Test the backend data ETL pipelines (Informatica Powercenter mappings, mapplets, transformations, etc. Will also support QA efforts of the BI front ends dashboards, reports, cubes, marts (Cognos / Tableau).

Responsibilities:

  • Build and perform end to end QA effort on the Data Warehouse / ETL / BI platforms
  • BI Testing of Cognos BI Reporting and Tableau Dashboards and underlying data marts, ODS, data models.
  • QA Test Planning, test strategy, test cases, test scripting, test automation, regression, UAT, QA reporting.
  • ETL Testing of Informatica Powercenter mappings, transformations, mapplets, and data pipelines.
  • Test Informatica workflows, transformations, and mappings.
  • Source to Target data testing, Data Quality Testing, Test data completeness
  • Performance Testing and tuning of Informatica workflows. Data integration testing.
  • Data Warehouse Testing; Star, snowflake, fact, dimension tables, Oracle, SQL Server
  • Database Testing – Oracle/SQL Server, PL/SQL, queries, joins, select statements, stored procedures.
  • Read and comprehend requirements for testing purposes and able to track/analyze/resolve defects
  • Working with Visual Studio and TFS for Defect Management
  • Test automation scripting
  • Ability to identify back-end defects and being able to both recognize and relay those back the development team is a big plus
  • Qualifications / Requirements

  • 3+ yrs ETL/DW/BI Testing – Informatica, Powercenter, ETL, mappings, transforms, Cognos reports, and Tableau BI Analytics. Background in Data Warehouse and Business Intelligence.
  • 5+ yrs QA Testing – Test Plans, Test Cases, Test Scripts, test results, test issues, Test metrics, test coverage, test estimation, test requirements, traceability matrix, end to end testing, and test data sets.
  • QA Test Reporting – Defect Tracking, burn down, regression tests, coverage, bug throughput.
  • DB Back end SQL/ETL testing – ETL Informatica, Oracle, SQL Server, queries, joins, select statements.
  • 2 years of Sr. QA experience providing both Mentorship and Hands-on testing.
  • QA Project lifecycle; Test Plan, Test Strategy, Test scenarios, test cases, traceability matrix.
  • Selenium, MS Test Manager (MTM), Jira, Git, Visual Studio, TFS, MS Office
  • Strong AGILE QA software development life cycle (SDLC) – backlogs, sprints, standups, burn downs.
  • W2 only. No H1b Visa. No subcontracting.

    Local Denver, onsite full time.


    Tue, 12 Feb 2019 05:36:06 GMT

    Recent from Blog

    The Jobrino blog is written with jobseeker and employers in mind to enable them to realize their full potential. Jobrino blog is your one-stop destination to find new research about the workplace and the latest insights into the employment market.

    Top Entry Level Jobs that Pay Well Hiring Now!

    Your first entry level job can pay you anywhere between $32,000 to $76,000 according to the data collected from Salary.com. There are many highly paid...

    Read more

    A Step by Step Guide on How to Write Resume [ 2018 ]

    Not sure how to write resume to find a jobs in your field? Need right and structured information on how to write resume for your future job? This article can help you write effective and step by step resume that maximize the chances of getting interview and being ...

    Read more

    What things to bring to a Job Interview– Job Interview Tips

    It is very important to be prepared for everything with physically to mental need, well organized and ready to go when you attend a job interview. You should start preparing for your interview as soon as a company gets in touch with you about your candidacy. Below ...

    Read more

    6 Coolest Entry Level Jobs To Apply For In 2018

    Time flies doesn’t it? We’re almost through a quarter of 2018! However, the minutes and hours only drag slowly when you’re in a job that doesn’t quite fit your dreams or your lifestyle. Quit wasting your energy in a job that doesn’t satisfy you or...

    Read more