Normalization techniques 3NF Star and Snowflake schemas Forward and Reverse Engineering
JD for Offshore Data Modeler Role
This person will be working on BLDM BAU work.
Need excellent skills in Oracle dimensional model as well as entity relational data model.
Be able to come up with efficient performing and optimum design.
Experienced in data warehouse dimensional and entity relational model.
We would love someone who can play a designer/solution lead role.
Definitely need DBA type skills: data modeling using Power Designer and DDL.
Generating the DDS (Detailed Design Specification) from the BSA inputs to hand off to ETL team.
Responsibilities
Be in charge of developing conceptual logical and physical data models and implementing RDBMS operational data stores (ODS) data marts and data lakes on target platforms (SQL/NoSQL).
Manage the extension of existing data architecture and optimize data query performance through best practices. The applicant must be capable of working both alone and cooperatively.
Involve business users in determining their information requirements
Examine the business process and conceive the entities that interact inside it
Determine how the various entities are connected and create entity relationship diagrams to depict the links between the entities
Determine the qualities and properties of each entity and verify that the entities can be distinguished inside the model
Create a logical data model and validate it to ensure it meets the demands of the business application and its users
Convert the model s logical representation into a physical manifestation and collaborate with database administrators to instantiate and maintain the data
Work with the BI and Analytics teams to create an efficient reusable semantic model that includes metadata and lineage information
Finetune the model to achieve consistent performance
Keep the metadata the "data about the data" that describes the data model its structure and semantics up to date
Recommend and implement design and maintenance standards guidelines and procedures
Data Modeler Requirements & Skills
A bachelor s degree in Management Information Systems Computer Science Computer Information Systems or a related Information Technology area
Proficient in industrystandard data modelling methodologies
Excellent teamwork and communication abilities
Excellent consultative facilitative and consensusbuilding abilities
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.