I will do perfect etl using ssis package,data automation, other related work

do perfect etl using ssis package,data automation, other related work
do perfect etl using ssis package,data automation, other related work
do perfect etl using ssis package,data automation, other related work
do perfect etl using ssis package,data automation, other related work
do perfect etl using ssis package,data automation, other related work
do perfect etl using ssis package,data automation, other related work

About This Gig

1)Designing & creating SSIS packages to load data into DW using various SSIS tasks like execute SQL task, bulk insert task, data flow task, file system task, send mail task, active script task
2) Designing, creating and deployed SSIS packages to export/ import data from csv files, text files, excel files.
3) Using SSIS to implement slowly changing transformation, to maintain changing and historical data in DW.
4) Using various SSIS tasks such as conditional split, derived column and data validation tasks, checks during staging, before loading the data into the DW.
5) Involving in enhancing and deploying the SSIS packages from development server to production server.
6)Write stored procedures, user defined functions, views, T-SQL scripting for complex business logics.
7) Extensively used joins and sub-queries for complex queries involving multiple tables from different databases
8) Optimizing the database by creating various clustered, non-clustered indexes and indexed views.
9) Scheduling SSIS jobs; packages setting up database mail for SQL server for any job failures.
10) Developing, testing and implementing referential integrity rules and regulations through constraints, views 

Order Details

ETL Data Automation

Extraction Transformation Loading SSIS Packages Data Automation Data Flows Control Flow Tasks

  • Setup Admin Panel
  • Permissions
  • Schema Diagram
  • 100 Tables Added
  • Import/Export Data
1 day delivery