Designing, developing, and maintaining SQL Server Integration Services (SSIS) packages and ETL (Extract, Transform, Load) processes to integrate data from various sources into a data warehouse or other destinations. Key responsibilities include building complex data transformations, optimizing package performance, implementing error handling, and supporting data warehousing initiatives.
Core responsibilities
• Design and Develop ETL: Create and maintain SSIS packages to extract, transform, and load data from different sources into target databases.
• Performance Tuning: Optimize the performance of SSIS packages and underlying SQL queries through indexing and other tuning techniques.
• Data Integration: Integrate data from disparate systems, perform data cleaning, and ensure data accuracy and integrity.
• Error Handling and Logging: Implement robust error handling, logging, and event handlers to monitor package execution.
• Database Development: Develop and maintain database objects like stored procedures, functions, and tables using T-SQL.
• Documentation: Create and maintain documentation for data flows, mappings, processes, and solutions.
• Testing and Deployment: Perform unit and system testing and prepare ETL processes for deployment to production environments.
• Troubleshooting: Troubleshoot and resolve technical issues related to SSIS and other data integration processes.
Required skills and qualifications
• Experience with SSIS and SQL Server, including T-SQL.
• Knowledge of data warehousing concepts, data modeling, and ETL best practices.
• Proficiency in data integration, transformation, and loading processes.
• Strong analytical and problem-solving skills.
Responsibilities
Designing, developing, and maintaining SQL Server Integration Services (SSIS) packages and ETL (Extract, Transform, Load) processes to integrate data from various sources into a data warehouse or other destinations. Key responsibilities include building complex data transformations, optimizing package performance, implementing error handling, and supporting data warehousing initiatives.
Core responsibilities
• Design and Develop ETL: Create and maintain SSIS packages to extract, transform, and load data from different sources into target databases.
• Performance Tuning: Optimize the performance of SSIS packages and underlying SQL queries through indexing and other tuning techniques.
• Data Integration: Integrate data from disparate systems, perform data cleaning, and ensure data accuracy and integrity.
• Error Handling and Logging: Implement robust error handling, logging, and event handlers to monitor package execution.
• Database Development: Develop and maintain database objects like stored procedures, functions, and tables using T-SQL.
• Documentation: Create and maintain documentation for data flows, mappings, processes, and solutions.
• Testing and Deployment: Perform unit and system testing and prepare ETL processes for deployment to production environments.
• Troubleshooting: Troubleshoot and resolve technical issues related to SSIS and other data integration processes.
Required skills and qualifications
• Experience with SSIS and SQL Server, including T-SQL.
• Knowledge of data warehousing concepts, data modeling, and ETL best practices.
• Proficiency in data integration, transformation, and loading processes.
• Strong analytical and problem-solving skills.
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role :MySQL~SQL Server 2012 Integration Services (SSIS)
