Congratulations!

ETL and ELT in Python

Jake Roach

Data Engineer

Designing and building data pipelines

$$

  • Designing sound data pipelines
  • Extract, transform, and load architecture
  • Exception handling and logging

An ETL pipeline.

ETL and ELT in Python

Advanced ETL techniques

$$

  • Handling nested JSON
  • Advanced transformation logic
  • Persisting data to SQL databases

$$

{
    "863703000": {
        "volume": 1443120000,
        "price": {
            "close": 0.09791,
            "open": 0.12187
        }
    },
    ...
}
ETL and ELT in Python

Deploying and maintaining data pipelines

$$

  • Validate and test data pipelines
  • Running a pipeline in a production setting
  • Orchestration tools

A validated data pipeline.

ETL and ELT in Python

Next steps

$$

DataCamp logo.

$$

Airflow, Astronomer, and Snowflake logos.

  • Apache Airflow
  • Astronomer
  • Snowflake
ETL and ELT in Python

Thank you!

ETL and ELT in Python

Preparing Video For Download...