Data Warehouse Snowflake Migration Tester

1 week ago

Boston, United States HexaQuEST Global, Inc. Full time
Job Description :

POSITION OVERVIEW:
The MassHealth Systems Teams unit seeks a highly motivated individual as a Data Warehouse Snowflake Migration Tester to join its Systems Quality Assurance (SQA) team. As a Data Warehouse Snowflake Migration Tester, you will be responsible for ensuring the successful migration of data warehouse systems to the Snowflake platform. Your responsibilities will include designing, implementing, and executing test cases to validate the functionality, performance, and data integrity of the Snowflake migration. You will collaborate with cross-functional teams, including data engineers, developers, and project managers, to ensure a seamless transition to Snowflake. The ideal candidate should possess a strong understanding of data warehousing concepts, testing methodologies, and expertise in Snowflake technologies. The individual should work in compliance with HIPAA requirements.
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
  • Collaborate with stakeholders to understand migration requirements and define comprehensive test plans.
  • Develop detailed test strategies, test scenarios, and test cases for validating data warehouse migration to Snowflake.
  • Execute manual and, where applicable, automated test cases to ensure the accuracy, completeness, and consistency of data within the Snowflake environment.
  • Identify, document, and track defects, and work closely with development teams to facilitate timely resolution.
  • Conduct end-to-end testing of data pipelines and ETL processes.
  • Verify data integrity and accuracy during the migration process.
  • Validate the consistency of data between source and target systems, ensuring that business logic is preserved.
  • Collaborate with data engineers, developers, and other stakeholders to understand the technical aspects of the migration and ensure comprehensive test coverage.
  • Work closely with project managers/ team lead to communicate testing progress, issues, and risks.
  • Create and maintain detailed documentation of test plans, test cases, and test results.
  • Generate comprehensive reports summarizing testing activities, results, and recommendations.
  • Contribute to process improvements and provide recommendations for optimizing testing procedures.

QUALIFICATIONS: Required Skills and Abilities
  • Demonstrated expertise in testing Snowflake data warehouses and ETL processes.
  • Proficient in SQL for data validation and querying, with experience in both Oracle SQL and Snow SQL scripts.
  • Familiarity with scripting languages for test automation, such as Python or Java.
  • Understanding of data modeling concepts and principles.
  • Hands-on experience working with Cloud Platforms such as AWS.
  • Proficiency in Informatica Intelligent Cloud Services (IICS) and relevant tools.
  • Competence in Automation Tools such as Selenium and Apache AirFlow.
  • Familiarity with GIT Version Control.
  • Familiarity with Agile and DevOps methodologies.
  • Strong analytical and problem-solving skills with meticulous attention to detail.
  • Effective communication and collaboration skills, demonstrating the ability to work in a team oriented environment.
  • Experience with testing tools and frameworks related to Snowflake, including Snowflake Data Cloud, is advantageous.
  • Experience with Jira for tracking and managing testing tasks, as well as collaborating with development and other testing teams.
  • Ability to take high-level requirements and/or scope and drive to successful execution.
  • Proficiency in MS Office, i.e., Word, Excel, PowerPoint, Access, and Visio.
  • Government and or Healthcare prior experience desired
EDUCATION AND EXPERIENCE:
  • Bachelor's degree in computer science, Information Technology, or a related field.
  • 5 years of experience in ETL processes and testing tools.
  • 3 years of experience in designing and maintaining testing frameworks for Snowflake.

  • Principal Data Engineer Snowflake AWS

    Found in: beBee S US - 3 weeks ago

    Boston, United States Motion Recruitment Full time

    Job Title: Principal Data Engineer Location: Downtown Boston, MA Company Overview: Join a prestigious asset management firm in the heart of Boston, boasting over $1 trillion in assets under management. Our firm is renowned for its innovative investment strategies and commitment to excellence in financial management. We are at the forefront of integrating...

  • Director, Customer Experience Engineering

    4 days ago

    Boston, United States Snowflake Computing Full time

    **Director, Customer Experience Engineering** Location Boston, Massachusetts, USA Category Engineering REQ4840 JOB DESCRIPTION There is only one Data Cloud. Snowflakes founders started from scratch and designed a data platform built for the cloud that is effective, affordable, and accessible to all data users. But it didnt stop there. They engineered...

  • Director, Customer Experience Engineering

    1 week ago

    Boston, United States Snowflake Computing Full time

    **Director, Customer Experience Engineering** Location Boston, Massachusetts, USA Category Engineering REQ4840 JOB DESCRIPTION There is only one Data Cloud. Snowflakes founders started from scratch and designed a data platform built for the cloud that is effective, affordable, and accessible to all data users. But it didnt stop there. They engineered...

  • Snowflake Developer

    1 week ago

    Boston, United States Diverse Lynx Full time

    Detailed JD good hands-on Data application developer with excellent experience on Databricks, Snowflake, Airflow, Kubernetes, Kafka, lake houses, Delta lake, Object stores like AWS s3/ Azure blob. Job Responsibilities Developing latest reusable data processing component & libraries based on Data mesh design pattern Designing & implement a modern highly...

  • Director, Travel Platform

    Found in: Jooble US O C2 - 2 weeks ago

    Boston, MA, United States Snowflake Inc. Full time

    Director, Customer Experience Engineering** Location Boston, Massachusetts, USA Category Engineering REQ4840 JOB DESCRIPTION There is only one Data Cloud. Snowflakes founders started from scratch and designed a data platform built for the cloud that is effective, affordable, and accessible to all data users. They engineered Snowflake to power the Data...

  • Director, Customer Experience Engineering

    Found in: Jooble US O C2 - 2 weeks ago

    Boston, MA, United States Snowflake Inc. Full time

    **Director, Customer Experience Engineering** Location Boston, Massachusetts, USA Category Engineering REQ4840 JOB DESCRIPTION There is only one Data Cloud. Snowflakes founders started from scratch and designed a data platform built for the cloud that is effective, affordable, and accessible to all data users. But it didnt stop there. They engineered...

  • Principal Data Engineer

    Found in: beBee S US - 5 days ago

    Boston, United States Motion Recruitment Full time

    We're currently working with a company that specializes in systematic asset management providing core beta exposures across a wide range of niche asset classes and other equity sources. Their focus is to offer the scale of a large asset firm with the benefits of a smaller organization.  The ideal candidate will play a critical role on the Data Team,...

  • Data Warehousing Operations Engineer

    3 days ago

    Boston, United States Insight Global Full time

    An employer is looking for a Data Warehousing Operations Engineer to join their team in the Seaport district of Boston, MA (hybrid model). This person will help with the data migration to Snowflake over the next 2 years. At first, this person will share responsibilities with the DW Operations Manager to support the current informatica Oracle environment in...

  • Data Warehousing Operations Engineer

    1 week ago

    Boston, United States Insight Global Full time

    An employer is looking for a Data Warehousing Operations Engineer to join their team in the Seaport district of Boston, MA (hybrid model). This person will help with the data migration to Snowflake over the next 2 years. At first, this person will share responsibilities with the DW Operations Manager to support the current informatica Oracle environment in...

  • Data /Project Architect

    Found in: Jooble US O C2 - 4 days ago

    Boston, MA, United States Publicis Groupe Full time

    Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and...

  • Snowflake Architect with Snaplogic

    6 days ago

    Boston, United States Mastek Full time

    ResponsibilitiesAs a Snowflake, Snap Logic Architect/Developer at Mastek, you'll lead the design and development of database solutions leveraging cloud tools and technologies. This includes install and configuration, performance tuning, modeling, prototyping database designs and ETL/ELT solutions. You will also work closely with the Principal, Cloud and...

  • Snowflake Architect with Snaplogic

    Found in: Appcast US C2 - 6 days ago

    Boston, United States Mastek Full time

    ResponsibilitiesAs a Snowflake, Snap Logic Architect/Developer at Mastek, you'll lead the design and development of database solutions leveraging cloud tools and technologies. This includes install and configuration, performance tuning, modeling, prototyping database designs and ETL/ELT solutions. You will also work closely with the Principal, Cloud and...

  • Snowflake Architect with Snaplogic

    Found in: Appcast Linkedin GBL C2 - 6 days ago

    Boston, United States Mastek Full time

    ResponsibilitiesAs a Snowflake, Snap Logic Architect/Developer at Mastek, you'll lead the design and development of database solutions leveraging cloud tools and technologies. This includes install and configuration, performance tuning, modeling, prototyping database designs and ETL/ELT solutions. You will also work closely with the Principal, Cloud and...

  • Partner Sales Manager SLED

    5 hours ago

    Boston, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team.Our SI partners play a key role in bringing our customers' data-backed ambitions to life by implementing and harnessing the power of the Snowflake Data Cloud for cutting edge workloads and use cases. Through our partnerships, we enable companies to empower their employees with the data they need when and how...

  • SAP Data Migration Lead

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Boston, United States Whitridge Associates Full time

    As a S/4HANA Data Program Manager, you will spearhead the migration of our client’s financial systems from SAP R3 to S/4HANA. This significant upgrade involves a series of releases over a three to four-year timeline. We are looking for a seasoned professional who has comprehensive experience managing the entire data lifecycle in large-scale SAP...

  • SAP Data Migration Lead

    Found in: Appcast US C2 - 2 weeks ago

    Boston, United States Whitridge Associates Full time

    As a S/4HANA Data Program Manager, you will spearhead the migration of our client’s financial systems from SAP R3 to S/4HANA. This significant upgrade involves a series of releases over a three to four-year timeline. We are looking for a seasoned professional who has comprehensive experience managing the entire data lifecycle in large-scale SAP...

  • Sr Snowflake Administrator

    1 week ago

    Boston, United States Diverse Lynx Full time

    9075050 Sr Snowflake Administrator 10+ years $65/hr. Pay Boston, M Hybrid 10+ years of hands-on experience on Snowflake development including Snowpipes, Snowshare, Task, Streams, UDFs and Procedures Develop, build & maintain mission critical centralized data platform using Snowflake Diagnose and troubleshoot Snowflake database errors Implement Snowflake...

  • Analytics / Business Intelligence Manager (dbt, Fivetran, Oracle Database, Snowflake)

    3 days ago

    Boston, United States Performance Architects Full time

    OVERVIEW: We are hiring a Senior Analytics Consulting Manager for our Business Intelligence (BI) consulting practice. As a member of our business intelligence practice, you will be exposed to all phases of the project lifecycle and will have the opportunity to help shape the future of Performance Architects. Excellent advancement opportunities are available...

  • Principal Data Engineer

    Found in: beBee jobs US - 1 week ago

    Boston, Massachusetts, United States Geode Capital Management Full time

    Geode Capital Management is actively searching for a full-time Principal Data Engineer to become an integral part of our Data team. The Principal Data Engineer will play a very critical role within our data team by providing technical leadership, implementation expertise, design best practices and guiding other highly skilled and motivated data engineers. In...

  • Analytics / Business Intelligence Manager (dbt, Fivetran, Oracle Database, Snowflake)

    Found in: Appcast US C2 - 6 days ago

    Boston, United States Performance Architects Full time

    OVERVIEW:We are hiring a Senior Analytics Consulting Manager for our Business Intelligence (BI) consulting practice. As a member of our business intelligence practice, you will be exposed to all phases of the project lifecycle and will have the opportunity to help shape the future of Performance Architects. Excellent advancement opportunities are available...