Duration: 10+ months
Compensation: up to $70/hr
Location: 100% REMOTE
Responsibilities:
- Must have at least 8 years of SSIS experience, including using tools such as Import and Export Wizard, Package Installation and SSIS Package Designer.
- Should have experience importing/exporting data between different sources such as SQL Server/Access/Excel etc. using the SSIS/DTS utility.
- Must be able to create CTE's (Common Table Expressions), temp tables and effective DDL/DML triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
- Create configuration files to deploy the SSIS packages across all environments.
- Experience in ETL processes involving migrations and in sync processes between two databases.
- Transform data from one server to others using tools like Bulk Copy Program (BCP), and SSIS.
