*Dear,* *Hope you are doing well…..*
*Please send resumes to r...@hclglobal.com <r...@hclglobal.com>* *ROLE* *Oracle Database Developer* *LOCATION* *Lansing MI* *DURATION* *LONG TERM* *RATE* *DOE* *CLIENT* *DIRECT* *INTERVIEW TYPE* *Skype or In-Person* *State Experience Highly Preferred* *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply* *Note: For H1 While submitting I need consultant I 797 OR ID Proof.* • Will be working as a team and likely leading the team • Highly complex data conversion of legacy systems to a new ERP • Complex business rules that are fluid and can change • Mission critical project • High pressure • Must be well organized and can work with Project Managers • The knowledge and use of Talend Software and Oracle PL SQL Tools is a plus MDOT 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 Oracle’s 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 co-workers 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. *Skills* *Required* *Years Used* *Last Used* Developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions *7 Years* Oracle 11g *2 Years* Experience writing SQL statements *5 Years* Experience with Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database *7 Years* Experience performing Extract-Transform-Load (ETL) using an automated tool *7 Years* Experience using Oracle system utilities and DBMS packages to minimally generate dynamic SQL *5 Years* Experience writing stored procedures and functions using PL/SQL *3 Years* Experience writing spatial queries using Oracle’s SDO_Geometry data type *3 Years* Experience with Oracle Spatial Network and/or Topology Model *3 Years* Experience with Geographic Information Systems (GIS) & geodatabases *3 Years* Experience with Business Objects *2 Years* Data Administration and Governance experience *2 Years* Object-Relational mapping experience *2 Years* Experience with TOAD software *2 Years* Dimensional database design experience *1 Years* IBM DataStage experience *1 Years* Experience using Safe FME for data conversion *1 Years* Experience with ESRI ArcGIS *1 Years* Thank You, Warm Regards, Mani Technical Recruiter HCL Global Systems Inc. Desk: (248)473-0720 Ext: 157 Email: r...@hclglobal.com Web: http://www.hclglobal.com *Certified Minority Business Enterprise (MBE)* ___________________________________________________________________ DISCLAIMER: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.