SSIS Development Skills
10+ years IT industry experience (total)
at least two (2) complex data warehousing solution using the Ralph Kimball methodology and 4 years of Data Integration and Warehousing experience
Data Analysis and modeling, including Kimball dimensional modeling experience
All SSIS ETL Staff must have the following:
1 project, and 1 year of Data Integration and Warehousing experience
Ralph Kimball DW experience
MS SQL Server 2005/2008
SQL Server Integrated Services (SSIS) Expert 2005/2008
Visual Basic
VB Script
SQL/Transact SQL
Knowledge of Loading Kimball Fact and Dimension schemas
Knowledge of Loading 3rd normal form Relational schemas
Data Warehouse DBA expertise:
o Partitioning tables, cluster indexing
o DB/Table/Index Performance Tuning
o Create, maintain, multiple DBs and Tables, stored procedures, triggers, security schemas and roles, macros, views
SQL Server Integrated Services (SSIS) expert:
o Full & Incremental Fact Dimension ETL SSIS package development
o Slowing changing dimensions of Type 1, 2 & 3
o Creating and processing Surrogate Keys
o Creating and processing junk dimensions, bridge tables, and degenerate dimensions
o Aggregate tables
o Data profiling
o Full and Incremental loads
o De-duplication of records
o Transforming Data
o Performance tuning of SSIS packages
o Robust SSIS packages with row counts, verifications, notifications, security, runs on test and production servers, ftp, file compression, indexing, constraints,
o Drop tables, truncate tables, create and modify tables within SSIS package
o SSIS packages executes Script Tasks using Vb.net, and stored procedures
Experience scheduling and deploying SSIS packages by using package configuration as part of an overall ETL framework
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
The following skills are desired:
Visual Studio .Net
ADABAS
Natural
ADABAS Event Replicator
Experience with Workers Compensation or Medical Insurance Processes
Thank you very much.
Harry Arora
Director-HR & Resource Management
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 |
No comments:
Post a Comment