Verithium
Senior Oracle Data Modeler
TLDR
Translate business requirements into conceptual, logical, and physical data models and design data flows in finance/banking domains using Oracle, PowerDesigner, and ERWIN.
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