Oracle SQL/PLSQL ETL Architect

Valiant Technologies LLC; San Antonio (TX); On-site; USD 90,000 - 140,000; Full time

Job summary

Valiant Technologies LLC is seeking a data engineering professional to analyze and optimize Alteryx workflows and migrate suitable logic into Oracle SQL/PLSQL procedures. You will transform flat-file processes into database structures and validate results through rigorous checks, supporting Power BI reporting and historical trend analyses.

The role emphasizes data lineage, robust documentation, and the ability to simplify complex existing pipelines for reliable business insights.

Qualifications

• Hands-on Oracle SQL and PL/SQL development including stored procedures.
• Alteryx workflow review and optimization.
• Experience with relational databases and structured datasets.
• Experience migrating flat-file processes into database structures.
• Strong analytical and troubleshooting abilities.
• 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 suitable Alteryx and flat-file transformations within Oracle.
• Determine which Alteryx transformations to retain and which can be moved into Oracle/database procedures.
• Convert appropriate flat-file-based processes into structured database tables and processes.
• Validate converted results against outputs via 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 so customer information can be analyzed holistically.
• Support data consumed by Power BI and other downstream reporting.
• Thoroughly document: source-to-target mappings and data lineage; procedural and transformation logic; calculations, filters, rounding rules; historical tracking and retention logic; data relationships and source locations; business definitions and interpretation of reporting outputs.

Skills

Oracle SQL

PL/SQL

Alteryx

Relational databases

Data transformation

Analytical skills

Documentation

Tools

Power BI

Job description

Valiant Technologies LLC is seeking a data engineering professional to analyze and optimize Alteryx workflows and migrate suitable logic into Oracle SQL/PLSQL procedures. You will transform flat-file processes into database structures and validate results through rigorous checks, supporting Power BI reporting and historical trend analyses.

The role emphasizes data lineage, robust documentation, and the ability to simplify complex existing pipelines for reliable business insights.