The Options Clearing Corporation (OCC) is looking to solve the problem of ensuring the quality and reliability of their Encore/ETS/Data Platform applications by hiring a skilled QA tester to drive external and internal testing requests, design and develop tests, and collaborate with the development team to identify and resolve defects.
Requirements
- Manage secure data transfers and file validations using PuTTY(SSH), WinSCP, or FileZilla to support consistent server interaction and maintain data accuracy
- Test database functionality, data integrity and business logic across various relational database management systems (RDBMS) such as Squirrel SQL Client, Hadoop(Hive), SQL Server to ensure accurate backend validation and reliable dataflow
- Use Alteryx or Informatica PowerCenter 10.1 to execute ETL workflows, validate schema mappings, and ensure data integrity through advanced SQL verification
- Design test plans, execute testcases, and track defects, ensuring end-to-end test coverage and traceability with SpiraTest or HP ALM
- Experience with Agile development methodologies
- Experience with relational database management systems (RDBMS) such as SQL Server, Hadoop(Hive)
- Experience with ETL tools such as Alteryx or Informatica PowerCenter 10.1
Responsibilities
- Drive external and internal testing requests related to test execution, including application level setup within ENCORE system, creating testing inputs, initiating and monitoring the applicable processes, and confirming the resulting outbound data files and reports are produced.
- Drive the team responsible for design and development of tests for Encore/ETS/Data Platform applications.
- Attend high level design sessions, code walk-throughs and offer suggestions, and guidance on any topic that could have a negative impact.
- Work on Agile team throughout the Lifecycle to collaborate on the analysis, design, development and testing.
- Actively participate in Sprint planning session and assist in creating stories with robust acceptance criteria while helping identify missing or incomplete requirements.
- Manage secure data transfers and file validations using PuTTY(SSH), WinSCP, or FileZilla to support consistent server interaction and maintain data accuracy.
- Test database functionality, data integrity and business logic across various relational database management systems (RDBMS) such as Squirrel SQL Client, Hadoop(Hive), SQL Server to ensure accurate backend validation and reliable dataflow.
Other
- Bachelor’s degree in computer science, engineering, or related
- Three (3) years of experience as a software developer, QA tester or related
- Up to 40% telecommuting permitted
- Must be able to work in a hybrid work environment, up to 2 days per week of remote work
- Must be eligible for a discretionary bonus based on various factors, including company and individual performance
