SSIS Unit Testing for data flow

₹600-1500 INR

Closed

Posted

3 months ago

₹600-1500 INR

Paid on delivery

I'm looking for a professional to create a Unit Test project for my SSIS packages in Visual Studio 2022. The testing framework we will be using is xUnit. A Brief Background: An ETL Project has been created to extract, transform, and load. However, I am looking to create a Unit test to identify if ETL package is moving data as expected. Type of Testing required 1. Data reconciliation 2. Data Integrity 3. Data Transformation 4. Source to Target counts Key aspects of the project: - The focus of the unit tests will be on the Data Flow component of SSIS. - Specific attention will be given to the Transformations and Data Destinations within the Data Flow. - The transformations that need to be tested include Lookup Transformation, Aggregate Transformation, Data Conversion Transformation, Data Integrity, and Data Reconciliation. The ideal freelancer for this project will have: - Extensive experience with SSIS and unit testing. - High proficiency in Visual Studio 2022, MS SQL Server 2022, C#, and xUnit. - Ability to discuss and clarify project requirements personally. I'm open to discussing any further information that may be necessary to successfully complete this project.

SSIS (SQL Server Integration Services)

Microsoft SQL Server

C# Programming

.NET

Project ID: 38684179

About the project

4 proposals

Remote project

Active 2 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹1,050 INR for this job

@jitendra2013

Hi, I hope you're doing well. I’m excited to apply for your project to create a Unit Test framework for your SSIS packages in Visual Studio 2022 using xUnit. With extensive experience in SSIS, ETL processes, and unit testing, I am confident in my ability to deliver accurate and robust tests for your data flow components. Here’s how I can help: Data Reconciliation & Integrity: I will create tests to verify that the ETL package moves data correctly, ensuring that no data is lost or corrupted during the process. Data Transformation Testing: I’ll implement tests to confirm that transformations, such as Lookup, Aggregate, and Data Conversion, are functioning as expected. Source-to-Target Counts: I will set up checks to ensure that the data flow matches source and target counts, providing reliable validation. My proficiency in Visual Studio 2022, SQL Server 2022, C#, and xUnit will ensure thorough and well-executed tests. I’m also open to discussing any additional requirements to ensure the testing framework meets your exact needs. Looking forward to the opportunity to collaborate with you and help optimize your ETL processes. Thanks

₹1,050 INR in 7 days

5.0

(10 reviews)

3.5

@JerryPrograms

Dear sir I am eager to assist you in creating a Unit Test project for your SSIS packages in Visual Studio 2022 using xUnit. The focus will be on validating the following aspects of your ETL processes: Data Reconciliation Data Integrity Data Transformation Source to Target Counts Key Features: Thorough testing of the Data Flow component, specifically transformations like Lookup, Aggregate, and Data Conversion. Extensive experience with SSIS, unit testing, Visual Studio 2022, MS SQL Server 2022, C#, and xUnit. I am open to discussing further details to ensure project success. Thank you for considering my proposal! Best, Zain Aftab

₹1,050 INR in 7 days

5.0

(1 review)

1.8

@jinayfreelance

Having brilliant experience in SQL Server SSIS Creation as well as refactoring. Working as teach lead in previous organization for managing SSIS to transfer data from Database to Database by adding validating data.

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@LeoRomo

As an SQL Developer, I’m are responsible, and maintaining databases using the SQL programming language. You work with database management systems (DBMS) to store, retrieve, and manipulate data. I’m writing complex SQL queries to extract and analyze data, optimizing database performance, and ensuring data integrity and security. I’m also collaborate with developers, data analysts, and other stakeholders to understand their data needs and provide solutions. Additionally, I stay up-to-date with the latest database technologies and best practices to continuously improve the efficiency and reliability of the databases I manage.

₹1,050 INR in 7 days