Data Warehouse/ETL Developer - Columbia, SC - 4+ Months - Direct Clien

JOB TITLE: DATA WAREHOUSE/ETL DEVELOPER

DURATION: 4MONTHS +

LOCATION: COLUMBIA, SC

SPECIFIC DUTIES AND RESPONSIBILITIES:

The following application tasks are expected to be executed by the Data Warehouse systems/application analyst.

All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and User Acceptance testing.

These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the organization.

Analyzing and planning tasks for load of multiple years of clients extract files.

Preparing and loading of extract data into the Data Warehouse using the Embarcadero DT Studio Extract, Transform, and Load (ETL) tools.

Setting up and running the Portfolio Warehouse Associate and Grow offline process for data cleansing and matching. This includes configuring the A&G match keys.

Resolving issues resulting from the Portfolio Warehouse Associate and Grow offline process for data cleansing and matching. This includes analysis of error and Research Queue patterns, refining the match keys as needed to resolve as needed.

SKILLS REQUIRED:

Data Warehousing

MS SQL Server 2005

Relational Database Experience

Portfoliio Warehouse

MS SQL Server 2008 R2

SQL

Develop and Test Code

ETL Process and Development

Teamwork

Programming Languages

TRANSACT-SQL

Thanks & Regards

Mohankumar

Technical Recruiter

Software Specialists, Inc.