Oracle SQL/PLSQL Developer – ETL & Data Transformation

Machine Learning Technologies, LLC; San Antonio (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking a data integration specialist to analyze and optimize Alteryx workflows and move suitable logic into Oracle. You will develop Oracle SQL/PLSQL code, convert flat-file processes to database structures, and validate results with rigorous checks.

The role emphasizes reducing duplication, supporting Power BI reporting, and documenting data lineage and transformations for transparent stakeholder communication.

Qualifications

• Hands-on Oracle SQL/PL/SQL development experience with stored procedures and data transformation logic.
• Proficient in review and understanding of Alteryx workflows.
• Experience with relational databases and structured datasets.
• Experience transitioning data/processes from flat-file workflows into database structures.
• Strong analytical and troubleshooting skills.
• Strong technical documentation skills.

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 and flat-file transformations within Oracle.
• Determine which Alteryx transformations to retain and which to move into Oracle/database procedures.
• Convert appropriate flat-file-based processes into structured database tables and processes.
• Validate converted results against outputs through record-count checks, reconciliation of totals, and verification of calculations, filters, rounding rules, and historical treatment.
• Reduce redundant ingestion, processing and transformations across existing workflows.
• Support the customer segmentation and/or accounts receivable reporting workstreams.
• Help create historically trackable datasets supporting trending and future analysis.
• Maintain relationships between datasets for holistic analysis of customer information.
• Support data consumed by Power BI and other downstream reporting.
• Thoroughly document source-to-target mappings, data lineage, procedures, calculations, filters, rounding rules, historical tracking, data relationships and source locations.

Skills

Oracle SQL

PL/SQL

Alteryx

Relational databases

ETL

Data analysis

Documentation

Tools

Power BI

Job description

Machine Learning Technologies, LLC is seeking a data integration specialist to analyze and optimize Alteryx workflows and move suitable logic into Oracle. You will develop Oracle SQL/PLSQL code, convert flat-file processes to database structures, and validate results with rigorous checks.

The role emphasizes reducing duplication, supporting Power BI reporting, and documenting data lineage and transformations for transparent stakeholder communication.