Teradata Migration ETL Architecture Consultant (Jobs in Coralville, IA)   Requirement id 145309 Job title Consultant Job location in Coralville, IA Skills required Data Base Administration., Teradata, Migration, ETL Architecture Open Date 17-Jan-2024 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: Data Base Administration., Teradata, Migration, ETL Architecture Onsite start date :01/29/2024 End date :07/14/2024 submission deadline : 1/22/2024 client info : OCIO: Office of the Chief Information Officer Description : This position is responsible for the majority of all Iowa Justice Data Warehouse (JDW) enhancement processes, monitor status of application development and environmental modifications. Migrate the JDW from Teradata to Google/Big Query, and prepare comprehensive and accurate test plans for migration pipelines to Google. Required Skillset: Extensive experience with database administration, specialized knowledge of Teradata, ETL, and architecture. Knowledge and understanding of SQL and Teradata Utilities. Ability to integrate multiple system management processes and solve complex information technology system problems. 8-10 years of experience with database administration, or specialized knowledge of Teradata, ETL and architecture. Have knowledge and understanding of SQL and Teradata Utilities, have the ability to integrate multiple system management processes, and solve complex information technology system problems. Teradata/Google Migration and Data Governance Activities Project Description: Develop and provide Teradata documentation needed to initiate the migration to Google Enterprise Data Warehouse. Serve as primary contact for current Teradata Justice Data Warehouse (JDW) technical documentation, security, and flowcharts, including network and database details. Assist with migration tasks for the Enterprise Data Warehouse migration of databases, extraction, transformation, and load (ETL) processes and reporting. Find areas where the timeliness of current procedures can be reduced (to make the system more efficient). Project Purpose-Business Case: CJJP does not currently have a staff person that knows and understands the technical side of the Teradata Justice Data Warehouse. This role would support all facets of data governance and documentation needed by Division of Information Technology (DoIT). Duties would Include table updates, data growth metrics, flowcharts, security/network details, database information, etc. As DOM begins to migrate off the Teradata server, this position will assist in development of processes and stages of migration to a new Googe-based Enterprise Data Warehouse. Project Purpose – Business Objective: Google data pipeline management (SFTP, transfers, account, files, scheduled jobs, etc.). Ensure technical documentation deliverables are completed as needed for DoIT data governance. Decrease the cost of hardware, software, and services by migrating to Google/Big Query. Increase the timeliness of current Dept. of Corrections processes. Project Deliverables: Documentation that provides business and technical information for the JDW, including flowcharts, security/network details, database information, etc.; Lead migration efforts from JDW to EDW (Teradata to Google/Big Query); Develop, execute, and manage the current and new data process for the JDW and EDW migration efforts; Modify ETL scripts for DOC prison services data, reducing the time to process the data.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 145309 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1),    Data Base Administration. job openings in other states Jobs List ELECT - Database Administrator 3 - REMOTE (700812) Create date: 20-Feb-2023 Remote Start date :02/13/2023 End Date :12/31/2023 Submission deadline :2/23/2023 Client Info :ELECT Description : --------------------------------------------- The VA Department of Elections (ELECT) is seeking a senior SQL Administrator to support and provide solutions for SQL .... (This job is for - Jobs in VA Richmond Administrator - (in Richmond, VA)) .NET Back End Developer - 75828 Create date: 18-Sep-2020 start date:10/12/2020 End date:02/26/2021 submission deadline:10:00PM Sept 28, 2020. client info : Salt Lake County Note: * The duration of this project is long term * submit local resources that can report on site. (Work hour schedule is flexible) * The resource will be worki.... (This job is for - REST Jobs in UT SaltLakeCity Developer - (in Salt Lake City, UT)) EGLE - Programmer Analyst 1 (616220) Create date: 27-Nov-2019 Start Date :12/30/2019 End Date :12/18/2020 Submission Dead Line : 12/4/2019 Client Info :DEQ, DNR, MDARD Description : Required Experience: Experience in C#.NET, ASP.NET, CSS3, Bootstrap, HTML5, JavaScript, SQL, AJAX, XML, AngularJS, Angular, TypeScript, Azure D.... (This job is for - Triggers Jobs in MI Lansing Analyst - (in Lansing, MI)) Database Administrator Intermediate - 8686-1 Create date: 13-Mar-2019 Start Date :04/15/2019 Submission Deadline :03/20/2019 Client Info :Clemson University Description : SCOPE OF THE PROJECT: THIS WILL BE A 3-MONTH CONTRACT WORKING AT THE CLEMSON UNIVERSITY INFORMATION TECHNOLOGY CENTER WITH THE POSSIBILITY OF EXTENSION. DAILY DUTIE.... (This job is for - job Jobs in SC ANDERSON Administrator - (in Anderson, SC)) Database Admiistrator - Level 4 Create date: 11-Sep-2018 Start Date : 09/24/2018 End Date : 12/31/2018 Submission Dead Line : 09/14/2018 Client Info : CT DSS PROJECT / SYSTEM OVERVIEW IT services necessary for the completion/deployment, required maintenance and enhancement for the following: Provides technical leaders.... (This job is for - job Jobs in CT Hartford Administrator - (in Hartford, CT))     (Consultant: Data Base Administration., Teradata, Migration, ETL Architecture in Coralville, IA)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)