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

$10-30 USD

Opravljeno

Objavljeno

pred več kot 8 leti

$10-30 USD

Plačilo ob dostavi

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

ID projekta: 9447694

Več o projektu

2 ponudb

Projekt na daljavo

Aktivno pred 8 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@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 v 1 dnevu