Senior Oracle SQL/PLSQL Developer – ETL & Tuning Expert

BCforward; Addison (TX); On-site; USD 83,000 - 103,000; Full time

Benefits offered by this job

Competitive compensation

Growth opportunities

Inclusive culture

Job summary

BCforward is seeking an Application Programmer III to support an onshore database development effort for an MCL upgrade. The ideal candidate will have strong experience in Oracle SQL and PL/SQL, as well as automation testing and ETL/database testing, and a proven ability to optimize performance, validate data pipelines, and deliver high-quality database solutions.

This contract role is based onsite in Addison, TX, with 3 days onsite per week required.

Qualifications

• 5+ years of Oracle SQL and PL/SQL development with performance tuning expertise.
• Hands-on troubleshooting of SQL performance and execution plans.
• Experience creating and maintaining database objects (tables, views, indexes, sequences, synonyms, materialized views, procedures, functions, packages, triggers).
• Strong understanding of relational databases, data modeling, and Oracle architecture.
• 3+ years in automation testing and the ability to develop maintainable automated scripts.
• 3+ years in ETL and database testing, including data validation and source-to-target mapping checks.
• Proficiency with SQL for large dataset analysis and backend testing in Oracle environments and data warehousing contexts.
• Experience with ETL tools (Informatica, DataStage, SSIS).
• Experience in Agile/Scrum and SDLC.

Responsibilities

• Design, develop, and optimize Oracle SQL and PL/SQL code including complex queries, procedures, packages, functions, and triggers.
• Troubleshoot and resolve database performance issues with SQL tuning and indexing strategies.
• Create and maintain database objects such as tables, views, indexes, sequences, synonyms, and materialized views.
• Develop and maintain automated tests for functional, regression, integration, and end-to-end scenarios.
• Plan tests, design test cases, execute tests, and track defects through resolution.
• Perform ETL and database testing, including data validation, reconciliation, and source-to-target mapping verification.
• Validate ETL processes and data quality across multiple systems.
• Analyze large datasets and perform backend testing using SQL.

Skills

Oracle SQL

PL/SQL

SQL tuning

Automation testing

ETL testing

Data validation

Data pipeline validation

Backend testing

Agile/Scrum

API testing (Postman/REST Assured)

Tools

Informatica

DataStage

SSIS

Jenkins

GitHub

Job description

BCforward is seeking an Application Programmer III to support an onshore database development effort for an MCL upgrade. The ideal candidate will have strong experience in Oracle SQL and PL/SQL, as well as automation testing and ETL/database testing, and a proven ability to optimize performance, validate data pipelines, and deliver high-quality database solutions.

This contract role is based onsite in Addison, TX, with 3 days onsite per week required.