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.

    Overview About the OPT Jobs in USA

    Optional Practical Training (OPT) is a temporary employment facility provided by the USA government to the International Students. The OPT for F1 students during which undergraduate and graduate students who have completed or pursuing their degrees for more than ...

    Read more

    Dual Side Impact of Choosing Accounting Career Path

    This blog is written on why you need to choose accounting career path. The advantages and path way shown in this piece of ...

    Read more

    10 Best Job Opportunities in USA Check Out and Apply now

    The person is not too old to set another goal or to dream a new dream. Switching to the better company or role can energized your career and offer some of the benefits you have wished: that have a better work-life balance, culture, best job opportunities ample ...

    Read more

    Top 10 Soft Skills for Job Seekers To Put On Resume [2018]

    In order to catch the eye of your recruiter it is important to not just have an impressive list of technical or hard skills but to have equally impressive interpersonal skills. Soft skills are today’s power skills. These skills are essential in ...

    Read more