Location: REMOTE
Availability/Duration: ASAP + 6-months CONTRACT
Work organization: REMOTE
Rate: $40-$45/hr as T4
Mandatory: Enhanced Reliability Clearance (ERC)
Applications Operations Services & Quality Engineering (AOSQE) is looking for a Senior Software Development Engineer in Test (Data/ETL Testing) with a proven track record of leading testing activities to join the Data Testing Chapter. The successful candidate acts as the Quality Advocate and is responsible to ensure the delivery of quality solutions to our clients through testing.
What you will do:
- Will act as a QE Lead role in a mid/large size program.
- You will be accountable of writing test strategy, test planning, execution and managing the entire end-to-end UAT and BAT testing.
- You will be mainly working on the Data and ETL Technology based projects.
- You will be working closely with the already existing QE Team and delivering the stories assigned to you.
- You will be working in an agile delivery model; tickets will be assigned to you as a User Stories through the Jira board.
- Responsible for coordinate with the existing QE team members, Business System Analyst, Developer and Scrum Master.
- You will be expected to learn the Sun Life in-house Data Testing Automation Framework and use it in a day-to-day testing activity.
- You will be working on an AWS related technologies - S3 bucket, DB Visualizer, Glue and Redshift. Also, on the Microsoft SQL Server.
- Participating in an onboarding/Knowledge Transition sessions, listening the recorded training materials and developing the understanding based on the information available in recording.
- Responsible for managing & developing test activities (program/project test plans and strategies, test case creation and test execution) and aligning to Sun Life Quality Engineering practices.
- Apply an automation-first mindset to testing activities.
- Provide the IT and Business teams with detailed information on any defects found and help prioritize defects based on risk.
- Defect Management using qTest and report status and/or metrics to project stakeholders.
What you need to succeed:
- University degree in Computer Science or equivalent practical experience
- 5+ years of Quality Assurance work experience, specifically to the Data and ETL technologies-based projects.
- Strong understanding of ETL concepts, should be able to lead the project independently without much handholding from the other QE member.
- Knowledge of coding languages including SQL (creating, maintaining, and editing queries) MySQL
- Experience in working on the Technical Data Mapping and using it to Create the Test Plan, Test Cases and Expected Results.
- Experience on validating the source to target data load validation and strong debugging skill to analysis the difference in the test results.
- Experience on the Test Automation Tool, like (Tosca Automation Specialist Level 1 & Level 2 and Tosca Data Integrity Specialist) or any Data Testing related automation tool.
- Experience with data warehouse, enterprise data lake, and other big data tools and concepts
- Experience with Agile (Scrum and Kanban) and Waterfall methodology
- Knowledge of DevOps, Continuous Integration and delivery concepts, specifically continuous testing
- You will be required to have good knowledge about the Python to be able to work on the test automation tool.
Preferred skills:
- Strong communication, organizational and interpersonal skills
- Ability to work independently with little or no supervision.
- Strong understanding of ETL concepts, should be able to lead the project independently without much handholding from the other QE member.