Negotiable
Outside
Remote
USA
Summary: We are looking for a Test Planning & Automation Lead to oversee data validation testing for a Cloud Data Modernization project, focusing on migrating an on-premises Enterprise Data Warehouse to a cloud environment. The role requires leadership in ensuring data consistency and implementing automation tools for testing processes. Collaboration with various stakeholders is essential to achieve seamless data integration and validation. The ideal candidate will have extensive experience in data warehousing and cloud migration projects.
Key Responsibilities:
- Lead Data Validation Testing: Oversee and manage the data validation testing process to ensure data consistency between the on-premises SQLServer and the target cloud environment.
- Tool Identification and Automation: Identify and implement appropriate tools to automate the testing process, reducing reliance on manual methods such as Excel or manual file comparisons.
- Testing Plan Development: Define and develop a comprehensive testing plan that addresses validations for all data within the data warehouse.
- Collaboration: Work closely with data engineers, cloud architects, and other stakeholders to ensure seamless integration and validation of data.
- Quality Assurance: Establish and maintain quality assurance standards and best practices for data validation and testing.
- Reporting: Generate detailed reports on testing outcomes, data inconsistencies, and corrective actions.
- Continuous Improvement: Continuously evaluate and improve testing processes and tools to enhance efficiency and effectiveness.
Key Skills:
- Leadership Experience: Minimum of 5+ years as a testing lead in Data Warehousing or Cloud Data Migration projects.
- Testing Methodologies: Proficiency in defining and implementing testing methodologies for data validation.
- Automation Tools: Experience with data validation and testing automation tools.
- Technical Expertise: Strong knowledge of SQLServer, Azure Cloud data tools (ADF, SHIR, Logic Apps, ADLS Gen2, Blob Storage), and Snowflake.
- Analytical Skills: Excellent analytical and problem-solving skills to identify and resolve data inconsistencies.
- Communication: Strong communication skills to collaborate effectively with cross-functional teams.
- Project Management: Ability to manage multiple tasks and projects simultaneously, ensuring timely delivery of testing outcomes.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Role Type: Testing Lead
Duration: 7 months
Telecommute : Yes
Description:
Job Description: Test Planning & Automation Lead - Cloud Data Modernization
Position Overview: We are seeking a highly skilled and experienced Test Planning & Automation Lead to join our team for a Cloud Data Modernization project. This role involves leading the data validation testing efforts for the migration of an on-premises Enterprise Data Warehouse (SQLServer) to a target cloud tech stack comprising Azure Cloud data tools (ADF, SHIR, Logic Apps, ADLS Gen2, Blob Storage, etc.) and Snowflake. The primary goal is to ensure data consistency between the on-premises and cloud environments.
Key Responsibilities:
Lead Data Validation Testing: Oversee and manage the data validation testing process to ensure data consistency between the on-premises SQLServer and the target cloud environment. Tool Identification and Automation: Identify and implement appropriate tools to automate the testing process, reducing reliance on manual methods such as Excel or manual file comparisons.
Testing Plan Development: Define and develop a comprehensive testing plan that addresses validations for all data within the data warehouse.
Collaboration: Work closely with data engineers, cloud architects, and other stakeholders to ensure seamless integration and validation of data.
Quality Assurance: Establish and maintain quality assurance standards and best practices for data validation and testing.
Reporting: Generate detailed reports on testing outcomes, data inconsistencies, and corrective actions. Continuous Improvement: Continuously evaluate and improve testing processes and tools to enhance efficiency and effectiveness.
Required Skills and Qualifications:
Leadership Experience: Minimum of 5+ years as a testing lead in Data Warehousing or Cloud Data Migration projects.
Testing Methodologies: Proficiency in defining and implementing testing methodologies for data validation.
Automation Tools: Experience with data validation and testing automation tools.
Technical Expertise: Strong knowledge of SQLServer, Azure Cloud data tools (ADF, SHIR, Logic Apps, ADLS Gen2, Blob Storage), and Snowflake.
Analytical Skills: Excellent analytical and problem-solving skills to identify and resolve data inconsistencies. Communication: Strong communication skills to collaborate effectively with cross-functional teams.
Project Management: Ability to manage multiple tasks and projects simultaneously, ensuring timely delivery of testing outcomes.
Preferred Qualifications: Familiarity with Agile methodologies and project management tools.