*Dear,* *Hope you are doing well…..*
*Please send resumes to* *r...@hclglobal.com <r...@hclglobal.com>* *ROLE* *Oracle Data Modeler/Designer* *LOCATION* *Denver CO* *DURATION* *LONG TERM* *CLIENT* *DIRECT* *INTERVIEW TYPE* *Phone* *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.* Overall 15+ years of experience with at least 5+ year of experience in Database design / Architecture / Data Modeling for business object, OLTP, ODS and Data Mart or Data Warehouse utilizing Oracle. Working knowledge of Erwin In depth Working knowledge and experience of Oracle 11g - preferably 12c. Working knowledge and experience of Unix Shell Scripting. Recommend best practices for database design (conceptual, logical, and physical). Understand the data requirements, ETL layer and tools familiarity with (data transformation / extraction) *Skills* · Work closely with compliance and security architects, to ensure implementation in support of FTI and PII data · Establishes and administers an effective data model/architecture design that can be leveraged by business applications, development resources, and reporting systems to swiftly and reliably meet the continual evolving needs of the organization. · Develops and implements database designs that meet business requirements consistent with business needs and upholds the standards of state data · Create an open design to minimizes the impact of future business constraints · Conduct data design workshops with business stakeholders and application owners to capture the information needs of the business · Create high level business information models and/or conceptual data models understandable by the business · Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Database, Data Warehouse, Data Marts and data cubes etc. · Define ownership, obtain approvals, and communicate data models to Technology teams. · Ensure consistent enterprise view and usage of data assets across the system, processes and applications · Provide architectural expertise in data, data warehouse, data source identification and migration within the latest DB technologies · Design the logical data model consisting of entities, attributes and relationships between entities · Validate final logical data model with the business community to ensure accuracy · Define data dictionary ensuring consistency, accuracy and domain validation *Additional Preferred Qualifications* · Experience creating data models using Information Engineering (IE) methodology. · Experience using the Enterprise Architect or Erwin Data Modeling tool. · Experience coding Structured Query Language (SQL). · Extensive experience designing relational tables for Oracle, SQL Server, DB2, or DBMS. · Experience designing tables NSQL or Big Data platform environments (e.g. HIVE, Cassandra) · Understanding and experience with AWS, GCP or other Cloud Services · JPA (Java Persistence API) and ORM ( Object Relational Mapping) and Hibernate · Experience leading data modeling efforts AND 5 years’ experience applying data modeling concepts to develop logical and physical data models (entity relationship diagrams (ERDs)) within the last 7 years. · Experience with Canonical Modeling, messaging and data object modeling a plus *Skills* *Required* *Years Used* *Last Used* AWS-CSA Professional (cloud) *5 Years* Data Modeling *5 Years* DB2 *5 Years* Java *5 Years* Oracle *5 Years* Oracle 12c *5 Years* Oracle Application Server *5 Years* Oracle Environmental Manager (OEM) *5 Years* SQL *5 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 "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.