Suljettu

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.

Taidot: Liiketoimintatiedon hallinta, Tietovarastointi, Microsoft SQL Server, SSIS (SQL Server Integration Services)

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) India

Projektin tunnus: #17421417

22 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 10 päivässä
(11 arvostelua)
3.9
₹36666 INR 7 päivässä
(8 arvostelua)
3.2
₹38888 INR 2 päivässä
(2 arvostelua)
3.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. Lisää

₹41666 INR 10 päivässä
(1 arvostelu)
1.0
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 10 päivässä
(0 arvostelua)
0.0
₹38888 INR 3 päivässä
(0 arvostelua)
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 Lisää

₹38888 INR 5 päivässä
(0 arvostelua)
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 Lisää

₹41666 INR 10 päivässä
(0 arvostelua)
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 14 päivässä
(0 arvostelua)
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 Lisää

₹42222 INR 12 päivässä
(0 arvostelua)
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 Lisää

₹41666 INR 10 päivässä
(0 arvostelua)
0.0
₹35000 INR 3 päivässä
(0 arvostelua)
0.0
₹38888 INR 15 päivässä
(0 arvostelua)
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 15 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 12 päivässä
(0 arvostelua)
0.0
₹35555 INR 30 päivässä
(0 arvostelua)
0.0
sardarbaji

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

₹38888 INR 4 päivässä
(0 arvostelua)
0.0
₹35000 INR 8 päivässä
(0 arvostelua)
0.0
vw8033419vw

I have 5+ years of experience in MSBI

₹38888 INR 7 päivässä
(0 arvostelua)
0.0