TEMPLATES ABC.sh Extract.sh Transform.sh Load.sh Test_Validation.sql

STTM Target Model Source(s) Model Pre-processing Rules Post-processing Rules Transformations

Requirements IIm Agent Requirements Tools Requirements Security requirements prompts directory structures

env info test config job run config

CI/CD

STTM Parser excel -> json/txt

Workflow creation/visualization

Code generation ETL scripts (.sh) ABC scripts (.sh)

Graph creation DAG (.py)

Git Commit {Manual/automated}

Deploy {Git Actions/Security Scans}

Graph Compile/Graph Run

CT

STTM Parser excel -> txt

Test Plan creation Test Scripts (.sql)

Test Automation Script DAG (.py)

Git Commit {Manual/Automated}

Deploy {Git Actions/Security Scan}

Graph Compile/Graph Run

Reporting Dashboard/email

CI/CD Normal Flow QA Setup ABC Run Pipeline Run Automated tests

Set-up ABC Run Pipeline Automated DAG Daily/Monthly Scheduled test validation & reporting Integration with DQ