Department:
Solution Service Delivery
Position Purpose & Summary:
The main responsibility of a Software Engineer in Test is to help assisting test/project leads to assess the quality of the system under validation through automation, implementation of new automation tools and creation of innovative automation systems and overall plain good strategies. The candidate will work integrated with the project team and developers in executing various test strategies with limited duration and resources while at the same time, maximizing the test coverage throughout software development lifecycle.
This can be established through the utilization of the latest technologies in test automation and the development of new test tools and systems. This role contributes to database design and implementation review and creates basic to moderate physical designs of ETL processes.
Primary Duties & Responsibilities:
- Responsible for test lifecycle activities for a large project involving multiple vendors, multiple technologies for Static, System Test, System Integration Test, Data and other relevant test as required
- Creating test plans, test automation scripts, test procedures. Assisting in test metrics creation, Prepare test summary reports
- Understand the project business & technical requirements, develop test cases & scripts. Work closely with the client/development team in developing test scenarios.
- Review and validate the Database Design related documents to ensure they align with business requirements, adhere to best practices, and meet technical standards.
- Ability to perform Data testing and understand the technicalities involved in Data migration, cleansing and ETL Tools.
- Detailed root cause analysis of issues to the extent of identifying anomalies in the code, network and databases prior to raising the Problem Reports (PR).
- Plan and adhere to the Quality Assurance processes and gates in making sure the product/system being tested are of high quality.
- Run and validate current scripts provided by the Data Warehouse team and modify, expand and improve necessary test scripts for reuse and automation purposes
- Work independently and play a liaison role between QA/Tester/Test Lead, Development & DBA teams
- Identify and document data anomalies then work with development to resolve issues
- Consult with management to provide information regarding software readiness/jeopardy items
- Create and execute database queries in order to test the underlying data changes caused by interactions of software applications
- Use customer data & feeds to perform root cause analysis accurately reporting on results
- Enter and query defects in defect tracking database and generate test cases providing meaningful acceptance criteria in tracking database as necessary
Relevant Work Experience
- Minimum of 6+ years’ experience in database management and data validation related with data migration / integration / analytics projects.
- Experience with Software Test; Process and Practices is plus
Qualifications
- Candidate must possess at least an Advanced/Higher/Graduate Diploma, Bachelor’s Degree, Post Graduate Diploma or Professional Degree in Computer Science / Computer Engineering / Software Engineering / Electronic & Electrical Engineering field / Information Technology
- Database related certification such as IBM Certified Database Administrator, Microsoft SQL Server Database Certifications, Oracle Database 12c, Database administration (DBA) is a plus
Technical/ Functional Skills
- Understand in various Data Testing Methodologies for Pre-Migration and Post-Migration validation to ensure the data accuracy and integrity.
- A Very Good level in database structure and solid database scripting
- Proficiency in SQL and experience with various database management systems (e.g., Microsoft SQL, Oracle, SQL Server, MySQL).
- Familiarity with big data technologies (e.g., Hadoop, Spark) and NoSQL databases (e.g., MongoDB, Cassandra) is a plus
- Knowledge on data management and tools for ETL & Data Warehouse.
- Exposed to both traditional Waterfall and Agile methodology
Soft Skills:
- Able to work under pressure and to tight time scales with a demonstrable ability to multitasking and delivering projects to tight deadlines
- Good interpersonal and communications skills
- Process knowledge in ISO 9000/17025 will be an added advantage
