Need Senior SSIS Developer-- Prefer EAD/GC/US Citizens

Hello,

 

We have an urgent requirement for Senior SSIS Developer with our direct Client in Olympia,WA

 

Location: Olympia,WA

Duration: 1 year

 

Minimum 10 years exp. required.

Project Start Date is first week of April, 2012

 

SSIS Developer

 

MS SQL Server 2005/08

SQL Server Integrated Services (SSIS) Expert 2005/08

Visual Basic

VB Script

SQL/Transact SQL

OLE/DB

ODBC

Knowledge of Loading Kimball Fact Dimensional schemas

Knowledge of Loading Relational schemas

Data Warehouse DBA expert

Partitioning tables, cluster indexing

DB/Table/Index Performance Tuning

Create, maintain, multiple DBs and Tables, stored procedures, triggers, security schemas and roles, macros, views

SQL Server Integrated Services (SSIS) expert

Full & Incremental Fact Dimension ETL SSIS package development

Slowing changing dimensions of Type 1, 2 and 3

Creating and processing Surrogate Keys

Degenerate Dimensions

Aggregate tables

Data profiling

Full and Incremental loads

De-duplication of records

Transforming Data

Performance tuning of SSIS packages

Robust SSIS packages with row counts, verifications, notifications, security, runs on test and production servers, ftp, file compression, indexing, constraints

Drop tables, truncate tables, create and modify tables within SSIS package

SSIS packages executes Script Tasks using vb.net and stored procedures

Experience scheduling and deploying using package configuration

Experience documenting unique features of SSIS packages, DB maintenance, programs, and systems

Power Designer or Case tool

BrioQuery, Hyperion, Business Objects, Excel or MS Access

Experience in Knowledge transfer

Workers Compensation Processing experience

ADABAS Natural

ADBAS Event Replicator

 

 

Thank you very much.

Harry Arora

International Projects Consultancy Services, Inc. (IPCS) ...Delivering Business Value from Information Technology...
Interchange Tower, Suite 1595, 600 South Highway 169, Minneapolis, MN 55426
Tel: 925-353-3884
Fax: 952-541-1222
Harry@ipcs.net
www.ipcs.net
· Our Specialization: SOA I Microsoft .NET Technologies I Data Warehouse & Business Intelligence I Network Security I ERP & SAP Implementation
· Technologies: Business Process Rules Management (BPRM) driven Next Generation, Smart and Innovative Service Delivery Platforms
· IPCS is SBA 8(a) Certified /WBE/MBE/DBE/SDB Company
· IPCS is Certified Minority Company by Midwest Minority Supplier Diversity Council -MMSDC
· IPCS is on Federal GWAC 8a STARS -2 Contract

 

 

You are currently subscribed to arora as: shekhar.altus.jobs@blogger.com Add harry@ipcs.net to your email address book to ensure delivery Forward to a Friend  |  Manage Subscription  |   Subscribe  |   Unsubscribe