TSQL ETL Developer Requirements Gathering Windows 2008 R2 Windows 7 Data Warehousi   Requirement id 17149 Job title Developer Job location in Columbia, SC Skills required MS SQL Server 2005, Relational Database, SQL, TSQL ETL Developer Requirements Gatherin Open Date 27-Jan-2014 Close Date Job type Not specified Duration 5 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: MS SQL Server 2005, Relational Database, SQL, TSQL ETL Developer Requirements Gatherin Description: • Serve as project technical lead for development and implementation of tax compliance programs, including those based on IRS extract files. • Development of tax calculations via the PW “Tax Calc” component. There is a user interface that supports creation of the tax calc routines, however, complex calculations may require the development of external Java objects that are called by the tax calc process. • Creating and executing “views” to be utilized by the PW audit selection process. • Maintaining all application level configurations and parameters for the PW compliance programs. In addition to items listed above, these include various system reference codes, workflow rules, scoring parameters, correspondence templates. • Monitoring of PW offline processes. These include primary indicator, legacy system gateway, nightly data refresh process, and collections scoring. • Train less experienced SCDOR Data Warehouse staff, especially full-time SCDOR employees, in the development and implementation of tax compliance programs. • Performing ad hoc queries using T/SQL and stored procedures for data maintenance Lower priority: • 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. This includes configuring the A&G match keys. • Supporting installation of new PW, WinDRS, and TaxMaster releases • Maintaining custom offline routines such as legacy system Gateway, Primary Indicator, etc based on business rule changes • Performing database utility functions, such as SQL Server Analytical Services for OLAP , DTS, SSIS, etc for loading and analysis of data. Required Skills: * Interpersonal Skills * Problem Solving Skills * Verbal Communication Skills * Written Communication Skills * MS SQL Server 2005 * Relational Database Experience * SQL * T/SQL Queries * Analytical Skills * Customer Focused * ETL Process and Development * Requirements Gathering * Windows 2008R2 * Windows 7 * Data Warehousing Desired Skills: * MS SQL Server 2008 R2 * Revenue Solutions, Inc. - Portfoliio Warehouse * SQL Server Integration Services (SSIS) * MS Excel * Business Intelligence (BI) * Teamwork * Eclipse * Java * Java JDK 1.6 - 1.7 level * Visual Studio * Application Development * OLAP * Reporting/OLAP/DW   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 17149 while calling.   Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2), MS SQL Server 2005 job openings in Columbia, SC Jobs List .Net Developer - 6129-1 Create date: 23-Jul-2015 Description: Position for .net developer to assist with 4th generation assessment tool for JJMS. Please see SOW for details. Responsible for the analysis, development, modification, installation, testing and maintenance of operating systems software. Possesses a strong understanding of systems programming, graphical.... (This job is for - ASPNet Jobs in SC Columbia Developer - (in Columbia, SC)) System Software Programmer -6039-1 Create date: 30-Apr-2015 Description: Works under the system manager to design and develop web applications using the .net development platform analyze user needs, as required, and leads in the design of specifications to meet those needs develops web applications to meet use requirements tests and debugs software. Applications would mainly include job Jobs in SC Columbia Developer - (in Columbia, SC)) Database Administrator-5399-1 Create date: 24-Feb-2014 Description: Candidates must be experienced developers having performed data conversion on multiple projects during their employment history. The SQL Developer will be responsible for developing applications and integrations using the Microsoft SQL Server platform. This will include reports, vendor exports, data warehousin.... (This job is for - job Jobs in SC Columbia Administrator - (in Columbia, SC))         (Developer: MS SQL Server 2005, Relational Database, SQL, TSQL ETL Developer Requirements Gatherin in Columbia, SC)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)