I have a very urgent DIRECT CLIENT requirement for *ETL Developer* in
*Columbia,
SC*. Please Let Me Know If you have available candidate, please reply with
their word resume, location, rate and contact number.
Please send the resumes at pe...@cncconsulting.com
Job Title: ETL Developer
Location: Columbia, SC
Duration: 7 Months
The South Carolina Department of Revenue (SCDOR) has implemented a Data
Warehouse and related software components for purposes of tax and revenue
compliance and analysis. The Data Warehouse also serves as a primary data
source for other business intelligence activities. This work involves
proprietary software from Revenue Solutions Inc. (RSI), particularly their
Portfolio Warehouse (PW) product.
Historically, the Data Warehouse application team has used the proprietary
Embarcadero DT/Studio tool, along with custom transform code from RSI, to
load data from federal and state data sources into the Data Warehouse. The
team is now charged with converting all of the data load processes to use
Microsoft SQL Server Integration Services (SSIS) At this time an
experienced ETL (Extract, Translate, and Load) specialist with expertise in
SSIS is needed to assist in this process.
Specific Duties and Responsibilities:
The following application tasks are expected to be executed by the Data
Warehouse systems software developer ETL specialist. 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 SCDOR IRM organization.
Responsible for building ETLs using SSIS packages to load data from various
data sources including files from internal and external data sources.
Setting up and running the proprietary Portfolio Warehouse Associate and
Grow (A&G) offline process for data cleansing and matching of these files.
This includes configuring the A&G match keys with consultation from the
business users and SCDOR Data Warehouse team.
Conduct quality assurance for loaded data.
Creating and executing “views” as required by business users.
Performing database utility functions, such as SQL Server Analytical
Services for OLAP, development of stored procedure, SSIS, etc. as needed
for loading and analysis of data.
Administrative Verbal Communication Skills Yes 1
Expert
Administrative Written Communication Skills Yes 1
Expert
Database Platforms Extract Yes 1
Database Platforms Load (ETL) tools Yes 1
Expert
Database Platforms MS SQL Server 2012 Yes 1
Expert
Database Platforms Relational Database Experience Yes
1 Lead
Database Platforms SQL Server Integration Services (SSIS) Yes
1 Lead
Database Platforms Transform Yes 1
Database Platforms Team Foundation Server (TFS) 2012 No
1
Development Tools T/SQL Queries Yes 1
Miscellaneous ETL Process and Development Yes 1
Advanced
Miscellaneous Requirements Gathering Yes 1
Miscellaneous Teamwork Yes 1 Expert
Operating Systems/APIs Windows 7 Yes 1
Operating Systems/APIs Windows Server 2012 Yes 1
Program Management deployment methodology concepts including design, build,
testing, and deployment Yes 1
Program Management - RUP methodology PLC - Project Life Cycle
Methodology Yes 1
Programming Languages C# Yes 1
Advanced
Programming Languages Java Yes 1
Intermediate
Quality Assurance (QA) Testing skills Yes 1
Expert
Specialties Data Warehousing Yes 1
Advanced
Specialties Datamart Yes 1
Thanks
Peter Smith
Direct: 224-764-8535
Email ID: pe...@cncconsulting.com
--
You received this message because you are subscribed to the Google Groups "SAP
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.
