Innovative solution to boost Oracle Data Integrator productivity.
A New Way to Build ETL
Transforming Business Logic Into Production‑Ready ETL Code
Modern data teams struggle with a simple truth: business logic lives in documents, meetings, and analysts’ heads—not in code.
I built a tool that changes this.
It takes annotated SQL‑like business rules, written by analysts in the language they already understand, and automatically generates clean, consistent, production‑ready ETL code.
No more translation gaps. No more duplicated logic. No more ambiguity.
Just a single source of truth.
Template Driven
A template‑based compiler that guarantees reproducible, governed ETL across your entire data ecosystem. Analysts define the rules—templates take care of the ETL.
Automated ODI 12c and ODI 11g Generator
From SQL‑like Rules to Fully‑Built ODI Mappings, Packages, and Scenarios
This tool extends the semantic ETL workflow by transforming SQL-like logic into Oracle Data Integrator (ODI) 12c artifacts. It takes the output of the first tool—the annotated SQL‑like business rules—and converts them into executable ODI mappings, packages, and scenarios.
Together, the two tools form a complete pipeline:
Business Rule → DSL → ETL Code → ODI Mapping → ODI Package → ODI Scenario
This closes the loop between business intent and operational execution.
About Me and My Work
Data Engineering and Architecture Expertise
With 30 years of experience across software engineering, data management, data integration, and business intelligence, I have helped organizations design and deliver complex data warehouse solutions. My career spans the full spectrum of technical roles—from database and system administration to data engineering and software architecture—giving me a deep, end‑to‑end understanding of modern data ecosystems. I combine practical experience with a passion for building tools that bring clarity, consistency, and automation to data workflows.