Sr Data Modeler - Oracle EBS Data Modelling
Contract : 6-12 Months
Loctaion : USA -Remote.
Data Modeler
Translate business requirements into conceptual/logical/physical data models that are easy to understand.
Design declarative data warehouse transformation rules/guidelines, for extraction/sourcing, loading, and transformation.
Use SQL queries/custom scripts for rapid prototyping data model / transforms.
Design, develop unit/integration test data/plan and scripts for data model deliverables.
Creates supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Strong in Oracle ERP financials, deep understanding of General Ledger, Accounts Payable, Accounts receivables, Quote 2 Cash business process.
Participate in data model reviews with Solution and Enterprise architects as required.
Required Skills
BS or higher degree in Computer Science, Computer Engineering or equivalent with 7+ years of applied experience.
5+ years of experience working in data architecture/modeling, master data management.
Strong experience with Data warehousing and data modelling concepts.
Experience in developing/supporting data solutions over multiple releases.
Experience with Oracle databases and cloud database architecture (Snowflake).
Experience in performance tuning SQL and understanding ETUELT pipelines.
Experience in Python/Java.
Experience with data modeling software (Erwin).
Experience in normalization techniques (3rd NF).
Experience in dimensional modelling (Star/Snowflake schema).
Good working knowledge of the types of slowly changing dimensions.
Experience in communicating data models to technical and non-technical users. Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.
Design, Develop, troubleshoot and debug software programs for databases, applications, tools, network etc