Create an daily ETL from XX Excel files to SQL

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

I need to create a daily job that loads the following Excel files into the corresponding SQL Tables. Each row on the excel file should either update or insert on the SQL rows (depending on the Primary Key). The structure of the excel files is exactly the same as the SQL tables (just beware of datetime columns). The ETL should follow this order:

DIM_ACTIVITY_TYPES to [login to view URL]

DIM_CLM to [login to view URL]

DIM_CRM_PRODUCTS to [login to view URL]

DIM_CUSTOMERS to [login to view URL]

DIM_CYCLES to [login to view URL] (distinct values) and [login to view URL]

DIM_EMPLOYEES to [login to view URL]

DIM_RATINGS to [login to view URL]

DIM_TEAM to [login to view URL]

DIM_TERRITORIES to [login to view URL]

FACT_ALIGNMENTS to [login to view URL]

FACT_CLM to [login to view URL]

FACT_EVENTS to [login to view URL]

FACT_SAMPLES_INVENTORY to [login to view URL]

FACT_SAMPLES_SHIPMENTS to [login to view URL]

FACT_TIME_OFF_TERRITORY to [login to view URL]

FACT_TODOS to [login to view URL]

After finishing the daily data load, the job should search for files that are more than 30 days old (based on the file name, which has a date) and delete them.

If at any point there is an error, for example, a file is missing or corrupt, an email should be sent.

I will also need you to create some simple views to group and summarize data combining Dims and Facts.

Data Wahrehousing SQL

Nº del proyecto: #14576804

Sobre el proyecto

41 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

farrukhcheema23

Hi, Its Farrukh here sir. I am ready to start working as soon as you want. I am willing to do it in 2000-MXN. Please accept it if you are OK with it. Thank you Relevant Skills and Experience I have made so many sim Más

$2422 MXN en 3 días
(5 comentarios)
3.9

41 freelancers están ofertando un promedio de $2765 por este trabajo

utkuozan76

I will create a scheduled importer which reads data from daily Excel files to Database tables in certain order. Older files will be removed after 30 days. Relevant Skills and Experience 11+ years of Development experi Más

$2222 MXN en 5 días
(3 comentarios)
4.8
IMExpertEngineer

Hello, I'm expert in ETL and have done lot of work on this and I can do this for you . Please share your excel files and backup of database so that I could set these up on my local machine and then start work ac Más

$3750 MXN en 20 días
(5 comentarios)
4.5
vw7590795vw

Please review my profile Relevant Skills and Experience I have 7 years and 7 months experience in SQL and 4 years and 10 months experience in SSRS, SSIS. Proposed Milestones $1075 MXN - SSIS EXCEL Please let me know Más

$1075 MXN en 0 días
(22 comentarios)
4.1
vinaysinghh

I am sql server dba having more then 10 yrs of experience

$1666 MXN en 2 días
(30 comentarios)
4.6
veskojl

Hi, I'm an experienced ETL/Data Warehouse developer and I can offer you a solution based on Pentaho Kettle (a.k.a. PDI). It's an ETL (Extract, Transform, Load) tool that facilitate the processing of data. Here is a Más

$10000 MXN en 14 días
(3 comentarios)
4.4
dpune

create job to update sql data with excel Relevant Skills and Experience SQL/Excel Proposed Milestones $3200 MXN - Complete job

$3200 MXN en 7 días
(5 comentarios)
3.6
abhirajvw

We are a team of excellent web developers and web/data analytics experts. We can provide you best in class and cost effective solution. Relevant Skills and Experience Our team has expertise in below areas. Programming Más

$2400 MXN en 15 días
(3 comentarios)
3.8
pramsweety

A proposal has not yet been provided

$2500 MXN en 2 días
(7 comentarios)
3.1
farhan1991

Hello Sir. I have 5 years of experience in sql development. This is a very easy task I am interested to work for you on this project. Just message me so that we can start Relevant Skills and Experience sql Proposed M Más

$475 MXN en 3 días
(3 comentarios)
2.1
joemarecaro

i am a solutions developer and ive handled many related tasks. please provide database structure, excel files, sample directory path so i can create it locally then i'll give you the script for the agent job. looking f Más

$3300 MXN en 4 días
(1 comentario)
2.8
forususa

Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry proje Más

$3333 MXN en 7 días
(2 comentarios)
1.3
SujataFreelancer

Respected Sir, Kindly initiate a conversation so that we can move ahead. Regards, SUJATA Relevant Skills and Experience Respected Sir, Kindly initiate a conversation so that we can move ahead. Regards, SUJATA P Más

$1111 MXN en 3 días
(0 comentarios)
0.0
cheenu1025

I read your requirement . I am happy to do it. I will create script for this and i will work as per ur req. Relevant Skills and Experience 6 plus experience in sql, oracle , mysql and etl Proposed Milestones $3333 M Más

$3333 MXN en 3 días
(0 comentarios)
0.0
victorhugolazari

Hello, I haven't worked yet for freelancer.com, though, I've been working home office for a long time already, I am very well capable of delivering to you a great final work. Hope it can get right! Relevant Skills and Más

$3750 MXN en 5 días
(0 comentarios)
0.0
kumarreddyk

I have more than 14 years of ETL and Data warehouse expertise. I can get the files loaded (upsert) to your SQL tables. Relevant Skills and Experience ETL tools: Data stage, Informatica, Pentahoe. Data warehouse: Más

$3333 MXN en 12 días
(0 comentarios)
0.0
elton994

I have a huge experience in data integration in Oracle and Sql Server databases, i also make scripts for scheduling jobs in both powershell and shell script scripting languages.

$2555 MXN en 10 días
(0 comentarios)
0.0
gufiorini

I worked with this kind of work everyone day. For that project, what kind of Tool i Will use?

$525 MXN en 10 días
(0 comentarios)
0.0
phuphu121979

A proposal has not yet been provided

$475 MXN en 3 días
(0 comentarios)
0.0
saradasata

I am an ETL architect having 12 yrs of exp in large dwh BI projects. I am a certified Informatica, Oracle professional.

$1650 MXN en 20 días
(0 comentarios)
0.0
naveenyadapalli

informatica workflow for loading files Unix script for deleting source files > 30 days views for data aggregation Relevant Skills and Experience 6+ years of informatica experience sound knowledge in SQL basic unix scr Más

$1666 MXN en 5 días
(0 comentarios)
0.0