SSIS/SQL Developer with Strong SAS Migration Experience - HCL Global Systems Inc.

SSIS/SQL Developer with Strong SAS Migration Experience (Critical, High Priority)

SO : 74972898_1

Beeline Request ID : 14159-1

Rate : $60/hr

Location : Remote

Client : CVS Health

Healthcare Exp referred

Job Title: SSIS/SQL Developer with Strong SAS Migration Experience

Job Overview:
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 end-users 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 data-related challenges.

Qualifications:

1. Bachelor's 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 T-SQL scripting.
5. Excellent problem-solving and troubleshooting skills.
6. Strong communication and collaboration skills.
7. Ability to work independently and meet project deadlines.