Migration Lead Test Analyst

SUMMARY:

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
  

  POSITION INFO:
  

  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

   

   

   

   

  
  
  

   

  ---

   

  New users - Upload your CV

  Existing users - Login here