Description

You design and maintain enterprise data solutions using Oracle platforms and Erwin Data Modeler.

You will model and design enterprise data solutions using Oracle platforms.

Responsibilities

• Design and maintain data models using Erwin Data Modeler, managing subject areas and model templates.
• Develop and modify database structures using advanced DDL, including tables, indexes, constraints, and materialized views.
• Apply data modeling best practices like normalization, surrogate keys, and Slowly Changing Dimensions (SCD).
• Document models clearly and present design decisions to technical and non-technical stakeholders.

Required Skills

• 3+ years of hands-on data modeling experience in enterprise environments.
• Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred).
• Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c).
• Strong command of DDL for creating and modifying database objects.
• Knowledge of database internals: indexing strategies, partitioning, and query execution plans.
• Familiarity with version control systems, such as Git.
• Experience with SCD methodologies.

Preferred Skills

• Experience with Data Vault modeling.
• Familiarity with Hadoop or MongoDB.

Key Skills

Education

Any Gradute