ETL Testing

Job Description

Key Responsibilities:

• BAT Strategy: Develop and refine the strategy for Business Acceptance Testing in the context of the VPM Migration, primarily focusing on end-to-end testing of data flows.
• Requirement Gathering: Collaborate closely with business stakeholders to understand their requirements and expectations.
• Test Scenario Development: Translate business needs into detailed test scenarios and acceptance criteria.
• Test Automation:
• Identify opportunities where automation can enhance the BAT process.
• Design, implement, and maintain automated BAT, ensuring they remain aligned with business needs.
• Collaborate with the development and operations teams to integrate BAT automation into the CI/CD pipeline.
• Continuously evaluate the effectiveness and coverage of the automated tests, making improvements as necessary.
• Test Execution: Conduct BAT, ensuring the system meets all defined business criteria before proceeding to deployment. Create and maintain test plans, test cases, and test data.
• Issue Identification & Reporting: Identify any discrepancies between the system's outputs and business requirements, documenting and communicating them effectively for resolution.
• Feedback Loop: Provide feedback to the development team and business unit based on BAT findings and work collaboratively towards solutions.
• Documentation: Maintain comprehensive documentation of BAT processes, findings, and resolutions.

Required Qualifications:

• Experience in testing Datawarehouse/reporting applications.
• Experience using statistical computer languages (R, Python, SQL, etc.) to manipulate data and draw insights from large data sets.
• Familiarity with AWS environments, especially in relation to data projects.
• Strong understanding of the nuances involved in BAT.

Examples of Test Cases:

• Testing of data mismatches/data flows between VPM components
• Testing of implausibilities/inconsistencies within the data
• Testing of mismatches between the on-premise system and the migrated data on AWS.
• Ensuring that vehicle data provided by the markets is transferred to the database correctly

Job Description - Grade Specific