QA Engineer, Data Warehousing

1 week ago


Convent Station, United States Soft-World Full time

Job Title: QA Engineer, Data Warehousing

Any additional information you require for this job can be found in the below text Make sure to read thoroughly, then apply.

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.

Job Description:

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. **


  • Data Engineer

    3 weeks ago


    Convent Station, United States RIT Solutions, Inc. Full time

    Job Title: Data Engineer Location: Columbus, OH (Hybrid) Duration: 6 months contract to Hire Job Description: Supplier notes: data pipeline Java Spark must have- TerraData and database knowledge. AWS, ETL are preferred. informatica or abinito CI/CD and data warehouse concept Java/ Spark must Snowflake knowldge MUST have - teradata, DBMS knowledge...

  • GW Automation QA Lead

    4 weeks ago


    Convent Station, United States Ampcus Incorporated Full time

    ROLE TITLE GW Automation QA LeadROLE LOCATION(S) Morristown, NJROLE SUMMARYThe customer is seeking a seasoned Automation Quality Assurance professional with a minimum of 10 years of experience in QTP/UFT, Selenium Automation testing. The role involves leading a QA team across onsite and offshore locations. The ideal candidate will possess a strong...

  • GW Automation QA Lead

    4 weeks ago


    Convent Station, United States Ampcus Full time

    ROLE TITLE GW Automation QA Lead ROLE LOCATION(S) Morristown, NJ ROLE SUMMARY The customer is seeking a seasoned Automation Quality Assurance professional with a minimum of 10 years of experience in QTP/UFT, Selenium Automation testing. The role involves leading a QA team across onsite and offshore locations. The ideal candidate will possess a strong...

  • GW Automation QA Lead

    2 months ago


    Convent Station, United States Vertex Computer Systems Full time

    Are you a Guidewire Automation QA Lead If so, check out this job !Vertex is a US-based tech company with 15 years experience in Microsoft, Salesforce, BI, AI, and Cloud Computing. We have earned longstanding client relationships as trusted, long-term partners. Every day we inspire, innovate, and implement solutions that solve complex business problems using...

  • GW Automation QA Lead

    4 weeks ago


    Convent Station, United States Vertex Computer Systems Full time

    Are you a Guidewire Automation QA Lead If so, check out this job !Vertex is a US-based tech company with 15 years experience in Microsoft, Salesforce, BI, AI, and Cloud Computing. We have earned longstanding client relationships as trusted, long-term partners. Every day we inspire, innovate, and implement solutions that solve complex business problems using...


  • Convent Station, United States DataMotion Full time

    DataMotion, headquartered in Morristown, NJ, is a trusted leader in secure digital exchange solutions for regulated industries. Our Secure Customer Engagement Platform, which leverages Generative AI and a zero-trust design, fosters seamless interactions, empowering organizations to navigate their digital transformation and customers’ journey...


  • Convent Station, United States Interactive Resources LLC Full time

    Location: Morristown, NJ, Purchase, NY, Conshohocken, PA or Charlotte, NC Sponsorship is Not Available Candidates MUST possess prior experience in the insurance industry. Job Description: Our industry leading client is in search of a VP, Global IT Quality Assurance to join their Information Technology. As the VP, Global IT QA, you will provide strategic...


  • Convent Station, United States Interactive Resources LLC Full time

    Location: Morristown, NJ, Purchase, NY, Conshohocken, PA or Charlotte, NC Sponsorship is Not Available Candidates MUST possess prior experience in the insurance industry. Job Description: Our industry leading client is in search of a VP, Global IT Quality Assurance to join their Information Technology. As the VP, Global IT QA, you will provide strategic...


  • Convent Station, United States coAction.com Full time

    At Coaction, we're a unique mix of leaders, achievers, thinkers, and team players with a high-performance mindset and a diverse skillset. We bring our industry expertise together to continually push the boundaries of what insurance can be for our clients. Responsibilities Collaboration with different departments (Claims, Policy, Regulatory, Finance,...


  • Convent Station, United States Pyramid Consulting Full time

    New Business Development Manager Morristown, NJ Key Skills: Prior experience in New Business Development acquiring New Clients (IT, Non-IT, Professional, Engineering). Prior experience acquiring new business opportunities in following areas: Contract/Perm Placements, Managed Services, SOW, Hire/Train/Deploy (HTD) Model. Extensive experience with bringing...

  • Data Engineer

    2 days ago


    College Station, United States Texas A&M University Full time

    Glimpse of the Data Engineer Job As a Data Engineer, you will design, implement, and optimize data pipelines to ensure efficient data flow and integration across multiple systems both on premise and cloud. Bachelors degree or equivalent and five y Data Engineer, Engineer, Technology, Education, Data

  • Databricks Engineer

    1 month ago


    Whitehouse Station, United States Chubb Full time

    Job Description Job Description: We are searching for a seasoned Databricks Engineer to pioneer advanced Databricks solutions. The Databricks Engineer will serve as a central figure in our data engineering team, delivering highly sophisticated technological solutions using Databricks, Delta Live Tables, Snowflake, and Medallion Architecture. Key...

  • Databricks Engineer

    4 weeks ago


    Whitehouse Station, United States Chubb Full time

    Job Description Job Description: We are searching for a seasoned Databricks Engineer to pioneer advanced Databricks solutions. The Databricks Engineer will serve as a central figure in our data engineering team, delivering highly sophisticated technological solutions using Databricks, Delta Live Tables, Snowflake, and Medallion Architecture. Key...


  • Convent Station, United States Vaco Full time

    Implementation Engineer Onsite New Jersey - NO C2C Direct Hire Responsibilities: Provide systems integration services for interactive data wall applications and hardware/software integration. Lead remote system and network integration before on-site implementation. Install and commission server and large-scale video wall systems as per customer...

  • AWS Cloud Engineer

    2 weeks ago


    Fairfax Station, Virginia, United States Pantheon Data Full time

    Company Overview Pantheon Data (a Kenific Holding company) is a private, small business based in the Washington, DC, area. Pantheon Data was founded in 2011, initially providing acquisition and supply chain management services to the US Coast Guard. Our service offerings have grown in the past ten years, including infrastructure resiliency, contact center...

  • Data Engineer

    3 weeks ago


    College Station, United States Cognizant North America Full time

    Data Engineer Position Overview A Data Engineer in Cognizant's AIA (AI & Analytics) practice brings relevant context to data for business and IT for intelligent systems and critical decisions. They work within the domains of data management, to integrate high-variation and/or high-velocity data to produce answers and enable clients to ask an entirely new...

  • Data Engineer

    4 weeks ago


    College Station, United States Cognizant North America Full time

    Data Engineer Position Overview A Data Engineer in Cognizant's AIA (AI & Analytics) practice brings relevant context to data for business and IT for intelligent systems and critical decisions. They work within the domains of data management, to integrate high-variation and/or high-velocity data to produce answers and enable clients to ask an entirely new...


  • Convent Station, United States Atlantic Health System Full time

    As a lead Platform Engineer (will be onsite in Morristown, NJ 4 days a week) you will get to build and manage a high performing team of developers within one of the top health systems in the world. As a hands-on devops engineer, you will be able to roll your sleeves up and working an agile way, and executing towards a long-term strategy. Ideal candidates...


  • Convent Station, United States Burns & McDonnell Full time

    Responsible for leading or executing power system protection and control engineering projects. Projects range in size, complexity, and voltage class from small distribution equipment upgrades to large transmission projects. This position can influence the future of the resiliency, reliability and economic operation of the electric grid. Opportunities to...


  • Convent Station, United States Burns & McDonnell Full time

    Responsible for leading or executing power system protection and control engineering projects. Projects range in size, complexity, and voltage class from small distribution equipment upgrades to large transmission projects. This position can influence the future of the resiliency, reliability and economic operation of the electric grid. Opportunities to...