ETL Architect (Jobs in Columbia, SC)   Requirement id 7957 Job title Architect Job location in Columbia, SC Skills required ETL, ETL Large Scale Conversion, Data Management Tools, Open Date 12-Jan-2012 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Architect: ETL, ETL Large Scale Conversion, Data Management Tools, [Note: Start Date : 2/15/2012] [Note: Duration : 12+ Months] Description : SCOPE OF THE PROJECT : The Medicaid replacement projects (Medicaid Management Information System and the Eligibility & Enrollment Member Management) are among the most complex IT projects taken on by the SC Department of Health and Human Services in partnership with Clemson University. These projects are multi-year efforts to replace the States aging Medicaid systems with a multi-tier application environment that requires modern technologies, technical practices and substantial collaboration with a variety of stakeholders. Responsibilities : SCDHHS seeks a skilled technical professional with relevant experience on similar projects that can both complete the data conversions tasks required for this project while also providing recommendations for ETL, data profiling, data quality and data management best practices based on their experiences and expertise. The Data Conversion Lead will be focused on planning, converting and migrating data migration (including extraction, transformation and loading [ETL]) from legacy mainframe system(s) (IDMS and IDMS-R) to a modern relational database as part of the overall Medicaid replacement projects. The Data Conversion Lead will carry out the data management activities necessary to achieve the projects data migration strategic goals and objectives and work closely with the projects data architect, database administrators and technical leads. The Data Conversion Lead will create manual and/or automated procedures and/or custom configure data conversion software as required to perform the activities indentified in the data conversion plan. They may also assist with migration of As-is system data and external data to the new MMIS system and selected data administration tasks. Data conversion development tasks include: * Develop and manage data conversion rules and ETL process(es) * Validate pre-converted and post-converted data to ensure the data is consistent, well formed, and of high structural integrity * Create and manage a schedule of database conversion related tasks and events * Establish, test and execute reliable and repeatable process(es) for converting legacy data into a modern relational database that meets the projects functional and non-functional requirements * Use of appropriate data conversion tools, strategies, and methodologies that will meet the data conversion plan objectives Required Skills : * Significant experience with ETL activities * Demonstrated success in developing, documenting and managing ETL for large data sets * Experience working with commercial database solutions * Experience working with commercial ETL/data management tools * Ability to develop, propose and present solutions/approaches to data conversion activities, especially in light of a variety of possible approaches * Good written and oral communications skills, including the ability to give presentations to the management team. Strong proficiency in English is required. * Willingness and ability to effectively engage with people and organizations on a continuous basis. PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE) : * Oracle Database * Experience with MS-SQL server * Knowledge of IDMS/IDMS-R data structures and COBAL programming Medicaid Management Information System (MMIS) experience * Medicaid eligibility system/business operations experience. *Commercial insurance and/or health care data experience * Public sector experience is a plus. REQUIRED EDUCATION : Bachelors degree in a technical, business, or field. Masters degree is desirable. Years of experience can substitute for formal education.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 7957 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), ETL job openings in Columbia, SC Jobs List RHAPSODY DEVELOPER-Consultant - 11216-1 Create date: 28-May-2024 No of submissions : 2 Start date : 6/17/2024 Submission deadline : 6/4/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will conduct one initial.... (This job is for - T SQL ETL Sql Server 2000 Jobs in SC COLUMBIA Developer - (in Columbia, SC)) ETL Developer - 7328-1 Create date: 04-May-2017 Start date : 06/01/2017 Deadline : 05/11/2017 Client : Department of Employment and Workforce Description : SCOPE OF THE PROJECT: PERFORM DATA CONVERSION AND INTERFACE DEVELOPMENT FOR LARGE ENTERPRISE PROJECT. DAILY DUTIES / RESPONSIBILITIES: RESPONSIBLE FOR THE ANALYSIS, DESIGN, DEVELOPMEN.... (This job is for - ETL Jobs in SC COLUMBIA Developer - (in Columbia, SC)) BI ETL Specialist / System Software Programmer - 5332-1 Create date: 22-Dec-2013 [Note : Deadline 26th Dec 2013, Skype video interviews] Job Description: Daily Duties / Responsibilities: Candidate will be responsible for creating, designing and developing the process to extract and transform data from OLTP data source and load aggregated data into OLAP environment. The ETL process should utilize the M.... (This job is for - ETL SSAS SSIS Jobs in SC Columbia Specialist - (in Columbia, SC)) 4119-1-SAP Technical Team Ld Consultant Create date: 29-Mar-2011 [NOTE:A.HOW MANY RESUMES DO YOU WANT TO REVIEW AT ONE TIME?:All that qualify B.POSSIBILITY OF EXTENSION] DAILY DUTIES / RESPONSIBILITIES: Within project schedules and other defined deadlines, candidate will provide functional and technical services including: • The Data Architect / modeling expertise • Gather data inf.... (This job is for - datawarehouse ETL SAP Jobs in SC Columbia Consultant - (in Columbia, SC)) 4118-1-SAP Functional Team Ld Consultant Create date: 29-Mar-2011 Organization: Department of Employment and Workforce NOTE:A.HOW MANY RESUMES DO YOU WANT TO REVIEW AT ONE TIME?:All that qualify B.POSSIBILITY OF EXTENSION DAILY DUTIES / RESPONSIBILITIES: Within project schedules and other defined deadlines, candidate will provide functional and technical services including: <.... (This job is for - ETL datawarehouse SAP Jobs in SC Columbia Consultant - (in Columbia, SC))    ETL job openings in other states Jobs List Business Intel Technical Lead II -134854 Create date: 17-Sep-2024 Bid Limit Per Vendor : 2 Start date : 10/14/2024 End Date : 06/30/2025 Submission deadline : 9/23/2024 at 4:00PM CST. Client Info : DOT Note : * Interview Process: Teams interview with Camera On * Duration: 6/30/25 with possible extensions * Remote or On-site? Candida.... (This job is for - ETL Jobs in WI Madison TechLead - (in Madison, WI)) NCDPI - SQL/Snowflake - Tableau Developer - Expert (746387) Create date: 09-Sep-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 03/21/2025 Submission deadline : 09/13/2024 Client Info : Note: * Agency Interview Type : In Person Only * Onsite Description : ***This is an onsite position in Raleigh, NC. Current.... (This job is for - ETL Jobs in NC Raleigh Developer - (in Raleigh, NC)) Data Warehouse Developer III -134848 Create date: 09-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/11/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? No WI reside.... (This job is for - ETL Implementation Testing Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III -134705 Create date: 04-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/6/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? Candidate MU.... (This job is for - ETLDataloader Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III - 130341 Create date: 09-May-2024 No of Submissions : 2 Start date : 06/17/2024 End date : 06/30/2024 Submission deadline : 5/15/2024 at 4:00PM CST. Client info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? No.... (This job is for - ETLCDC Jobs in WI Madison Developer - (in Madison, WI))    ETL job openings in SC Jobs List Datastage Developer - 70626 Create date: 06-Jan-2021 Job Description: We have an urgent need for a DataStage ETL Senior Developer. This persons task is to extract relational data base data from a mainframe, transforming the data to flat files, in some cases encrypting and/or compressing the data and loading that data onto DataStage (Infosphere) server. From there t.... (This job is for - ETL Datastage Jobs in SC Greenville Developer - (in Greenville, SC)) ETL / Datastage - 69035 Create date: 02-Nov-2020 Candidate must be our W2 Employee. Job Description : High Level DataStage experience - DataStage is an ETL (Extract/Transform/Load) tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. Must be great at coding and analysis resource Retail Data base experience is a plus. .... (This job is for - ETL Analysis Coding Jobs in SC Greenville Consultant - (in Greenville, SC)) DataStage ETL Sr. Developer - 66354 Create date: 01-Sep-2020 Candidate must be our W2 Employee. Job Description : U Urgent need for a DataStage ETL Senior Developer. This persons task is to extract relational data base data from a mainframe, transforming the data to flat files, in some cases encrypting and/or compressing the data and loading that data onto DataStage (Infosphere) server..... (This job is for - ETL InfoSphere Analysis Jobs in SC Greenville Developer - (in Greenville, SC)) DataStage ETL Sr. Developer - 61487 Create date: 24-Mar-2020 Note: * Candidate must be your W2 Employee. * We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems) Job Description : Location: Greenville, SC (first 2 months 100% remote) Retail Business Services has an urgent need for a DataSta.... (This job is for - Datastage ETL InfoSphere Jobs in SC Greenville Developer - (in Greenville, SC)) ETL/Datawarehouse Developer - 38092 Create date: 30-Aug-2018 Candidate must be our W2 Employee Job Description : Minimum Qualifications: · Proven or Extensive Experience/Background with the following systems/technologies. - Teradata - ETL/SAS - SQL ETL - Korn Shell scripting .... (This job is for - Teradata ETL Jobs in SC FortMill Developer - (in Fort Mill, SC)) (Architect: ETL, ETL Large Scale Conversion, Data Management Tools, 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)