SSIS TFS 2012 Detail Oriented ETL Process And Development Windows Server 2012 .NET   Requirement id 48554 Job title Architect Job location in Columbia, SC Skills required MS SQL Server 2012, SSIS, SQL, TFS 2012 Detail Oriented ETL Process And Open Date 15-Sep-2015 Close Date Job type Not specified Duration 8 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: MS SQL Server 2012, SSIS, SQL, TFS 2012 Detail Oriented ETL Process And Description: 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 development and utility functions, such as SQL Server Analytical Services for OLAP, T-SQL, stored procedure, SSIS, etc. as needed for loading and analysis of data. Required Skills: The successful candidate will have, at minimum, the following 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. The individual will operate with limited supervision, within standards and processes established for the SCDOR Data Warehouse and over-all Agency and IRM procedures. SCDOR systems include extremely sensitive and confidential information; position requires complete discretion and trustworthiness, as well as knowledge of federal requirements for handling of confidential data. The individual must be customer oriented, and attentive to the needs of Data Warehouse users. Desired Skills:   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 48554 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 2012 job openings in Columbia, SC Jobs List Systems Software Programmer - Advanced - 9916-1 Create date: 24-Jun-2021 Start Date :07/23/2021 Submission Deadline :07/1/2021 Client Info : Department of Social Services Note : * INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? Video or in Person. * INTERVIEW AVAILABILITY: How soon can you schedule an interview (date / tim.... (This job is for - IIS Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) SYSTEMS SOFTWARE PROGRAMMER - 9407-1 Create date: 30-Jun-2020 Start Date :08/03/2020 End Date :06/30/2021 Submission Deadline :07/07/2020 Client Info : Education Department Note : * INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? Up to 2 rounds of interviews via Phone, Skype, or in-person. * INTE.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) SYSTEMS SOFTWARE PROGRAMMER - 9397-1 Create date: 15-Jun-2020 Start Date :07/16/2020 End Date :9/30/2020 Submission Deadline :06/22/2020 Client Info : Education Department Description : An Software developer / programmer is needed to assist the South Carolina Department of Educations (SCDE) Offices of Project & Application Management and .... (This job is for - ColdFusion Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) INTERNET WEB ENGINEER - 9339-1 Create date: 28-May-2020 Start Date :07/01/2020 End Date :06/30/2021 Submission Deadline :06/04/2020 Client Info : Education Department Note : * INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? Up to 2 rounds of interviews. In person if possible can do phone or video conference ColdFusion ASPNet Jobs in SC COLUMBIA Engineer - (in Columbia, SC)) SYSTEM SOFTWARE PROGRAMMER - 9258-1 Create date: 26-Mar-2020 Start Date : 4/20/2020 Submission Deadline : 4/3/2020 Client Info : Education Department * INTERVIEW PROCESS: (phone, video or in-person, how many rounds of i/vs, etc)? Up to 2 rounds of interviews. In person if possible can do phone or video conference. *INTERVIEW AVAILABILI.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC))    MS SQL Server 2012 job openings in other states Jobs List SE3 And DBA2 - FY20-HW-01 Create date: 05-Mar-2020 Start Date : 04/15/2020 End Date : 08.17.2020 Submission Dead Line : 04/03/2020 Client Info : Idaho Department of Environmental Quality (DEQ) Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) The H.... (This job is for - job Jobs in ID BOISE Engineer - (in Boise, ID)) DOR - IT - Database Administrator 3 (601463) Create date: 23-Oct-2019 Start Date :12/2/2019 End Date :12/31/2020 Submission Dead Line :10/25/2019 Client Info :DOR - IT Description :This posting is intended to fill a full-time position and will be contract-to-perm. The length of the contract will be 12 months. As FYI to all candidates, the salary range for .... (This job is for - job Jobs in GA Atlanta Administrator - (in Atlanta, GA)) Database Architect - 18-501 Create date: 01-Aug-2017 Start Date : 08/28/2017 End Date : 06/30/2018 Submission Dead Line : 08/09/2017 Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) Assist the project management team on the Land Information Management System (LIMS).... (This job is for - SSRS Jobs in ID Boise Architect - (in Boise, ID)) System Administration W/ Enabalon Create date: 15-Jun-2015 NOTE : START DATE : 06/25/2015 SUBMISSION DEADLINE : 06/19/2015 CLIENT INFO : Comsys Description: Client: HP Location: Pontiac, MI Duration: 3 + Months Rate: 55 hr C2C Travel will be covered. 3 .... (This job is for - SMTP Jobs in MI Pontiac Administrator - (in Pontiac, MI)) Solution Architect-TSS-002473 Create date: 09-Jan-2015 Description: The Solution Architect will be responsible for creating the overall application architectures, application component designs, and systems integration and implementations for several DMV systems undergoing updates and or redesign from a SOA perspective. This individual will also be responsible for overall architecture.... (This job is for - Biztalk Jobs in NC Columbia Architect - (in Columbia, NC))    MS SQL Server 2012 job openings in SC Jobs List Systems Software Programmer - Advanced - 8122-1 Create date: 08-Jun-2018 Description : SCOPE OF THE PROJECT: The Division of Technology Services is responsible for developing, implementing, maintaining, and obtaining multiple mission critical applications for the Department of Social Services. The Department seeks a highly motivated individual who has the skills for the software development.... (This job is for - job Jobs in SC Colunbia Developer - (in Colunbia, SC)) (Architect: MS SQL Server 2012, SSIS, SQL, TFS 2012 Detail Oriented ETL Process And in Columbia, SC)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)