Accounting ETL Consultant (Jobs in Bismarck, ND)   Requirement id 74084 Job title Consultant Job location in Bismarck, ND Skills required Financial Management, Accounting, ETL, Open Date 05-Oct-2018 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: Financial Management, Accounting, ETL, Description : This Appendix contains summary information about DTL business processes that involve accounting and financial management work and transactions. The summary tables and high-level flow charts provided below are based on a detailed business process analysis conducted in 2016. That analysis resulted in detailed business process flow charts and analysis that are not included here but which will be made available to the selected Offeror. The following tables (Tables A1-1 to A1-x describe the processes that are owned by the Accounting, Revenue Compliance and Grants teams within the North Dakota Department of Trust Lands. These tables describe the high-volume activities that are completed within those teams. A glossary of the table columns is below: OVERVIEW OF INTEGRATION REQUIREMENTS For the purpose of development and operation of the FMA systems, the term “integration” is used to refer to access to software, web services, and data that is external to the FMA system. It encompasses a range of actions and processes that involve the movement of data from one system or database to another or an action or process in one system (software, Web service) that triggers a process in another system. Integration processes will use the most appropriate form of integration that meets DTL business requirements and adheres to applicable IT standards and security requirements. Several key points about integration will guide LM and FMA System development by the contractor: ? The timing of integration, in specific cases, may be real-time or near real-time, or set-up as a batch process with a specific schedule (from minutes to days depending on the specific integration case and the frequencies of data changes in the source system). ? FMA system and LM system development will require internal integration and external integration. Internal integration refers specifically to data, software, and process integration between the FMA System and LM System. External integration refers to integration with external systems and databases which are identified in Table 2. This RFP includes requirements for the selected contractor to design and put in place all defined external integration processes. However, Offerors should describe technical architecture elements or tools (e.g. application programming interfaces) that would support establishment of internal integration. ? Offerors are expected, in their proposals, to identify technical and procedural approaches for enabling internal and external integration. The DTL does not have preconceived ideas about how, from a technical standpoint, the integration requirements should be implemented. The DTL will rely on the selected contractor to suggest and put in place the most effective integration methods. The DTL and ITD will provide any input or support necessary for implementing the integration. ? In certain cases, meeting the integration requirements may use batch data transfer methods which are in general referred to extract-transform-load (ETL) processes. This implies that there are some actions on the source system to copy selected data and processes to transform (reformat, quality control, etc.) to create an intermediate file which is the basis for loading data to the LM System or FMA System. ETL requires defining a “data map” to ensure that data elements from the source system is loaded to proper database locations in the LM and FMA System databases. To enable ETL processes, the selected contractor will set up the necessary ETL processes with automated processes that control the timing of ETL process and keep a log of completed processes. While automated ETL processes may suffice for certain external integration processes, real-time integration (described below) is preferred. ? Real-time or near real-time integration implies that data transfer or process triggers occur immediately or within a short period of time (no more than   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 74084 while calling.   Other jobs in ND:    Financial Management job openings in other states Jobs List VDOT IT Purchasing Analyst (729333) Create date: 15-Feb-2024 Hybrid start date :03/04/2024 End date :06/30/2024 submission deadline :2/20/2024 client info :VDOT Description : *Local Richmond, VA candidates required for occasional onsite work *Candidate will telework. May be required to repo.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Network Project Manager PMP (725739) Create date: 14-Dec-2023 Hybrid Start date :12/29/2023 End date :06/30/2024 Submission deadline : 12/19/2023 Client info : VDOT Description : *Local Richmond, VA candidates only please *Candidate MUST possess PMP certification through PMI or VITAs PM certif.... (This job is for - job Jobs in VA Richmond Manager - (in Richmond, VA)) DAS-IT Consultant 3/ ITC3 (710519) Create date: 24-May-2023 start date : 06/12/2023 End date : 06/30/2024 submission deadline : 05/30/2023 client info : DAS Note : * Please submit contractors who can work Hybrid – 2 days in office per week. This is a potential multi year opportunity. Description.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH)) Business Analyst/Consultant IV -114783-SP Create date: 01-Mar-2023 Start date : 03/27/2023 End Date : 06/30/2023 Submission deadline : March 8, 2023, at 4:00PM CST. Client Info : UW - Madison Note : * Interview Process: Zoom w/camera on. Number of rounds (1 to 2) * Duration: Contract ending on June 30, 2023, with possibility of extension. .... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI)) DevOps Engineer III - 112796 - SP Create date: 06-Jan-2023 start date: 01/30/2023 End date: 06/30/2023 submission deadline: January 13, 2023, at 4:00PM CST; client info : UW - Madison Note : * Interview Process: Zoom w/camera on. Number of rounds (1) * Duration: Contract through 6/30/2023, with the possibility through 12 months .... (This job is for - EIB Jobs in WI Madison Engineer - (in Madison, WI))     (Consultant: Financial Management, Accounting, ETL, in Bismarck, ND)

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)