SSIS Data Transformation Project
Budget: $10 – $30 USD
I need professional assistance in developing a SSIS package focused on transforming data.
Requirement:
- Proficiency in SSIS and ETL processes
- DIMENSIONAL MODEL USING DATA FLOW
Expert in:
SQL Server Integration Services (SSIS):
Proficiency in designing, developing, and deploying SSIS packages.
Experience with SSIS transformations (Aggregate, Conditional Split, Derived Column, Lookup, Merge, Merge Join, Multicast, Pivot, Row Count, Sort, Union All).
Knowledge of SSIS event handlers and how to configure them (OnPreExecute, OnPostExecute, OnError).
SQL Server and T-SQL:
Strong knowledge of SQL Server, including creating and managing databases, tables, views, and stored procedures.
Expertise in writing complex T-SQL queries and optimizing them for performance.
Data Warehousing Concepts:
Understanding of dimensional modeling and star schema design.
Familiarity with fact and dimension tables, and how to integrate them into a data warehouse.
ETL Processes:
Experience in extracting, transforming, and loading data from various sources into a data warehouse.
Ability to handle large datasets and ensure data quality and consistency during the ETL process.
Experience in working with external data sources, such as CSV files, and integrating them into existing data models.
Knowledge of handling different data formats and ensuring accurate data transformation and loading.
It should be simple task if you are expert in the points I mentioned.
Requirement:
- Proficiency in SSIS and ETL processes
- DIMENSIONAL MODEL USING DATA FLOW
Expert in:
SQL Server Integration Services (SSIS):
Proficiency in designing, developing, and deploying SSIS packages.
Experience with SSIS transformations (Aggregate, Conditional Split, Derived Column, Lookup, Merge, Merge Join, Multicast, Pivot, Row Count, Sort, Union All).
Knowledge of SSIS event handlers and how to configure them (OnPreExecute, OnPostExecute, OnError).
SQL Server and T-SQL:
Strong knowledge of SQL Server, including creating and managing databases, tables, views, and stored procedures.
Expertise in writing complex T-SQL queries and optimizing them for performance.
Data Warehousing Concepts:
Understanding of dimensional modeling and star schema design.
Familiarity with fact and dimension tables, and how to integrate them into a data warehouse.
ETL Processes:
Experience in extracting, transforming, and loading data from various sources into a data warehouse.
Ability to handle large datasets and ensure data quality and consistency during the ETL process.
Experience in working with external data sources, such as CSV files, and integrating them into existing data models.
Knowledge of handling different data formats and ensuring accurate data transformation and loading.
It should be simple task if you are expert in the points I mentioned.