What are the responsibilities and job description for the ETL QA Tester position at 1 Point System?
QA Tester
This position is for a QA resource to support the Marketing and Investment Data Repository (MIDR) system. MIDR is an Oracle database for investment performance data. Data is loaded from multiple sources (API/Flat Files) and delivered to other departments via data services and Business Objects reports.
The candidate should have previous experience working for asset management/finance companies. This resource will support MIDR efforts to implement enhancements to existing functionality or changes needed for regulatory requirements. This resource will also support testing for production issues and system performance improvements.
Job Responsibilities:
- Execute test plans, scenarios, scripts or procedures
- Test system modifications to prepare for implementation
- Develop testing programs that addresses areas such as database impacts, software scenarios, or usability
- Document software defects, using a bug tracking system, and report defects to software developers
- Identify, analyze and document problems with program function, output, online screen or content
- Monitor bug resolution efforts and track successes
- Create or maintain databases of known test defects
- Plan test schedules or strategies in accordance with project scope or delivery dates
Technical Requirements:
- Strong SQL Skills (Store Procedures, PL SQL, Triggers, Indexes, Database Optimization)
- Experience with Oracle, Business Objects, Autosys, Informatica Workflows, ETL testing
- Experience with SOAPUI/Postman for API/data services testing
- Experience with Jira for defect management and test management
Qualifications:
- Associate's degree in a technical field such as computer science, computer engineering or related field required
- 9-10 years experience required
- Experience testing software
- Experience writing test documentation such as Test Plans, scripts and test results reports
- Ability to analyze/interpret test results and provide recommendations to improve testing
Job Type: Contract
Salary: $50.00 - $55.00 per hour
Schedule:
- 8 hour shift
Ability to commute/relocate:
- Minneapolis, MN: Reliably commute or planning to relocate before starting work (Required)
Experience:
- ETL: 3 years (Required)
- SQL: 5 years (Required)
- data mapping: 1 year (Required)
- QA testing: 9 years (Required)
- Financial domain: 5 years (Required)
Work Location: One location
