ETL Stored Procedures. PLSQL Oracle 11g R2 Databases Oracle Database Developer Deve   Requirement id 53280 Job title Developer Job location in Lansing, MI Skills required not found, ETL, SQL, Stored Procedures. PLSQL Oracle 11g R2 D Open Date 29-Apr-2016 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: not found, ETL, SQL, Stored Procedures. PLSQL Oracle 11g R2 D Description: The client is in need of an Oracle Database Developer. They are currently working with Oracle 11g. This position requires a concentration in database design, data transformation, writing geospatial queries, physical database modifications, writing stored procedures and other duties related duties. Responsibilities in this role include, but are not limited to, developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions. They will be writing complex SQL statements including spatial queries using Oracles SDO_Geometry data type. They will be using Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database. The resource will be performing the function of extract-transform-load (ETL) using automated tools and will be using Oracle system utilities and DBMS packages to minimally generate dynamic SQL. The resource will also be writing database stored procedures and functions using PL/SQL. Establishes physical data base parameters. Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Tests and corrects errors, and refines changes to data base. Enters code to create production data base. Selects and enters codes of utility program to monitor data base performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. May train users. Required Skills: * Developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions * Experience with Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database * Experience performing Extract-Transform-Load (ETL) using an automated tool * Experience writing SQL statements * Experience using Oracle system utilities and DBMS packages to minimally generate dynamic SQL * Experience writing stored procedures and functions using PL/SQL * Oracle 11g Desired Skills: * Experience writing spatial queries using Oracles SDO_Geometry data type * Experience with Oracle Spatial Network and/or Topology Model * Experience with Geographic Information Systems (GIS) & geodatabases * Experience with Business Objects * Data Administration and Governance experience * Object-Relational mapping experience * Experience with TOAD software * Dimensional database design experience * IBM Datastage experience * Experience using Safe FME for data conversion * Experience with ESRI ArcGIS   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 53280 while calling.   Other jobs in MI: Ann Arbor (5), Detroit (2), Dimondale (1), Lansing (29), Pontiac (1), Southfield (1), TROY (1), Warren (1),    not found job openings in other states Jobs List Data Warehouse Developer II - WISCJP00018092 Create date: 17-Feb-2021 Start Date :03/29/2021 End Date :06/30/2021 Submission Deadline :Due to SCS 02/23/2021 by 8:00 A.M. CT Client Info : DCF – Department of Children and Families Note : * Duration: Initial Period: 03/29/2021 - 06/30/2021; Renewals/Extensions through 06/30/2024 Description .... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer I - WISCJP00017949 Create date: 09-Dec-2020 Start Date :01/18/2021 End Date :06/30/2021 Submission Deadline :Due to SCS 12/15/2020 by 8:00 a.m. CT Client Info : DCF – Department of Children and Family Description : Position is for 6 months with the possibility of renewal after 6/30/2021. This contract posit.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) VDOT Data Modeler/Architect (630550) Create date: 05-Jun-2020 Start Date :7/1/2020 End Date :06/30/2021 Submission Deadline:06/12/2020 Client Info:VDOT Note: * Agency Interview Type:Web Cam Interview Only * Local candidates strongly preferred * Interviews will be conducted via Skype or Google Hangout. * Candidates w.... (This job is for - job Jobs in VA Richmond Architect - (in Richmond, VA))     (Developer: not found, ETL, SQL, Stored Procedures. PLSQL Oracle 11g R2 D in Lansing, MI)

Featured Jobs System Analyst (Jobs in Madison, Wisconsin) Consultant (Jobs in Dauphin County, Pennsylvania) Project Analyst (Jobs in Lincoln, Nebraska) - Consultant (Jobs in Lincoln, Nebraska) Business Analyst Written Analyst (Jobs in COLUMBIA, South Carolina) .Net Developer (Jobs in Nampa, Idaho) Agile TFS Analyst (Jobs in COLUMBIA, South Carolina) Pega Case Consultant (Jobs in Trenton, New Jersey) SQR Billing Consultant (Jobs in COLUMBIA, South Carolina) Workflow Health Consultant (Jobs in Jackson, Mississippi)