Closed

Data Validation & Transformation using SSIS Packages - 23/07/2018 05:44 EDT

The project basically revolves around the ETL (Extract, Transform & Load) process. Data Validation & Transformation is the most critical piece of the project. We are looking for a freelancer who has the knowledge of the SSIS Packages.

Sample:

Validation 1 - Mobile number should not be more than 10 digits.

If the above condition throws an error, it will go through a set of transformation rules like

1) "+91" is present

2) "~" is present instead of 0's

If the above conditions are true, it will go through transformation. Else an exception would be created for Inaccurate data.

Please note that this is a time-constraint project.

Habilidades: Business Intelligence, Armazenamento de Dados, Microsoft SQL Server , SSIS (SQL Server Integration Services)

Veja mais: ssis tutorial step by step, ssis package tutorial, ssis download, ssis package download, ssis tutorial for beginners, ssis packages in azure, create ssis package in visual studio 2012, ssis etl, saving grid data xml file using extjs, data mapping oracle using informatica, automatic data entry table using javascript, data weight machine using vbnet, send form data mysql database using php, excel data validation empty cell 2007, ajax data grid system using php mysql, data oracle batch using excel vba, data scraping website using, data validation marketing research, download data yahoo finance using vb6, read data excel sheet using save mysql

Acerca do Empregador:
( 0 comentários ) India

ID do Projeto: #17421417

23 freelancers estão ofertando em média ₹38381 para esse trabalho

sreenivas2903

hi I am expertise in etl part and can do whatever needed please let me know more info and can also discuss

₹35555 INR in 10 dias
(9 Comentários)
3.7
₹36666 INR in 7 dias
(8 Comentários)
3.2
₹38888 INR in 2 dias
(1 Comentário)
2.4
neetithakkar

currently i am working with vb.net application. We are creating ERP and POS system. So we are using SSIS package for sync Items in POS system and sync orders to ERp system from POS system.

₹41666 INR in 10 dias
(0 Comentários)
0.0
armandoajr

Hi. Good Morning! My name is Armando. I am DBA. I work with SQL Server 14 years. I can help you. Waiting your apply. Best regards.

₹40000 INR in 3 dias
(0 Comentários)
0.0
raknahs773

Hi I have extensive experience in data querying and analysis. I have worked with SQL Server stack which includes, SQL, SSAS, SSRS, SSIS and basic PowerBI. I have also created tableau dashboards on top of SQL Server da Mais

₹38888 INR in 5 dias
(0 Comentários)
0.0
atporter

I've been a SQL Server DBA for the last 16 years. During this time I've worked in operations as well as in development spaces where I focused mainly on writing SSIS packages for iHeartRadio and UnitedHealthGroup in the Mais

₹41666 INR in 10 dias
(0 Comentários)
0.0
seopraveen

I am having experience of 5 + years in SSIS and SQL automation projects and deals with complex SQL codes on daily basis.. So I can be ideal choice for you. Test my work and then pay on satisfaction.

₹38888 INR in 14 dias
(0 Comentários)
0.0
NikhilEVR

The project sounds very interesting. I had developed similar ETL packages in past for similar business requirements and few of them even had flat files/XML files as data source (compared to traditional database to data Mais

₹42222 INR in 12 dias
(0 Comentários)
0.0
rodame1

I have years of experience in the some of the best environments when it comes to ETL. I have work with the European Project on plant genomics and this was on a tight deadline and yet completed successfully. Worked on a Mais

₹41666 INR in 10 dias
(0 Comentários)
0.0
₹35000 INR in 3 dias
(0 Comentários)
0.0
₹38888 INR in 3 dias
(0 Comentários)
0.0
₹38888 INR in 15 dias
(0 Comentários)
0.0
bittu35

I am having experience of working with Canadian bank client in same technology. I am having brief knowledge of ETL tools like SSIS and Pentaho, where I have implemented these kind of validations and functionalities.

₹38888 INR in 15 dias
(0 Comentários)
0.0
raghvendrarajak

Hi, I am microsft certified database developer . havening better knowlege of SSMS, SSIS. having two years of experience . Regards Raghvendra

₹35000 INR in 3 dias
(0 Comentários)
0.0
jargedshreyansh

Worked on very similar task with my previous employer , I have complete knowledge on SSIS, Informatica,Sql Server and Teradata in addition with it I can write Unix Bash script if needed.

₹36111 INR in 12 dias
(0 Comentários)
0.0
₹35555 INR in 30 dias
(0 Comentários)
0.0
sardarbaji

Have more than 5 years of experience in SSIS, Sql Relevant Skills and Experience SSIS, SQL,

₹38888 INR in 4 dias
(0 Comentários)
0.0
₹35000 INR in 8 dias
(0 Comentários)
0.0
ygenchik

Dear Employer, I specialize in SSIS - I know how to use it, I know how to extend it, and I teach it too. The sample transformation you describe is done in the data flow, and can be implemented in several ways. Mais

₹41666 INR in 10 dias
(0 Comentários)
0.0