Etl Test Lead

Job Description

Dear candidate, Greetings for the day! Please apply the candidates those who are intersted for ETL test lead position. 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.