Find Jobs
Hire Freelancers

Create an daily ETL from XX Excel files to SQL

$450-3750 MXN

Concluído
Publicado há quase 7 anos

$450-3750 MXN

Pago na 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.
ID do Projeto: 14576804

Sobre o projeto

41 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 similar packages in SSIS. Proposed Milestones $2111 MXN - I will deliver a complete package.
$2.422 MXN em 3 dias
4,9 (5 avaliações)
3,9
3,9
41 freelancers estão ofertando em média $2.765 MXN for esse trabalho
Avatar do Usuário
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 experience with Microsoft Technologies. Previous experience on Excel importing and parsers. Proposed Milestones $2222 MXN - Project completion
$2.222 MXN em 5 dias
5,0 (3 avaliações)
4,8
4,8
Avatar do Usuário
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 accordingly. Please do let me know if you have any questions and I'm looking forward to this job. Regards
$3.750 MXN em 20 dias
5,0 (5 avaliações)
4,5
4,5
Avatar do Usuário
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 more details and when we will start. Sky pe jikenjd
$1.075 MXN em 0 dia
5,0 (22 avaliações)
4,1
4,1
Avatar do Usuário
I am sql server dba having more then 10 yrs of experience
$1.666 MXN em 2 dias
4,6 (30 avaliações)
4,6
4,6
Avatar do Usuário
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 highlight of its most important features: 1. Extraction - PDI could extract data from any kind of a. RDBMS system - Oracle, MySQL, PostgreSQL and many others. b. NoSQL - Hadoop, MongoDB, CouchDB, Cassandra and others. c. Files - CSV, XML, Excel, JSON and many others. d. Web Services/RSS Feeds and many other data sources. 2. Transformation - PDI has large number of built-in steps for data processing: filtering, sorting, aggregation, lookups, additional calculations, etc. 3. Load - PDI could export the processed data into many different formats or it could load it into a relational/non- relational database management system. It's important to note that Pentaho Kettle is FREE and open source software (OSS), so it's very easy to extend it with custom plugins. Moreover, its UI is very intuitive, which makes the implementation/building/deployment/maintenance of the code a lot easier than any bash/python/java/C# solution you would come with. If you need more details about Pentaho Kettle, feel free to contact me. (I could give you a quote for the price, when I get more info about the job and the scope.) Best Regards, Vesselin Z.
$10.000 MXN em 14 dias
4,7 (3 avaliações)
4,4
4,4
Avatar do Usuário
create job to update sql data with excel Relevant Skills and Experience SQL/Excel Proposed Milestones $3200 MXN - Complete job
$3.200 MXN em 7 dias
5,0 (5 avaliações)
3,6
3,6
Avatar do Usuário
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 - C#, Java, PHP, JavaScript, JQuery Database - MySQL, SQL Server, Maria DB ETL - SSIS BI-MicroSoft SQL Server BI Proposed Milestones $2400 MXN - Project Completion Let us discuss further details over phone or chat.
$2.400 MXN em 15 dias
4,9 (3 avaliações)
3,8
3,8
Avatar do Usuário
A proposal has not yet been provided
$2.500 MXN em 2 dias
5,0 (7 avaliações)
3,1
3,1
Avatar do Usuário
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 Milestones $475 MXN - 1
$475 MXN em 3 dias
5,0 (3 avaliações)
2,1
2,1
Avatar do Usuário
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 for 2 possibilities to do this ,first is to create it in sql server job or to create a windows service that will handle what you want. talk to me via chat so we can discuss further. thank you.
$3.300 MXN em 4 dias
4,0 (1 avaliação)
2,8
2,8
Avatar do Usuário
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 projects and filling forms or websites. we have expertise in Excel Macros , Excel Dashboards , spread sheets , tables ,excel analysis etc... we are certified from Microsoft in SQL Server , Oracle ,MSBI. we want to make our foot prints so strong in freelancing world and we need a opportunity to prove our self. we have completed 2 projects successfully and looking forward to work with you. Looking forward to hear from you. Please feel free to ping us.
$3.333 MXN em 7 dias
5,0 (2 avaliações)
1,3
1,3
Avatar do Usuário
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 Proposed Milestones $1111 MXN - milestone
$1.111 MXN em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 MXN - Meeting-> Design>UAT>Delivery
$3.333 MXN em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 Experience 11 years working with Oracle, that includes transforming data, tuning database, converting huge excel data into the database, creating processes to generate big data, developing in pl/sql, sql and etc Proposed Milestones $350 MXN - do a quick survey about details of the project and start to study and understand the project itself. $1000 MXN - start the developing process (read, update database and email routine) $316 MXN - test project Additional Services Offered $350 MXN - if needed, I can develop a program to consult the data using Oracle Forms 6i, 11g or 12c. which database do you use? can I get the spreadsheets? what email server do you use?
$3.750 MXN em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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: Snowflake, Star schemas, SCDs, TYPE1, Type2. SQL, Stored procedures Stay tuned, I'm is still working on this proposal.
$3.333 MXN em 12 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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.
$2.555 MXN em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I worked with this kind of work everyone day. For that project, what kind of Tool i Will use?
$525 MXN em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$475 MXN em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am an ETL architect having 12 yrs of exp in large dwh BI projects. I am a certified Informatica, Oracle professional.
$1.650 MXN em 20 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 scripting knowledge Proposed Milestones $1000 MXN - informatica mapping development $400 MXN - unix script to delete source files $266 MXN - view creation based on tables
$1.666 MXN em 5 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) MEXICO
Mexico City, Mexico
5,0
3
Método de pagamento verificado
Membro desde abr. 1, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.