SSISSQL Developer with Strong SAS Migration

SSIS/SQL Developer with Strong SAS Migration

Remote

W2 role only

Job Description :

We are seeking a highly skilled SSIS (SQL Server Integration Services) Developer with a proven track record in SAS migration projects. The ideal candidate will play a crucial role in migrating data and processes from SAS to SSIS ensuring a seamless transition and optimal performance.

Responsibilities:

1. SAS to SSIS Migration:
Lead the migration efforts from SAS to SSIS including data ETL processes and associated workflows.
Analyze existing SAS solutions and design efficient SSIS equivalents.

2. ETL Development:
Design develop and implement SSIS packages for data extraction transformation and loading.
Ensure data integrity and accuracy throughout the migration process.

3. Data Mapping and Modeling:
Collaborate with stakeholders to understand data requirements and create mapping specifications.
Design and implement data models to support the migration and integration processes.

4. Performance Optimization:
Optimize SSIS packages for performance and scalability.
Conduct performance tuning of SQL queries and transformations.

5. Documentation:
Create comprehensive documentation for SSIS packages mappings and migration processes.
Provide training to endusers and support teams as needed.

6. Collaboration:
Work closely with database administrators data analysts and other IT teams to ensure successful migration and integration.
Collaborate with business users to gather requirements and address datarelated challenges.

Qualifications:

1. bachelors degree in computer science Information Technology or a related field.
2. Proven experience as an SSIS Developer with a focus on SAS migration.
3. Strong understanding of ETL principles and methodologies.
4. Proficient in SQL Server and TSQL scripting.
5. Excellent problemsolving and troubleshooting skills.
6. Strong communication and collaboration skills.
7. Ability to work independently and meet project deadlines.