Technical Lead-Data Engg

Area(s) of responsibility

SSIS and Matillion:

SSIS:

An MS SSIS (Microsoft SQL Server Integration Services) Developer is responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) processes within the Microsoft SQL Server environment. SSIS is a powerful tool used for data integration and workflow applications. Here are the common roles and responsibilities associated with the position of an MS SSIS Developer:

1. **Requirement Analysis:**

   - Collaborate with business analysts and stakeholders to understand data integration requirements.

   - Analyze source and target systems to determine data transformation needs.

2. **ETL Design and Development:**

   - Design and develop ETL processes using SSIS to extract, transform, and load data from source systems to target databases.

   - Create and optimize data mappings, transformations, and workflows.

Matillion:

• Design, develop, and maintain ETL processes using Matillion to extract, transform, and load data into Snowflake and Develop and Debug ETL programs primarily using Matillion Cloud.
• Collaborate with data architects and business stakeholders to understand data requirements and translate them into technical solutions.