SSIS Data Integration ETL Data Mapping ETL Process Validation MDM Data Marts datawa   Requirement id 109806 Job title Expert Job location in Raleigh, NC Skills required IT Industry Experience, SQL Programming, SSIS, Data Integration ETL Data Mapping ETL Pr Open Date 04-Sep-2020 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Expert: IT Industry Experience, SQL Programming, SSIS, Data Integration ETL Data Mapping ETL Pr Start Date :09/08/2020 Submission Deadline :09/11/2020 End Date :02/28/2021 Client Info : NCCCS-IT Division-PMO Note: * Agency Interview Type:Either Webcam Interview or In Person * Candidates will be allowed to work remotely. However, he/she does need to be onsite as required, likely once a week. The candidates will need to be in Raleigh so he/she can come onsite at short notice. Candidates need to be local to Raleigh, NC. Description: The individual will be accountable for successful design, development and delivery of SQL solutions within on prem and cloud environments. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS), and a dimensional model (EDM). Responsible for architecting, testing, implementation of solution as well as mentoring and training other SSIS/ETL developers in technology and business processes. Expected Skills: Able to work without assistance; can provide leadership to others; able to manage highly complex work efforts; may have advanced education; may have extensive industry experience. Responsibilities (including, but not limited to): 1. Data analysis and database management 2. Strong experience using SSIS as the ETL tool in a data warehouse environment. 3. Exercises, in conjunction with the enterprise data architect, independent decision making to creates processes which initiate the ETL, developing stream-lined processes for extracted data loading to destination databases. 4. Performs data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information. 5. Creates data validation rules on source data to confirm the data has correct and/or expected values. 6. Creates process cleanup after complex ETL processes which release resources used to run ETL. This would include error handling and SSIS restart. 7. Designs and implements technology best practices, guidelines, and repeatable processes. 8. (Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends This work order is essential for service delivery of the following: A new System Office Analytical Data Warehouse in the cloud. The DBA Team has one (1) SQL Server Administrator on staff. These positions will work with the DBA team in conjunction with the Data Warehouse team.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 109806 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3), IT Industry Experience job openings in Raleigh, NC Jobs List NCCCS - SQL Developer/SSIS Expert (644782) Create date: 05-Feb-2021 Start Date :02/15/2021 End Date :02/14/2022 Submission Deadline :02/11/2021 Client Info : NCCCS-IT Division-PMO Note : * Agency Interview Type : Either Webcam Interview or In Person Description : ****Candidates will be allowed to work remotely. However, h.... (This job is for - ETL SSIS Jobs in NC Raleigh Developer - (in Raleigh, NC)) NCCCS - SQL DBA - Expert (620713) Create date: 20-Feb-2020 Start Date : 03/02/2020 End Date : 02/26/2021 Submission Deadline : 02/26/2020 Client Info : NCCCS-IT Division-PMO Note: * Interview Type : Both Phone and In Person Description : The individual(s) will be accountable for the successful design, developm.... (This job is for - job Jobs in NC Raleigh Expert - (in Raleigh, NC)) MS SQL Server Database Developer - 431172 Create date: 20-Oct-2015 Description: The client is seeking a MS SQL Server Database Developer with strong system analysis and programming skills/experience to design and develop a web-based ASP.NET system using SQL Server Integration Services (TSQL) and Stored Procedures for the Division of Public Health, Communicable Disease Branch. Duties include .... (This job is for - SSIS SSRS Jobs in NC Raleigh Developer - (in Raleigh, NC))    IT Industry Experience job openings in other states Jobs List KSU IT Inventory Associate (741459) Create date: 10-Jul-2024 No of submissions :2 Start date :8/8/2024 End date :12/20/2024 Submission deadline :07/15/2024 Client info :KSU - UITS Note: * Onsite Description : On-Site Work Possibility of extensions. This person w.... (This job is for - RFID Jobs in GA Kennesaw Consultant - (in Kennesaw, GA)) IT Security Analyst 1 - 128894 Create date: 03-Apr-2024 Start date : 05/06/2024 End date : 1 Years from projected start date Submission deadline : 4/10 at 10AM EST. Client info : MDOT Note : * Interviews: First round MS Teams second will be in person interviews. This must be indicated on the coversheet (Y/N) * Duration: 1 year wit.... (This job is for - job Jobs in MI Lansing Analyst - (in Lansing, MI)) NJATCSU Sr.Consultant 2-Tableau (721647) Create date: 02-Oct-2023 Hybrid start date :10/15/2023 End date :02/03/2024 submission deadline :10/5/2023 client info :Judiciary Description : The Tableau Specialist - under the direct supervision of a Court Executive of the Data Division - Trial Court .... (This job is for - Tableau Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJAOC Sr.Consultant 2-Tableau - (716174) Create date: 09-Aug-2023 Remote Start date :07/30/2023 End Date :09/09/2023 Submission deadline :8/14/2023 Client Info :Judiciary Description : Note: Position can be 100% remote if candidate is not local. Local candidates may be required to work onsite 1-2 days/ wk. Role will be extended. Tableau Jobs in NJ Trenton Consultant - (in Trenton, NJ)) IT Security Analyst 1 - 120932 - SP Create date: 04-Aug-2023 start date : 08/28/2023 End date : 1 Years from projected start date submission deadline : 8/11 at 10am client info : MDOT Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged..... (This job is for - NIST Jobs in MI Lansing Analyst - (in Lansing, MI))    IT Industry Experience job openings in NC Jobs List Java Developer - 70421 Create date: 22-Dec-2020 Note: This is a markup account, please list consultants W2 hourly pay rate in the comments section when submitting. Upon offer, it is required to show consultants W2 take home pay in the Exh A Candidate must be our W2 Employee. Job Description: Senior Java Developer Overall 7+ years IT industry experience with .... (This job is for - SDLC Java Jobs in NC Charlotte Developer - (in Charlotte, NC)) Python Developer - 62973 Create date: 06-May-2020 Candidate must be our W2 Employee. Job Description : Overall 8+ years IT industry experience. 3+ years of experience on Python , Scala and SPARK. Strong written and verbal communication skills. Strong Experience in visualization, analytical design & performance tuning Python Scala Jobs in NC Charlotte Developer - (in Charlotte, NC)) Python Developer - 62852 Create date: 01-May-2020 Note :Manager will hire off of 1 video interview! Candidate must be our W2 Employee. Job Description : Overall 8+ years IT industry experience. 3+ years of experience on Python , Scala and SPARK. Strong written and verbal communication skills. Strong Experience in vis.... (This job is for - Python Scala Jobs in NC Charlotte Developer - (in Charlotte, NC)) Scrum Master - 51034 Create date: 09-Aug-2019 Candidate must be our W2 Employee Notes : DO NOT SUBMIT ANY CANDIDATES UNLESS I EMAIL YOU TO DO SO. I already have candidates and opening this so they can be submitted only. Everyone else will be rejected. If we need more after this round I will notify all vendors. Thanks Jira Jobs in NC Charlotte Consultant - (in Charlotte, NC)) Systems Analyst Specialty Senior - J-10-975-450 Create date: 10-Feb-2015 Must have: TeaLeaf experience - hands on experience Will be the only one currently with this experience at this time If person has TeaLead Admin experience that is a huge plus - or someone that would like to grow into the TeaLeaf Administrator JobOn Questions * Define your experience with Tealeaf? versions? Functional.... (This job is for - job Jobs in NC GREENSBORO Analyst - (in Greensboro, NC)) (Expert: IT Industry Experience, SQL Programming, SSIS, Data Integration ETL Data Mapping ETL Pr in Raleigh, NC)

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)