Find Jobs
Hire Freelancers

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

₹35000-40000 INR

Zamknięte
Opublikowano ponad 5 lat temu

₹35000-40000 INR

Płatne przy odbiorze
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.
Identyfikator projektu: 17421417

Informację o projekcie

20 ofert
Zdalny projekt
Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
20 freelancerzy składają oferty o średniej wysokości ₹38 249 INR dla tej pracy
Awatar Użytkownika
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. You can use: conditional Split and "Fork" your code with the expressions engine there You (sometimes) can use the same expression engine with the the ProductVersion == @Version? ProductVersion : @Version syntax to transform data based on conditions you can use scripting capabilities and write .net functions doing it you can even write your own component if you have complex logic, that does necessary parsing, comparison and transforms in code - and this component will install into the dataflow folder. I would like to hear the scope of the project to understand how best develop it to suit your needs and whether it could be done within your budget. I am open for the dialogue. I am in the pacific time zone. I will have availability to start on Wednesday. I prefer written communication, although I can meet with you on Zoom - video conferencing software. Upon establishing the plan I suggest to release code/money in stages. Sincerely, Virginia
₹41 666 INR w 10 dni
5,0 (4 opinii)
4,9
4,9
Awatar Użytkownika
hi I am expertise in etl part and can do whatever needed please let me know more info and can also discuss
₹35 555 INR w 10 dni
4,9 (14 opinii)
4,3
4,3
Awatar Użytkownika
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.
₹41 666 INR w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I have 5+ years of experience in MSBI
₹38 888 INR w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Have more than 5 years of experience in SSIS, Sql Relevant Skills and Experience SSIS, SQL,
₹38 888 INR w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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.
₹36 111 INR w 12 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I am microsft certified database developer . havening better knowlege of SSMS, SSIS. having two years of experience . Regards Raghvendra
₹35 000 INR w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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.
₹38 888 INR w 15 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 database ETL). Looking forward to hearing from you
₹42 222 INR w 12 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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.
₹38 888 INR w 14 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 USA. I'm very familiar with error handling, writing enough comments in the packages so it wont be difficult for another person to make changes/enhancements to the package later on.
₹41 666 INR w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I have one and half years experience on SSIS and ETL. At present i don't have much work so i can assure you that i can complete your requirement well before the deadline.
₹38 888 INR w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga INDIA
India
0,0
0
Członek od lip 23, 2018

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.