Data warehouse consultant with ETL, SQL Server, SQL, Reporting/OLAP, RSI Portfolio Warehouse, Embarcadero DT Studio and tax/finance/government experience

IN4494-1

Data warehouse consultant with ETL, SQL Server, SQL, Reporting/OLAP, RSI Portfolio Warehouse, Embarcadero DT Studio and tax/finance/government experience

Location:Columbia, SC 

Duration: 3 months

Positions: 1

Responsibilities and Duties:

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 SCDOR IRM organization. 

•Work with SCDOR Operations & Support team to set up the new “Model Office/User Acceptance Test” environment, including virtual machines (servers) and databases.

•Install the PW software in successive environments, from “Sandbox” to “Development” to “Model Office/User Acceptance Test.”

•Apply release upgrades in all environments as they become available.

•Coordinate testing efforts in all environments; log defects and track until resolved. Create work items for other Data Warehouse team members as appropriate.

•Testing must include, at minimum:

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

.Setting up and running the PW Associate and Grow (A&G) offline process for data cleansing and matching. 

.Development of tax calculations via the PW “Tax Calc” component. 

.Creating and executing “views” to be utilized by the PW audit selection process. 

.Testing all application level configurations and parameters for the PW product. In addition to items listed above, these include various system reference codes, workflow rules, scoring parameters, correspondence templates, as well as configuration of various 3rd party products such as Group 1, SSA, and DT Studio.

.Testing of PW offline processes. These include primary indicator, legacy system gateway, nightly data refresh process, and collections scoring. 

•Work with senior RSI onsite support and the RSI Solutions Center to diagnose and resolve issues, and to apply patches and hot fixes as needed.

•Prepare final package of software and data for migration to Production environment.

•Ensure that all installation tasks, test results, and component configurations are fully documented.

Skills:-

Verbal Communication Skills

Written Communication Skills

Relational Database Experience

SQL Server

SQL

Analytical Skills

Detail oriented

Development processes

Teamwork

Java

Application Development

Data Warehousing

Implementation

OLAP

Reporting/OLAP/DW

Additional Skills:

Revenue Solutions, Inc, Portfolio Warehouse 3.1

Embarcadero DT Studio

Posted via email from innoSoul's posterous