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)


  • 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


  • 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

Learn more/Apply for this position