Senior Oracle Data Modeler

New York, United States | Contract

Apply

Our client is looking for Senior Oracle Data Modeler with extensive finance/banking domain experience.

Require 12+ years of experience

  • Understand and translate Business Requirements to Conceptual and Logical Data Models.
  • Create and update Physical Data Models (ERDs), of different types, from Logical Data Models using best practices and according to company standards
  • Work with the Application Development team to implement data strategies and build data flows
  • Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model.
  • Participate in mapping of Logical to Physical Data Models and vice versa.
  • Perform data model reviews with Data Modeling counterparts and BI team members.
  • Experience with SQL, PL/SQL, Toad, PLSQL Developer or other common data analysis, exploration, migration, and reporting tools.
  • Experience with modeling tools like PowerDesigner/ERWIN
  • In-depth knowledge of Oracle including strong SQL knowledge
  • Experience in analyzing and documenting data mapping and transformation rules
  • Experience writing complex views / materialized views, SQL queries and triggers