Migration Lead Test Analyst

About the position

Purpose of the role:

• Anayze solution architecture and design documents including source to target, and detail design documents needed to plan test design activities

Technical Skills

• Testing/Agile Tools: Jira, Zephyr


• RDBMS (Databases): MS SQL Server 2023


• Scripting Languages: SQL scripts


• Operating Systems: Microsoft Windows


• MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook


• Other Tools: Box, Confluence, MigFX (advantageous)

Qualifications

• Degree/Diploma in Information Technology, Computer Science, or similar 


• ISTQB Foundation Certificate in Software Testing


• Data analytics/analysis certification (advantageous)

Skills Required:

• 5+ years of experience in software testing having extensively worked in the entire testing life cycle, which includes designing, developing, and execution of the entire testing process


• Involved in preparing the test plans, test strategy documents, test cases, and test scripts based on business requirements, rules, data mapping requirements and system specifications


• Experience on functional testing, system testing, regression testing, integration testing, smoke testing, system integration testing (SIT).


• Involved in preparation of requirement traceability matrix (RTM), defect report, weekly/daily reports, test summary reports


• Experience in data analysis, data migration, web interface testing, data validation, data cleansing, data verification, and identifying data mismatch


• Extensive experience in writing complex SQL queries


• Expertise in Jira, Zephyr, Confluence, and Box


• Excellent skills in logging and tracking defects via Jira


• Experienced in interacting with project managers, business analysts, UAT users, developers, and respective stakeholders


• Understanding of data models, data schema, ETL, SQL queries to perform back-end data warehousing testing


• Experience in testing ETL Loads


• Knowledge on the phases of agile methodology


• Excellent interpersonal, communication, documentation, and presentation Skills

Responsibilities:

• Using SQL server to develop and execute test scripts in SQL, to validate the test cases


• Responsible for testing relevant loads of ETL jobs


• Creating test cases for ETL to compare source and target database systems


• Create test data to test all the scenarios and test cases planned


• Analyzing the testing progress by conducting walkthrough sessions with the relevant stakeholders/project teams


• Review the test activities through daily stand-up meetings


• Validate the target table column(s) definition with the source column(s) defination


• Validate database structures with the ERD (Entity Relationship Diagram)


• Hands on experience with using web service such as SOAP


• Validate data stage mappings that load files into staging tables


• Extensive end-to-end data validation and back-end testing using SQL queries

 


 


 


 

Desired Skills:

• Systems Analysis
• Complex Problem Solving
• Programming/configuration
• Critical Thinking
• Time Management