ETL TESTING

ROLE : ETL TESTING

TORONTO - HYBRID - FULLTIME

ETL testing JD –

Key Responsibilities :

• Design, develop, and execute comprehensive test plans and test cases for complex ETL processes and data pipelines.
• Validate data accuracy, completeness, and consistency using advanced SQL queries for data validation and reconciliation.
• Develop and maintain robust automated test scripts using Java / JEE for data validation, regression testing, and overall data quality assurance.
• Implement API Automation testing strategies for data services and microservices, using tools / frameworks like REST Assured to ensure seamless integration and performance.
• Collaborate closely with ETL developers, data engineers, and business analysts in an Agile / Scrum methodology to understand data flows, transformation logic, and functional requirements.
• Identify, document, and track defects, issues, and risks using defect management tools such as Jira or Client ALM, and work with development teams for timely resolution.
• Participate in the continuous improvement of testing processes and tools, potentially integrating automated tests into CI / CD pipelines using tools like Jenkins or GitLab.
• Create and maintain test data and test environments, ensuring proper configuration for testing activities.
• Prepare detailed test summary reports and provide clear communication of testing progress and results to stakeholders.

Required Qualifications & Skills :