Extract, Transform, Load (ETL)

David Halloran

Contact for pricing

About this service

Summary

If you have a bunch of data entry tasks that just requires copy/pasting things from one source to another then this is for you. If anything takes very little analysis, it can be automated!

Process

-You record the process you are currently doing and send it to me (be as thorough as possible so I can see what needs to be done)
-I follow up with clarifying questions to make sure we are all aligned on what needs to be done
-I get to work, depending on the scale it could take anywhere from a week to a couple months. If it ends up being a multi week project, you'll get weekly reports about what the progress is.
-I deliver the code to you with procedural documents about how to set up and run the automation
-If something breaks within the 1st month, send me a screenshot of the error and I will patch it

FAQs

  • You mentioned I will need an API? What is that?

    Some projects will need an API. This stands for Application Programming Interface and is how, in basic terms, how websites and programs talk to each other. APIs are not free but are often negligible in small amounts of uses, if a program requires one I will let you know to sign up for an account

What's included

  • Automation/Aggregation of Data Entry

    -Python Script designed to automate this task -Procedural document explaining in depth how to use the new program -Weekly status updates -1 month of support to fix edge cases that may come up

Skills and tools

Automation Engineer

Database Engineer

Software Engineer

Microsoft Excel

Microsoft Excel

pandas

pandas

Python

Python

SQL

SQL

More services

Excel to SQL Migration

Contact for pricing