Automated ETL process of transferring contractors' data from external systems to a target system.
Functions:
- Data extraction of contractors from source systems to flat files.
- Clearing and transforming Tax Id. Number into a bigint value.
- Loading consistent processed data to a target system.
- Automatization of the process of running SSIS packages according to a schedule with planned intervals.