Role & responsibilities
Advanced ETL Design and Development:
Proficient in designing, developing, and optimizing complex ETL processes using SSIS, including handling large volumes of data, error handling, and performance tuning.
SQL Server Expertise:
Deep knowledge of T-SQL, stored procedures, functions, and database objects, enabling efficient data manipulation, transformation, and integration.
Troubleshooting and Performance Tuning:
Ability to diagnose and resolve complex data integration issues, optimize package execution, and implement best practices for robust, maintainable solutions.
Change Management tools:
Understanding of code-based versioning and transformation tools like dbt or Liquibase
Operational support:
Implement best practices for SSIS development, deployment, and source control. Provide technical support and resolve production issues related to SSIS packages and data integration processes.