Technical Skill set :

Lead SE with SSIS (SQL Server Integration Services) knowledge is primarily responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) workflows and data integration processes to support enterprise data solutions.

SSIS :

- Design, develop, test, deploy, and maintain SSIS packages for data migration, ETL processes, reporting and to integrate data between various systems.

- Develop complex SQL queries to extract data from various sources such as Oracle or SQL databases.

- Troubleshoot issues related to package execution failures and optimize performance of existing packages.

- Collaborate with stakeholders to understand business requirements and design solutions using SQL Server Integration Services (SSIS).

- Design and implement complex SSIS packages for extracting, transforming, and loading data from various sources such as relational databases (SQL Server, Oracle, DB2), flat files, and XML files.

- Develop ETL best practices, including error handling, logging, checkpoints, and data quality assurance.

- Write efficient SQL queries, stored procedures, functions, and triggers to support ETL processes.

- Optimize SSIS packages and SQL queries for maximum performance using techniques such as parallelization, lookup caching, and bulk loading.

- Create and maintain design documentation such as data models, mapping documents, data flow diagrams, and architecture diagrams.

Additional skills :

- Work closely with the team to ensure timely delivery of projects.

- Optimize existing integrations for improved performance and scalability.

- Troubleshoot, debug, and test SSIS packages and backend database processes to ensure data accuracy and system reliability.

- Participate in resource planning, task estimation, and code review processes.

- Maintain database artifacts and provide subject matter expertise for database best practices in reporting and BI environments.

- Support and enhance existing data warehouse and ETL solutions, including performing routine database administration tasks.