etl-orchestration

Automate ETL orchestration by defining DAGs and workflows across Airflow, Dagster, or Prefect.

3|Updated May 28, 2026
One-click install
npx skills add https://github.com/mahg-es/araya --skill etl-orchestration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: etl-orchestration
Source: https://github.com/mahg-es/araya/tree/main/skills/etl-orchestration
Command: npx skills add https://github.com/mahg-es/araya --skill etl-orchestration

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Coordinating multiple ETL jobs across different orchestration systems can be error-prone, leading to missed runs, data drift, and delayed insights.

Core Features & Use Cases

  • Design and manage DAGs across Airflow, Dagster, and Prefect for scalable ETL pipelines.
  • Provide scheduling, dependency management, retries, monitoring, and alerting to ensure data reliability.
  • Use case: orchestrate nightly batch loads, handle data lineage, and recover gracefully from failures.

Quick Start

Configure your first ETL workflow by selecting an orchestrator (Airflow, Dagster, or Prefect), define a simple DAG with a single schedule, and set a basic retry policy.

Frequently Asked Questions about etl-orchestration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I orchestrate ETL pipelines with retries and health monitoring?

You orchestrate ETL pipelines by defining DAGs across Airflow, Dagster, or Prefect to manage schedules, dependencies, retry policies, and alert configurations for reliable data workflows.

What is the best way to build scheduled data pipelines with dependencies?

Building scheduled data pipelines requires defining DAGs that handle task dependencies and automated retries, ensuring nightly batch loads execute reliably while managing data lineage and failure recovery.

Can I deploy ETL workflows using Docker Compose or managed services like MWAA?

Yes, you can deploy ETL workflows via Docker Compose for self-hosted environments or use managed services like MWAA and Prefect Cloud to scale your orchestration across different environments.

Does this ETL orchestration approach work with Airflow, Dagster, and Prefect?

Yes, ETL orchestration supports designing and managing DAGs across Airflow, Dagster, and Prefect, allowing data engineering teams to scale pipelines and handle failure recovery gracefully.

Why do I need ETL orchestration for nightly batch loads and data lineage?

ETL orchestration prevents error-prone manual coordination that causes missed runs and data drift, ensuring nightly batch loads maintain data reliability, handle lineage, and recover from failures.