SSIS/SQL Developer

We are seeking a highly skilled SSIS/SQL Developer to join our dynamic and innovative team. As an SSIS/SQL Developer, you will be responsible for designing, developing, and maintaining efficient database load and update processes using Microsoft SQL Server Integration Services (SSIS) and other related technologies. Your expertise in SSIS and SQL programming, particularly with large data sets, will be crucial in developing our data integration packages, ensuring data accuracy, and supporting various data-driven initiatives within our organization.

SSIS/SQL Developer Responsibilities and Duties

• Design, develop, and maintain SQL Server Integration Services (SSIS) packages to efficiently load large, consolidated data sets.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications for data integration and SSIS solutions.
• Create and optimize complex SQL queries, stored procedures, and functions where necessary to support SSIS package operation/performance.
• Perform data profiling and analysis to identify data quality issues and propose appropriate solutions.
• Implement data cleansing, transformation, and validation rules to ensure the accuracy and consistency of data.
• Collaborate with database administrators and data architects to align processes with the company’s data processing frameworks and database standards.
• Develop and maintain documentation, including data flow diagrams, data dictionaries, and technical specifications.
• Monitor and optimize the performance of SSIS processes to ensure efficient data processing and system reliability.
• Troubleshoot and resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks.
• Stay up to date with industry trends and best practices in SSIS, SQL development, and data integration technologies.