SSIS/SQL Developer with Strong SAS Migration
Apply NowCompany: Cloud BC Labs
Location: Virginia Beach, VA 23464
Description:
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 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.
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 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.