Find Jobs
Hire Freelancers

SSIS Package Slow changing dimensions SQL Data Warehouse

$10-30 USD

Closed
Posted over 4 years ago

$10-30 USD

Paid on delivery
I have a exercise with files for ssis and sql data warehouse. Example: Files coming to me every hour , file contain two columns: ItemId,QTY I would like to see example of SSIS package for slow changing dimension type 2 package which will get the source csv files and load them to destination table by using staging table. In destination table I need to see the data in format which allows me to track stock qty changes over time.
Project ID: 22150076

About the project

14 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

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
14 freelancers are bidding on average $36 USD for this job
User Avatar
Hello! I am a Computer Engineer, with an MCSA SQL Server 2014, with 14 years of experience as a BI/SQL developer. I've worked on many data warehousing projects before. I am a near-native English speaker, currently available, and results-oriented. I can work on your requirement ASAP. I have all the software required installed on my premises. You can contact me over chat to talk. Thanks!
$50 USD in 2 days
4.9 (25 reviews)
6.0
6.0
User Avatar
Respected Sir, Greetings of the Day ! I am Udal Bharti. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database development & management and i am expert in writing complex queries, stored procedure, User Defined Functions. My Skills ------------------- 1. Extensive Experience in writing complex queries 2. Expert in Writing Stored Procedures, Triggers, User Defined Fucntions 3. Expert in Creating and managing Jobs 4. Expert in SSRS If I can provide you with any further information on our background and qualifications ,Please let me know. I look forward to hearing from you , Thank you for your consideration. Regards Udal
$30 USD in 7 days
4.9 (11 reviews)
5.5
5.5
User Avatar
I have deep and proven experience in T-SQL and SSIS development. My expertise in implementation, troubleshooting and tuning of complex queries and SSIS packages is on highest level. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
$45 USD in 2 days
5.0 (53 reviews)
5.3
5.3
User Avatar
Proposal - You can expect any kind of work on SQL/SSIS/SSRS from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$100 USD in 2 days
5.0 (31 reviews)
5.0
5.0
User Avatar
Hi I am expertise in etl processing using ssis and also expertise in sql querying . if you would like to share the info , ping me . i won't take much time to complete this task. ping me if you are interested
$50 USD in 2 days
4.9 (21 reviews)
4.6
4.6
User Avatar
Please message me to start your work. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.11 years experience in MS SQL Server and 7.3 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd
$30 USD in 1 day
5.0 (25 reviews)
4.2
4.2
User Avatar
Hello I can help you with this project I have the experience in SSIS to complete at all Contact me to discuss details Thank you
$25 USD in 1 day
5.0 (1 review)
3.1
3.1
User Avatar
• 11+ years of experience as a BI Professional with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects. • Experience in developing, implementing, documenting, monitoring and maintaining the data warehouse extracts, transformations and ETL process in various industries Insurance , Pharmaceutical, Casino and Gaming, Utility, Finance and Telecommunications. • Proven ability to successfully analyze business processes and data to develop valuable solutions for optimal business decision-making • Experience with all phases of software development life cycle (SDLC) and Agile methodologies • Have delivered as a team member, team lead and as an independent consultant on medium to large scale projects. • Involved in User Acceptance Testing also involved in various other test efforts in a data warehouse environment like data validation, functional testing, integration testing and system testing. • Experienced in leading the Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations and time zones.
$30 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with SSIS and Data Warehouse ETL for more than 11 years with the last 4, serving as a lead architect. I will give you the SSIS package within 2 days.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I did so many projects on datawarehouse particular in ssis
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have very good experience(more than 6 years) with SSIS, SQL SERVER working in lot of domains. I can complete your work in 3 days.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lots of experience with the SSIS package with a slowly changing dimension and also sourcing data from CSV and other file types. It takes me to complete the job in a few hours.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good knowledge in ssis and according to the project requirement I am familier with scd properties. This is my first bid so I will try my best . I am logically very strong means that why I am using scd and what is the other option of scd due to increase the performance of etl.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Seasoned MSBI Developer with 6 years of experience in IT Industry in Data Warehousing (DW) and Business Intelligence (BI) using Microsoft Business Intelligence tools SSIS, SSAS, SSRS, SQL Server and Power BI with Snowflake & Star Schemas. Expertise in exporting data from OLTP to OLAP systems with the help of Incremental loading/Full Loading and developing/deploying ETL packages in production.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Birmingham, United Kingdom
4.9
35
Payment method verified
Member since May 2, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.