Key skills
ETLSQLData WarehousingCommunicationCollaboration
About this role
Role Overview
- Design, develop, and execute test cases for ETL processes and data pipelines
- Perform end-to-end ETL testing to validate data extraction, transformation, and loading processes
- Develop and maintain automation frameworks for data validation and regression testing
- Write and execute complex SQL queries to validate data accuracy and consistency
- Validate data across multiple sources, ensuring completeness, integrity, and correctness
- Identify, document, and track defects, ensuring timely resolution with development teams
- Collaborate with data engineers and developers to understand data flows and business logic
- Perform data reconciliation and ensure alignment between source and target systems
- Optimize testing processes to improve efficiency, coverage, and reliability
- Participate in requirement analysis and contribute to test planning and strategy
- Maintain clear documentation for test cases, scenarios, and results
- Ensure adherence to quality standards and best practices in data testing
Requirements
- Minimum 4+ years of experience in QA automation with a focus on ETL testing
- Strong hands-on experience with ETL tools and data integration processes
- Advanced proficiency in SQL for data validation and analysis
- Solid understanding of data warehousing concepts and data pipelines
- Experience in designing and implementing automated testing frameworks
- Familiarity with testing tools and methodologies for data validation
- Strong analytical and problem-solving skills with attention to detail
- Ability to work independently in a remote environment
- Good communication and collaboration skills
- Experience working with large datasets and complex data transformations
- Knowledge of scripting or programming languages is an advantage
- Proactive approach to identifying issues and improving testing processes
Tech Stack
- ETL
- SQL