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.
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.
23 freelancers estão ofertando em média ₹38381 para esse trabalho
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.
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.
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.
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.