Position : Sr. QA / BA to create requirements for data ingestion pipelines (data vault 2.0 / data warehouses) for a major insurance client -
Duration : 10 months with possible extension
Location : Hybrid Toronto (2x on-site)
Job ID : Must Haves :
Must Haves :
- 5+ yrs exp as a BA / QA working on Data integration projects within the insurance industry
- 3+ yrs exp creating requirements for data ingestion pipelines (data vault 2.0 / data warehouses)
- testing data validation scenarios and Data ingestion, pipelines, and transformation processes Nice to Haves :
- ETL Testing
- ETL Testing
- Agile / Scrum
Responsibilities :
- Partner with and seek feedback from different business experts, managers, and IT teams to facilitate our Data integration processes
- Facilitate workshops to document current business processes and technical systems and help to identify potential efficiencies.
- Write clear agile stories that help propel engineering work with the help of the product design team for IT development.
- Create source to target mapping and define business and data harmonization rules required for data integration .
- Design, plan, and execute test cases, scenarios, and scripts for ETL validation and regression testing.
- Verify and validate data accuracy, completeness, and consistency using ETL tools and SQL queries.
- Create and maintain test cases, scripts, and documentation in test management tools such as JIRA
- Collaborate with developers, data analysts, and business stakeholders to understand business and technical requirements for ETL testing.
- Identify, document, and report defects, issues, and risks related to ETL testing.
- Conduct root cause analysis on any issues that arise during testing and provide recommendations for remediation.
- Work in an Agile environment to ensure timely delivery of high-quality ETL testing.
- Experience documenting and analyzing work processes and working with operational teams to improve those processes
- Conducting thorough testing of system functionalities, integrations, and data accuracy, and reporting on test results to project stakeholders.
30+ days ago