Automate an ETL from a single HTTP file download to SQL Server

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 8 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

Small training task needed for personal project, this should not take more than 2 hours to complete for a skilled developer. Web File Download and Upload Into SQL Server, Create a short walkthrough video in SSIS or Talend Open Studio showing how to: 1. download a 120mb CSV file from an HTTP source 2. performing a 3 way data split to match up formatting against SQL Server database structure 3. Load the data records into a SQL Server database and send an email notice of any issues 4. Execute a existing Stored Procedure to complete the process

Data Processing

Data Warehousing

Microsoft SQL Server

Ταυτότητα εργασίας: 9447694

Σχετικά με την εργασία

2 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@ashupathania

I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.

$25 USD σε 1 ημέρα