TSQL Queries Stored Procedures Data Manipulation Databases And Relational Database   Requirement id 47526 Job title Architect Job location in Columbia, SC Skills required Gathering And Analyzing Business User Requirements, Java Development And/Or .NET Development, SQL, TSQL Queries Stored Procedures Data Mani Open Date 24-Jul-2015 Close Date Job type Not specified Duration 10 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: Gathering And Analyzing Business User Requirements, Java Development And/Or .NET Development, SQL, TSQL Queries Stored Procedures Data Mani Description: MUST: Please note that 2 full professional references (not just contact information) are required to be provided with every candidate submission. SSIS expertise required!!! SCOPE OF PROJECT: 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. Required Skills: • Experience and expertise in gathering and analyzing business user requirements. • Mid-Level Experience in Java development and/or .NET development. • Experience and expertise in SQL, including development of T/SQL queries, stored procedures and data manipulation. Expert knowledge of databases and relational database concepts. Experience with SQL Server 2005 is desirable; experience with SQL Server 2012-14 is required.. • Experience with Windows 7 operating system and the Windows 2012 server environment. • Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. Expertise in SSIS is required. • Ability to communicate clearly and concisely, both orally and in writing. • Ability to establish and maintain good working relationships with business users, management, vendors, and peers. • Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. • Understanding of deployment methodology concepts including design, build, testing, and deployment. Background Checks: * Employment Verification - 7 year history * Criminal Record - 7 Year History * Professional Reference * E-Verify * Education Verification * Credit Report - 7 Year History * South Carolina Law Enforcement Division (SLED) Check via website   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 47526 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),    Gathering And Analyzing Business User Requirements job openings in other states Jobs List Hyperion Financial Management - 62969 Create date: 05-May-2020 Note :Were looking for a Hyperion Financial Management architect I will also look at HFM technical leads,Candidates will start by working remote, but will be required to relocate and work onsite in Bentonville, Arkansas. Job Description : Hyperion Financial Management Architect Responsibilities: Gathering a.... (This job is for - Oracle Jobs in AR Bentonville Consultant - (in Bentonville, AR)) Business Analyst 3 - 52909012RR Create date: 06-Feb-2020 Start Date :2/28/2020 End Date :8/31/2020 Submission Deadline :February 13, 2020 @ 5:00 PM(CT Client Info: Health and Human Services Commission (HHSC). Description : All work products resulting from the project shall be considered “works made for hire” and are the property of .... (This job is for - Business Analyst Jobs in TX Austin Analyst - (in Austin, TX)) NC DHHS Senior Business Analyst (615176) Create date: 25-Nov-2019 Start Date :12/16/2019 End Date :12/15/2020 Submission Dead Line :12/3/2019 Client Info :NCDHHS-PMO Description : The NC Department of Health and Human Services - Division of Mental Health, Developmental Disabilities, and Substance Abuse Services seeks a Senior Business Analyst.... (This job is for - job Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Data Architect - J-11-083-433 Create date: 15-Jan-2016 NOTE Start Date : 02/01/2016 End Date : 08/31/2016 Submission Deadline : 01/21/2016 Client Info : COMSYS Description: It supports a large client Foster City, CA in need of a Data Architect to participate in data requirements gathering and analysis for a project. JOB .... (This job is for - Architecture Jobs in CA FOSTERCITY Architect - (in FOSTER CITY, CA))     (Architect: Gathering And Analyzing Business User Requirements, Java Development And/Or .NET Development, SQL, TSQL Queries Stored Procedures Data Mani in Columbia, SC)

Featured Jobs Jira Agile SCRUM Analyst (Jobs in Atlanta, Georgia) OCM PMP Consultant (Jobs in Atlanta, Georgia) Helpdesk Analyst (Jobs in Atlanta, Georgia) IT Consultant (Jobs in Richmond, Virginia) Agile Analyst (Jobs in Raleigh, North Carolina) BRD Agile Analyst (Jobs in Richmond, Virginia) - Manager (Jobs in Jackson, Mississippi) Cobol CICS CICS Specialist (Jobs in Raleigh, North Carolina) Interpersonal Specialist (Jobs in Raleigh, North Carolina) Written Developer (Jobs in Raleigh, North Carolina)