Data Warehouse Snowflake Migration Tester

3 weeks 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.

  • Data Warehouse Snowflake Migration Tester

    1 month 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...

  • Snowflake Data Architect

    19 minutes ago

    Boston, United States ASB Resources Full time

    Job DescriptionJob DescriptionRESPONSIBILITIESLead the migration of databases from Oracle to Snowflake, ensuring minimal disruption to business operationsDesign and implement identity management protocols within Snowflake to ensure secure access to dataDevelop and enforce cluster permissioning strategies to maintain data integrity and complianceOrganize and...

  • Snowflake technical Lead

    2 weeks ago

    Boston, United States Diverse Lynx Full time

    Must have played a technical lead in the Snowflake environment. Experience in writing scripts in Python especially in Data Engineering. Experienced in implementing Snowpark components. Must have prior experience with end-to-end implementation of Snowflake cloud data migration from on-premise preferably from any RDBMS like SQL Server, Oracle, Teradata etc....

  • Snowflake Data Consultant

    1 week ago

    Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....

  • Snowflake Data Consultant

    1 week ago

    Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....

  • Snowflake Data Consultant

    1 week ago

    Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....

  • Principal Data Engineer Snowflake Snaplogic AWS

    2 weeks ago

    Boston, United States Motion Recruitment Full time

    Job Title: Principal Data Engineer Location: Downtown Boston, MA - You bus already live in Massachusetts no relocation is available  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...

  • Data Architect

    6 hours ago

    Boston, United States Trident Consulting Full time

    Trident Consulting is seeking a " Data Architect " for one of our clients in " Jersey City, NJ & Boston, MA ". Role: Data Architect Location: Jersey City / Boston Hybrid (onsite) Type: Contract/FTE Job Description We are seeking a Data Architect to help drive our data strategy for Private Banking and Investment Management business lines. This individual must...

  • Snowflake Developer

    1 month 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...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Insight Global Full time

    An employer is looking for a Senior ETL Developer to join their team in the Seaport of Boston, MA. He/she will join the Data Warehouse team of a travel company. He/she will be a key contributor to the implementation of Snowflake as the organization migrates from Oracle to the cloud. This person will collaborate across teams to design, develop, and optimize...

  • Talend Developer with Snowflake Skills

    2 weeks ago

    Boston, United States Diverse Lynx Full time

    JD- • Looking for a strong ETL developer with hands-on experience in developing large scale Data engineering pipelines for financial services • Minimum 7 years of related experience in building and maintaining large scale Data warehouse applications in cloud • Minimum 3 years of experience in Talend ETL tool as a developer, developing complex ETL...

  • Principal Data Engineer

    4 weeks 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 Warehouse Selenium QA Tester

    2 weeks ago

    Boston, United States Mindlance Full time

    SUMMARY: Teams unit seeks a highly motivated individual as a Quality Assurance Tester to join its Data Warehouse Systems Quality Assurance (SQA) team. The Quality Assurance Tester will be responsible for working on complex projects within the Healthcare Domain and applying knowledge of software testing and analysis concepts, practices, and procedures....

  • Director, Customer Experience Engineering

    1 month 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...

  • Data Warehousing Operations Engineer

    1 month 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...

  • Senior Snowflake Developer

    6 days ago

    Boston, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionTitle: Senior Snowflake Developer Location: Boston, MA (Day 1 onsite) Job Description:Skills and qualificationsRequired skills and experience: Snowflake on Azure relevant experienceProficient in SQL and familiar with ETL processesADF to create pipelinesExperience with data modelling and cloud (Azure) computing...

  • Sr Snowflake Administrator

    2 weeks ago

    Boston, United States Diverse Lynx Full time

    Role: Snowflake Administrator Location: Boston, MA (Hybrid- Onsite) Duration: 6-12 Months * 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...

  • Manager, Sales Engineering

    2 days ago

    Boston, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. We’re at the forefront of the data revolution, committed to building the world’s greatest data and applications platform. Our ‘get it done’ culture allows everyone at Snowflake to have an equal opportunity to innovate on new ideas, create work with a lasting impact, and excel in a culture of...

  • Sr. Snowflake DBA

    2 days ago

    Boston, United States Saxon Global Full time

    Client: The Commonwealth of MA Center of Health Information and Analysis (CHIA) is looking for a very high Level Snowflake DBA/Consultant. Title: Sr. Snowflake DBA Location 501 Boylston Street, Suite 5100, Boston, MA 02116 Must be local and Hybrid in Boston, MA Duration: 1 year + renewals Rate is in the $85+/hr, let me know what you are seeing. ...

  • Sales Engineer, Financial Services

    3 weeks ago

    Boston, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Our Sales Engineers are customer obsessed and we believe in the value we can add and stay honest about it. We love to learn, are open to giving and receiving feedback and are passionate about making our clients successful. Our team works to ensure data is accessible, usable and valuable to everyone. This...