Oracle SQL/PLSQL ETL Developer

Quantum Technologies. LLC; San Antonio (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Quantum Technologies. LLC in San Antonio, TX, seeks an experienced data integration engineer to review Alteryx workflows, write Oracle SQL/PL/SQL, and consolidate logic into robust database procedures.

You will validate converted results, reduce redundancy across ETL processes, and document data lineage and calculations. Power BI experience is a plus; strong analytical and documentation skills are essential. This is a full-time role with a focus on reliable data delivery for reporting.

Qualifications

• Hands-on Oracle SQL and PL/SQL development experience, including stored procedures.
• Alteryx workflow analysis and review.
• Experience with relational databases and structured datasets.
• Experience converting flat-file processes into database structures.
• Strong analytical and troubleshooting skills.
• Technical documentation proficiency.

Responsibilities

• Analyze existing Alteryx workflows, SQL logic and flat-file reporting processes.
• Develop Oracle SQL and PL/SQL code, including stored procedures that consolidate duplicated logic and implement Alteryx/flat-file transformations.
• Decide which Alteryx transformations to retain and which to move into Oracle procedures.
• Convert flat-file processes into structured database tables and processes.
• Validate results via record counts, totals reconciliation, and verification of calculations, filters and rounding rules.
• Reduce redundant ingestion, processing and transformations across workflows.
• Support customer segmentation and AR reporting workstreams.
• Create historically trackable datasets for trending and analysis.
• Maintain data relationships so customer information can be analyzed holistically.
• Support Power BI and downstream reporting.
• Document source-to-target mappings, data lineage and transformation logic clearly.
• Help create transparent processes understandable to business stakeholders.

Skills

Oracle SQL

PL/SQL development

Alteryx

Relational databases

Data transformation

Analytical troubleshooting

Technical documentation

Tools

Power BI

ETL tooling

Job description

Quantum Technologies. LLC in San Antonio, TX, seeks an experienced data integration engineer to review Alteryx workflows, write Oracle SQL/PL/SQL, and consolidate logic into robust database procedures.

You will validate converted results, reduce redundancy across ETL processes, and document data lineage and calculations. Power BI experience is a plus; strong analytical and documentation skills are essential. This is a full-time role with a focus on reliable data delivery for reporting.