Data Warehouse Snowflake Migration Tester

4 weeks ago


Quincy, United States Mindlance Full time
POSITION OVERVIEW:

The Client 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:
  • Bachelors 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.


  • Quincy, United States HexaQuEST Global, Inc. Full time

    The MassHealth Systems 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...


  • Quincy, United States HexaQuEST Global, Inc. Full time

    The MassHealth Systems 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...


  • Quincy, United States Mindlance Full time

    POSITION OVERVIEW: Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for MassHealth users. They will also be responsible for standardization, maintenance, configuration, and support documentation. They will partner with team members to receive and provide...


  • Quincy, United States Acro Service Corp Full time

    Job Title: Data Plateform Administrator Project Duration: 12 Months Worksite Address: Quincy, MA 02171, USA Job Description : Title: Data Platform AdministratorData Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for users. They will also be responsible for standardization,...


  • Quincy, United States Acro Service Corp Full time

    Job Title: Data Plateform Administrator Project Duration: 12 Months Worksite Address: Quincy, MA 02171, USA Job Description : Title: Data Platform AdministratorData Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for users. They will also be responsible for standardization,...


  • Quincy, United States TalentBurst Full time

    Data Platform Administrator Quincy, MA/ Hybrid 12 months contract Weekly hours: $37.5/week As a member of the Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for healthcare system users . They will also be responsible for...


  • Quincy, United States TalentBurst, Inc. Full time

    Data Platform AdministratorQuincy, MA/ Hybrid12 months contractWeekly hours: $37.5/week As a member of the Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for healthcare system users They will also be responsible for standardization,...


  • Quincy, United States TalentBurst Full time

    Data Platform Administrator Quincy, MA/ Hybrid 12 months contract Weekly hours: $37.5/week As a member of the Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for healthcare system users . They will also be responsible for...


  • Quincy, United States The Computer Merchant Full time

    JOB TITLE: Data Platform Administrator JOB LOCATION: Hybrid Quincy MA WAGE RANGE*: $85hr to $86.95 (based on a 37.5 hour work week) JOB NUMBER: ITS77_EHS_FY25_SYS ADMIN – 100 REQUIRED EXPERIENCE: QUALIFICATIONS (Education, Years' Experience, Certificates): BS in Computer Science or related degree, or equivalent experience 3+ years in Cloud Data...


  • Quincy, United States The Computer Merchant, LTD. Full time

    JOB TITLE: Data Platform Administrator JOB LOCATION: Hybrid Quincy MA WAGE RANGE*: $85hr to $86.95 (based on a 37.5 hour work week) JOB NUMBER: ITS77_EHS_FY25_SYS ADMIN – 100 REQUIRED EXPERIENCE: QUALIFICATIONS (Education, Years' Experience, Certificates): BS in Computer Science or related degree, or equivalent experience 3+ years in Cloud Data...


  • Quincy, United States Rose International Full time

    Date Posted: 05/24/2024 Hiring Organization: Rose International Position Number: 464651 Job Title: Data Platform Administrator Job Location: Quincy, MA, USA, 02171 Work Model: Hybrid Employment Type: Temporary Estimated Duration (In months): 6 Min Hourly Rate ($): 70.00 Max Hourly Rate ($): 80.00 Must Have Skills/Attributes: AWS, Azure,...


  • Quincy, United States Rose International Full time

    Date Posted: 05/24/2024Hiring Organization: Rose InternationalPosition Number: 464651Job Title: Data Platform AdministratorJob Location: Quincy, MA, USA, 02171Work Model: HybridEmployment Type: TemporaryEstimated Duration (In months): 6Min Hourly Rate($): 70.00Max Hourly Rate($): 80.00Must Have Skills/Attributes: AWS, Azure, Cloud, Data Warehouse, ETL,...


  • Quincy, MA, United States The Computer Merchant, LTD. Full time

    JOB TITLE: Data Platform Administrator JOB LOCATION: Hybrid Quincy MA WAGE RANGE*: $85hr to $86.95 (based on a 37.5 hour work week) JOB NUMBER: ITS77_EHS_FY25_SYS ADMIN – 100 REQUIRED EXPERIENCE: QUALIFICATIONS (Education, Years' Experience, Certificates): BS in Computer Science or related degree, or equivalent experience 3+ years in Cloud Data Warehouse...


  • Quincy, United States State Street Corporation Full time

    Lead the development and maintenance efforts of existing inhouse data warehouse platform. Migrate data and pipelines from on-premise data warehouse platform to cloud lakehouse platform. Perform data analysis on bank's internal data using Oracle based Warehouse Lead, Compliance, VP, Warehouse, Manufacturing


  • Quincy, United States Diverse Lynx Full time

    WS Architect with Python: AWS Architect with experience in Developing and deploying Containerized applications. Designing and developing applications in AWS cloud. Experience working with CICD pipelines. Must have ECS/EKS experience Must have experience in configuring Java/Pyhton applications to interact with MQ, Database, EFS, S3. Experience...


  • Quincy, United States Acro Service Corp Full time

    Job Title: Data Platform AdministratorProject Duration: 12 Months Worksite Address: Quincy, MA- Hybrid(candidate must be from New England region)Job Description: Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for MassHealth users. They...


  • Quincy, MA, United States The Computer Merchant, LTD. Full time

    JOB TITLE: Data Platform Administrator JOB LOCATION: Hybrid Quincy MA WAGE RANGE*: $85hr to $86.95 (based on a 37.5 hour work week) JOB NUMBER: ITS77_EHS_FY25_SYS ADMIN - 100 REQUIRED EXPERIENCE: QUALIFICATIONS (Education, Years' Experience, Certificates): BS in Computer Science or related degree, or equivalent experience 3+ years in Cloud Data Warehouse...


  • Quincy, United States Lineage Logistics Full time

    Warehouse Supervisor page is loaded **Warehouse Supervisor** **Warehouse Supervisor** locationsQuincy, WA (Columbia Way) time typeFull time posted onPosted Yesterday job requisition idR0038561 Supervise the operations and responsibilities of the warehouse team and designated facility. Work with Operations leadership to make certain company and customer...

  • Warehouse Lead

    1 week ago


    Quincy, United States Leafwire Full time

    ** Warehouse Lead** ** | Higdon - Processing, FL, United States** Posted Date 2/13/2022 Description **Job Title:** Warehouse Lead **Department:** Processing **Reports to:** Warehouse Manager **FLSA Status:** Regular- Non-Exempt **Location:** Quincy, FL (Higdon) **ROLE SUMMARY:** In this position you will be responsible to making sure all employees are...


  • Quincy, United States Adameservices Full time

    Title: Enterprise Architect Location: Quincy, MA Mode: (Hybrid – 1-2 days per week onsite) Mode Contract Must have experience in health care domain and previous government domain or with government agencies The Architect will serve as an Architect within the MMIS Architect team. As an Enterprise Architect for the highly visible MMIS, he/she will support...