Oracle Financial Application Platform

BinTech Group; New Jersey; On-site; USD 100,000 - 140,000; Full time

Job summary

BinTech Group seeks an experienced QA Tester specialized in data warehouse ETL testing. The role emphasizes end-to-end data flow validation, SQL validation, and collaboration with developers, business analysts, and QA peers.

You will design test strategies, create test data, and maintain thorough documentation while ensuring alignment with financial domain requirements and industry best practices in a fast-paced environment in New Jersey. On-site role in New Jersey.

Qualifications

• 8+ years of experience in Quality Assurance testing or related software testing.
• ETL testing experience with advanced SQL to validate requirements and data mappings.
• Experience with Oracle financials platform and testing in financial domain.

Responsibilities

• Develop, design, and execute test cases to validate end-to-end data flow in data warehouse.
• Analyze requirements and design test standards and procedures; maintain documentation of test results.
• Review test results to ensure coverage of functional and technical requirements; provide feedback to stakeholders.
• Coordinate with developers, business analysts, and QA teams to ensure quality across modules.

Skills

ETL Testing

Advanced SQL

Financial Domain

Automation

Education

BS in Computer Science

Tools

JIRA

Confluence

Test Management Tools

Defect Management Tools

Job description

Job Description of Essential Duties and Responsibilities:

• Develop, design, and execute the test cases to test the end-to-end data flow in the existing data warehouse architecture
• Participate and assist in requirement analysis and design Analyzes and writes test standards and procedures
• Organizing and maintaining documentation of test results
• Reviews test results to ensure the entirety of requirements both from a functional and technical standpoint are covered as per business needs and is willing to provide necessary feedback to the involved project stakeholders
• Interacts with development engineers, business analysts and internal support groups

Job Accountabilities:

• Involved in the initial project planning and design phase, understanding the scope of the project requirements
• Identify the scope, test scenarios, test cases, test approach, the overall test coverage, requirement gaps and potential risks
• Writes detailed test strategies and plans, making full use of different test estimation techniques in assessing best balance of coverage and efficiency for a project
• Writes detailed test SQL scripts to test the core technical functionality of the proposed database tables from the mapping requirement document
• Ensures requirements traceability and identifies areas for improvement
• Preparation and management of test data conditions
• Focus on solution-oriented approach and able to identify complete end to end testing needs involving multiple parts of a product and system
• Manages the validation test phase including executing scripts, monitoring testers, logging and tracking problems found, and regression testing any changes made to the system
• Document and maintain QA test process and procedures and create a repository of test documentation Troubleshooting errors found in the test environment with minimal help from Development teams
• Analyze defects functionally and technically before assigning them to Development teams
• Support project managers and other stakeholders to complete projects within schedule, without compromising testing quality
• Raise Jira issues to right levels of management using established channels of escalation

Qualifications:

• Overall 8+ years of experience as Quality Assurance testing or relevant experience development
• Must have ETL Testing experience with Advanced SQL skills to validated business requirements and Source to target data mapping with data warehouse
• Good to have Experience with
• ORACLE financials platform with operating system architecture
• Hands on Experience with Automation is preferred
• Experience in working with Test Management Tools and Defect Management Tools like JIRA /Confluence
• Experience working with customers/business users on Financial Domain
• BS in Computer Science or related field or equivalent experience in software testing

Knowledge, Skills, and Abilities:

• Good conceptual understanding of the General Ledge process and Electronic Funds Transfers
• Excellent written and verbal communication skills with the ability to effectively articulate analyses of topics of discussions and conclusions of discussions or meetings, including the ability to lead others effectively in a meeting or call
• Strong interpersonal and presentation skills
• Critical thinking and problem-solving skills; ability to use sound judgment in communications with management and organizational project stakeholders
• Self-motivated with the ability to work in both independent and team environments

Requirements

Oracle GL QA Testing

Overall 8+ years of experience as Quality Assurance testing or relevant experience development

Must have ETL Testing experience with Advanced SQL skills to validated business requirements and Source to target data mapping with data warehouse

Good to have Experience with ORACLE financials platform with operating system architecture

Hands on Experience with Automation is preferred

Experience in working with Test Management Tools and Defect Management Tools like JIRA /Confluence

Experience working with customers/business users on Financial Domain

BS in Computer Science or related field or equivalent experience in software testing