HI,
Job Title: ETL Data Warehouse Snowflake Migration Tester
Location: Quincy MA (Hybrid)
JOB DESCRIPTION:
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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester and querying, with experience in both Oracle SQL and Snow SQL scripts.
- Familiarity with scripting languages for test ETL Data Warehouse Snowflake Migration Tester automation, such as Python or Java.
- Understanding of data modeling concepts ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester 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 ETL Data Warehouse Snowflake Migration Tester related field.
- 5 years of experience in ETL processes and testing tools.
- 3 years of experience in designing and maintaining testing frameworks for Snowflake.
Read more:
top 10 staffing companies in usa
More Corp to corp hotlist
Join linkedin 42000+ US Active recruiters Network
Join No.1 Telegram channel for daily US JOBS and Updated HOTLIST