This page is optimized for mobile devices, if you would prefer the desktop version just click here

Location: US - New Jersey - Convent Station
Category:
Posted: June 30, 2024

Job Title: QA Engineer, Data Warehousing

Job Location: Morristown NJ 07960

Onsite Requirements:

  • 5+ years QA experience in ETL/DW/BI environments
  • SSIS and MS SQL Server experience
  • Experience with Insurance Data Warehouse, data and its processes.

  • We are looking for innovative, talented, and self-motivated
  • Individuals interested in working with a cross-functional team focused on implementing and supporting our internal data warehouse.

Key Objectives:

  • Hands-on experience with:
  • EDW source to target testing (SQL scripting - manual and automation).
  • Data transformation/manipulation testing (SQL scripting - manual and automation).
  • Data quality/completeness validation (SQL scripting - manual and automation).
  • Experience in running the processes through the scheduler.
  • Quality Assurance, Process Improvement and Collaboration:
  • Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses.
  • Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.
  • Identify, document, and track data quality issues, working closely with data engineers to resolve them.
  • Validate data loading, transformation, and aggregation processes.
  • Ensure data consistency and integrity across different data sources and systems.
  • Collaborate with the Data Quality and Data Engineering team to define quality benchmarks and metrics.
  • Continuously improve QA testing strategies and methodologies.
  • Implement best practices for data validation and error handling.
  • Assist in the design and implementation of data quality assurance tools and frameworks.
  • Work closely with BA, data architect, data engineers, QA and stakeholders to understand data requirements and deliverables.
  • Work closely with the Lead Data QA Engineer to design, develop, maintain and support testing infrastructure.
  • Provide detailed reports on data quality findings and testing outcomes.
  • Extensively use Task management and defect management tool (i.e. Jira and Confluence) to manage deliverable.
  • Well versed with the comprehensive QA testing methodology (i.e. functional, non-functional, system, regression, smoke test, performance testing, black box testing, etc.).
  • Contribute insights and recommendations to enhance data quality and processing efficiency.

You're a Great Fit If You Have:

  • Minimum 3 to 5 years of Quality Assurance experience (manual/automated testing) with a proven track record of improving Data Quality by implementing QA best practices within organization.
  • SSIS & MSSQL experience (intermediate or senior level).
  • Experience with Insurance Data Warehouse, data and its processes
  • Experience with the Snowflake and DBT is a plus.
  • Experience in using QA automation tools.
  • ETL process knowledge; Knowledge of data warehouse testing procedures.

Desirable qualifications/pluses:

  • Knowledge of Insurance Data & its processes.
  • Data validation experience between on-prem & cloud (i.e. hybrid) architecture.
  • Familiarity with cloud computing and the data ecosystem on Snowflake.

Requirements:

  • Bachelors or master's in computer science or equivalent.
  • Experience with Insurance Data Warehouse, data and its processes
  • Strong understanding of Data Warehouse & Data Quality fundamentals.
  • 3 to 5 years of experience in data warehouse development/testing.
  • 3 to 5 years of experience with SQL Server and SSIS/SSAS/SSRS testing.
  • Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.
  • Strong in SQL, RDBMS, ETL, and DW concepts.
  • Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.

* 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply.

This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. *

Read the full job description and apply online on the recuiter's web-site

Find Jobs Hiring Now!

What: Where:

Get Jobilize Job Search Mobile App Now

Receive real-time job alerts and never miss the right job again


Related Job Postings

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Lakewood
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Englishtown
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Cherry Hill
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Hackettstown
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Atlantic City
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Randolph
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Brick
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Dover
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Howell
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - North Bergen
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Plainfield
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Willingboro
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Clifton
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Old Bridge
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Union
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - North Brunswick
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Middletown
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Ridgewood
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Wayne
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - East Brunswick
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Orange
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Lawrence Township
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Software Consultant

Company: JobRialto
Location: United States - NJ - NJ - Jersey City
Posted: June 30, 2024
Description • Work with a variety of teams across the Technology department to evaluate, estimate, develop and create high impact projects on schedule • Perform solution analysis, translating requirements into design specifications. • Implement applications, Micro Frontends and Micro Services, along read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Woodbury
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - East Orange
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Union City
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Senior Manager Business Development - Municipal Governments

Location: United States - NJ - NJ - Westwood
Posted: June 30, 2024
Requisition ID: 106154 • Share Our Purpose. Be Yourself. Feel Valued. • People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages read more...
View Job Details

Explore more jobs in Convent Station   Explore more jobs
Jobilize.com uses cookies to ensure that you get the best experience. By continuing to use Jobilize.com web-site, you agree to the Terms of Use and Privacy Policy.