SSIS Data Transformation Project

$10-30 USD

Kapalı

İlan edilme:

8 ay önce

$10-30 USD

Teslimde ödenir

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.

SQL

Microsoft SQL Server

Oracle

Database Administration

Database Development

Proje No: 38169528

Proje hakkında

12 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 6 ay önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

12 freelancer bu proje için ortalama $26 USD teklif veriyor

@noureen23

Having extensive experience in database design and development, particularly with SQL Server Integration Services (SSIS), I am well-versed in the intricacies of transforming data. This includes proficiency in handling large datasets, creating complex T-SQL queries and optimizing their performance, and working within dimensional modeling and star schema designs which aligns perfectly with your project requirements. Transformation project would not only be completed efficiently but also tailored for the maximum value extraction from your data. Let's collaborate to unlock the true potential of your data! Regards, Saima

$30 USD 7 gün içinde

5,0

(28 değerlendirme)

5,1

@Vickybobo

Hello, I hope you are doing well. I am an experienced data engineer/ database administrator/ data analyst using ETL Tools (SSIS, Azure Data Factory)/ SQL Server/ Reporting Tools (SSRS, Jasper Report, Power BI) for more than 10 years. I have read your project description and I am very interested in your project. I can help you with your SSIS data transformation project as your requirement. I can start right now and will provide you the top quality work for sure. Please contact me to discuss more about the detail. Regards,

$50 USD 7 gün içinde

5,0

(32 değerlendirme)

4,4

@sreenivas2903

Hello I am expertise in sql server and ssis . I can do from optimisation to migration . Ping me if u are interested

$20 USD 7 gün içinde

4,9

(21 değerlendirme)

4,5

@wasifmuneer

Hello, Can we discuss the project details over chat? I am MS full stack developer having expertise in developing web, desktop application and I think I can manage this project well. I do have working experience on creating SSIS packages and transforming data using Script transform and save back to targeted database. I can share my project examples with you. Hope to hear from you soon. Thanks

$30 USD 1 gün içinde

5,0

(6 değerlendirme)

3,9

@sridharprof

Hello, I have 15 years of experience in SQL server database development and business intelligence projects. I have handled large size databases. I am looking forward to work with you. Thank you!

$20 USD 7 gün içinde

5,0

(1 değerlendirme)

1,2

@imandaneshi1

Hello, I can assist you in developing an SSIS package focused on transforming data according to your specified requirements. I have extensive experience with SSIS transformations such as Aggregate, Conditional Split, Derived Column, and more, ensuring robust package execution. My strong expertise in SQL Server and T-SQL allows me to create and manage databases, tables, and stored procedures efficiently. Additionally, I have a deep understanding of dimensional modeling and star schema design, which will help in creating a scalable data warehouse. I am also experienced in handling large datasets and ensuring data quality during the ETL process. Best Regards, Iman D.

$30 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@willianadao

Today I find myself in the best phase of my professional journey. I started working as a PHP, C, C# and C++ programmer, but my vocation was for data. I made my way to work with data, and I have been working in the area for 12 years. I honed my knowledge in data engineering, databases and data analysis, delving deeper into delivering the best experience for the user.

$20 USD 10 gün içinde

0,0

(0 değerlendirme)

0,0

@rohan0747

My proposal leverages extensive data analyst experience to develop a robust SSIS solution tailored to your needs. I will design and implement interactive dashboards and reports that provide actionable insights. My approach includes thorough data integration, ensuring clean and accurate data sources. I will create customized visualizations to enhance decision-making processes. With proficiency in SSIS and a deep understanding of data analysis, I aim to empower your team with intuitive tools for real-time analytics and strategic planning. This solution will optimize your data's value, driving efficiency and informed business decisions.

$20 USD 7 gün içinde

0,0

(0 değerlendirme)

0,0

@khashansalem4

Hi, I am writing to express my interest in the SSIS Data Transformation Project. With a strong background in data integration, transformation, and management, coupled with my hands-on experience with SQL Server Integration Services (SSIS), I am excited about the possibility of contributing to your project. In my previous role at Alpha Bank, I successfully led multiple data transformation projects that involved complex ETL processes. My responsibilities included designing and developing SSIS packages to extract, transform, and load data from various sources into data warehouses. I was also responsible for performance tuning, error handling, and ensuring data quality and integrity throughout the ETL process. Looking forward hearing from you. Thank you, Salem

$25 USD 7 gün içinde

0,0

(0 değerlendirme)

0,0

@KarthikDataArch

Hi, I have extensive experience in many ETL tools such as ADF, DataIKU, ZAPBI and IICS, primarily into SSIS. I have worked in lot of data transformation projects, along with SQL scripts and Data warehousing. I have created lot of SSIS packages with many control flow tasks and data flow tasks to do the ETL activity with error handling and logging. Regarding our project - Hope the SSIS package should read data from csv files and load them into existing Microsoft SQL Server tables after transforming the data. Let's discuss more to get the details. Regards, Karthik K 91-9677151167

$25 USD 2 gün içinde

0,0

(0 değerlendirme)

0,0

@hari413

I have over all 8 years of experience in working on ETL developement, creating SSIS packages by extensively using various transformation and optimizing the solutions.

$20 USD 7 gün içinde

0,0

(0 değerlendirme)

0,0

@soroosh

I'm an SSIS ninja, crafting high-performance data transformations with ease. My expertise in SSIS, dimensional modeling, and T-SQL makes me the perfect fit for your project. I'll design an SSIS package that seamlessly transforms your data, leveraging all requested components (Aggregate, Derived Column, etc.) and ensuring data quality & consistency. Let's unlock the power of your data together!

$19 USD 7 gün içinde