Enterprise ETL And Data Integration Modernization

Overview

Use this skill when delivery depends on classic enterprise ETL tooling, not only modern code-first platforms. It helps agents reason about mapping logic, scheduler dependencies, restart behavior, metadata export, migration sequencing, and coexistence between legacy ETL platforms and newer Spark, dbt, Airflow, or lakehouse stacks.

When to Use

• working with Informatica, Talend, DataStage, SSIS, or Matillion
• reverse-engineering existing ETL mappings and workflows
• modernizing or migrating legacy ETL jobs
• adding quality, lineage, and operational controls to GUI-driven pipelines
• running hybrid estates where old and new tooling must coexist

Do not assume enterprise ETL logic is simple just because much of it is configured through a UI.

Workflow