Oracle DB/ETL Tester & Automation Lead

MassGenics, Inc.; Plano (TX); On-site; USD 76,000 - 83,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

Dental/vision insurance

401(k)

HSA and FSA

Life Insurance

Pet Insurance

Short term and Long term Disability

Accident & Critical illness coverage

Pre-paid legal & ID theft protection

Sick time and paid leaves

Employee Assistance Program (EAP)

Job summary

Innova Solutions in Plano, TX seeks a DB/ETL Tester + Automation to join our IT team. The role is a full-time contract (12+ months) based in Plano, TX, offering a pay range of $55–$60 per hour.

The ideal candidate will have 5+ years in ETL/database testing, Oracle SQL/PLSQL, and automation testing, with strong data validation and data warehousing knowledge. Banking domain experience is a plus.

Qualifications

• 5+ years of ETL and database testing with data validation, reconciliation and source-to-target mapping verification.
• 5+ years of Oracle SQL/PLSQL development including complex queries, procedures, functions and performance tuning.
• 5+ years creating and maintaining database objects such as tables, views, indexes, sequences, synonyms, materialized views, procedures, functions, packages and triggers.
• 3+ years of automation testing using industry-standard tools/frameworks.
• 5+ years of test planning, test case design, defect tracking and test execution processes.
• 5+ years working with Oracle databases and data warehousing concepts.
• Experience in banking or financial domain.

Responsibilities

• Perform ETL and database testing with data validation and reconciliation.
• Develop and optimize Oracle SQL/PLSQL queries and DB objects.
• Lead automation testing efforts using standard frameworks.
• Plan tests, design test cases, track defects, and execute tests.
• Collaborate on banking/financial domain requirements.

Skills

ETL testing

Data validation

Data reconciliation

Source-to-target mapping

Oracle SQL

PL/SQL

Automation testing

Test planning

Defect tracking

Banking domain experience

Data warehousing concepts

Tools

Automation frameworks

Job description

Innova Solutions in Plano, TX seeks a DB/ETL Tester + Automation to join our IT team. The role is a full-time contract (12+ months) based in Plano, TX, offering a pay range of $55–$60 per hour.

The ideal candidate will have 5+ years in ETL/database testing, Oracle SQL/PLSQL, and automation testing, with strong data validation and data warehousing knowledge. Banking domain experience is a plus.