Remote Web Development Job In IT And Programming

Ssis and scripts for excel and geocoding

Find more Web Development remote jobs posted recently Worldwide

Create generic packages so that data/tables can be used by anyone.

SSIS Package #1:
Loop through options for each group id , group name in stored Proc or table
Get data from the loop
populate template xlsx file
Reformat it (template includes data tab , and two pivots that should be auto populated).
Save with specific names based on group id , group name from above plus date
go to next groupid , groupname in the list until done.
Create job script to execute ssis and create email from job as HTML.
notify users that the file is available now in the directory specified.


SSIS Package #2:

Have a loop similar to #1
I will share a file with shortlisted candidates export those file
open source free tool to create xlsx files.


During loop:
get data , create initial page with raw data , second sheet with pivot chart , third sheet with graphs.
save with specific name as above with date.
SIS Package #3

Create Google and Bing Geolocation API that will map Customer database with unique id, address, city , state , zip USA only.
Which will output all of the input table plus longitude and latitude and status if nothing is found.


SQL Stored Procedure :

Similar to #3 but it will take input address and list of other addresses from database and provide output of distance in Miles between those addresses.


About the recuiter
Member since Mar 14, 2020
Adi Bangun Hard
from Chieti, Italy

Candidate shortlisted and hiredHiring open till - Oct 13, 2021

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.73

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Transportation related - Robotic Process Automation (RPA)

Experienced in Designing, Developing and Implementing of Robots to automate repetitive and manual business processes using (RPA) Kofax Kapow.
Experienced in automating data extraction and validation of paper-based PDF document processing using...read more

Python Data Engineer needed

We are looking for a python developer who has good experience with ETL, SQL and AWS. The candidate will be creating data engineering solutions and migrating data. The engineer should be a self-driven problem-solver who loves taking on new challenges...read more

PostGreSQL-Vacuum Expert needed

We have a Ruby code base that runs multiple jobs on our website. We deployed a piece of code and saw that it bloated up one table in our database because of several updates that happened in this table due to the code.

We need 3 things in th...read more

.NET Framework 4.7.2 Web App troubleshoot help needed

We currently have a .NET web app developed in Visual Studio 2019. We originally included two projects each with an API. We then tried combining everything into a single project using controllers and models and now find legacy references to one of t...read more

Airflow Consulting

Looking for an airflow expert to guide my ETL project workflow (get data from rest and database).