ETL TEST LEAD

Job Summary:
We are seeking a highly experienced QA professional with over 10 years of experience to join our Quality Assurance team for the data migration project. The ideal candidate will have a strong background in ETL testing, data validation, and migration projects, with expertise in creating test cases and test plans, as well as hands-on experience with data migration to cloud platforms like Snowflake. The role requires leadership capabilities to manage testing efforts, including coordinating with both on-shore and off-shore teams, ensuring seamless collaboration and delivery. Proficiency in ETL tools like Talend (preferred), Informatica PowerCenter, or DataStage is essential, along with a solid understanding of SQL and semi-structured data formats such as JSON and XML.

Key Responsibilities:

• Develop and implement comprehensive test strategies and plans for data migration projects, ensuring full coverage of functional and non-functional requirements.
• Create detailed test cases, test plans, and test scripts for validating data migration processes and transformations.
• Conduct thorough data validation and verification testing, leveraging advanced SQL skills to write and execute complex queries for data accuracy, completeness, and consistency.
• Utilize ETL tools such as Talend, Informatica PowerCenter, or DataStage to design and execute data integration tests, ensuring successful data transformation and loading into target systems like Snowflake.
• Validate semi-structured data formats (JSON, XML), ensuring proper parsing, mapping, and integration within data migration workflows.
• Lead testing efforts for data migration to cloud platforms, ensuring seamless data transfer and integrity.
• Act as the QA Lead to manage and coordinate testing activities with on-shore and off-shore teams, ensuring alignment, timely communication, and delivery of quality outcomes.
• Document and communicate test results, defects, and issues clearly to the development and project teams, ensuring timely resolutions.
• Collaborate with cross-functional teams to create and maintain automated testing frameworks for ETL processes, improving testing efficiency and coverage.
• Monitor adherence to QA best practices and standards while driving process improvements.
• Stay updated on the latest QA tools, technologies, and methodologies to enhance project outcomes.

Qualifications:

• 10 years of experience in Quality Assurance, focusing on ETL testing, data validation, and data migration projects.
• Proven experience creating detailed test cases, test plans, and test scripts.
• Hands-on experience with ETL tools like Talend (preferred), Informatica PowerCenter, or DataStage.
• Proficiency in SQL for complex query writing and optimization for data validation and testing.
• Experience with cloud data migration projects, specifically working with databases like Snowflake.
• Strong understanding of semi-structured data formats like JSON and XML, with hands-on testing experience.
• Proven ability to lead QA efforts, manage teams, and coordinate with on-shore and off-shore teams effectively.
• Strong analytical and troubleshooting skills for resolving data quality and testing challenges.

Preferred Skills:

• Experience with automated testing tools and frameworks, particularly for ETL processes.
• Knowledge of data governance and data quality best practices.
• Familiarity with AWS or other cloud-based ecosystems.
• ISTQB or equivalent certification in software testing.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.