I will build etl data pipelines using python handle data scientist

Kenya

I speak English

53 orders completed

i enjoy watching nat geo wild and other channels about nature. i also enjoy reading books and it is one of the reasons i could excel in getting my degree.
About this Gig

Do you need to move, transform, clean or synchronize data between databases, files or APIs?

I will build a reliable ETL/ELT data pipeline using Python and SQL to move data between different sources and target databases.

I can build simple batch pipelines as well as more structured data integration solutions.

I can build pipelines for:

  • PostgreSQL SQL Server
  • SQL Server PostgreSQL
  • MySQL PostgreSQL
  • CSV/Excel Database
  • API Database
  • Database Data Warehouse
  • Multiple database sources Staging Target
  • Incremental data loading
  • Batch processing
  • Data cleansing and transformation
  • Duplicate detection
  • Data validation
  • Error handling
  • Logging and audit tracking

TECHNOLOGIES

  • Python
  • Pandas
  • NumPy
  • SQL
  • PostgreSQL
  • SQL Server
  • MySQL
  • Oracle
  • REST APIs
  • ETL/ELT concepts
  • Data warehousing
  • Staging tables

Destination Platform:

Snowflake

•

Google BigQuery

•

PostgreSQL

Tools & Platforms:

Google Cloud Dataflow

•

Kafka Connect

•

Debezium