Website IT People Gulf
Job Details
Job Position – Data Modeler
Company Name – IT People Gulf
Duration : Long term
Notice : 30 days
Domain : Banking
Location : Dubai
-Minimum 5+ years of hands-on relational, dimensional modeling, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
-Experience and knowledge across different design patterns for Data Repositories such as Data Warehouse, Data Lake, Data Lakehouse, Data Mesh, Data Fabric and enterprise big data platforms including a full understanding of end-to-end data flow cycles
Core Skills Required:
– Expertise in data modeling principles / methods including conceptual, logical & physical Data Models
– Skills/Conceptual knowledge required to create optimal data models – Star & Snowflake Schemas, Data Vault Methodologies, Dimensional Modeling techniques (Slowly Changing, Fast Changing, Snapshot methodology, Degenerated dimensions etc.), Normalization & Denormalization, Surrogate Key Concepts etc.,
Technical Skills Required:
– Hands-on expertise on data modeling tools such as (SAP Power Designer, ERWin, ER/Studio etc.,)
– Knowledge in Industry Reference data models: IBM BFMDW, Teradata FSLDM, SAP FSDM etc.,
Best Practice / Design Standard Skills Required:
– Naming standards for Schemas, Data Objects & Data Attributes
– Identifying best fit data type & length for each data attribute as part of physical data model etc.,
– Leveraging common Master & Reference Data
– Ensures no redundancy in terms of data objects design based on nature of data (Master / Transactional / Reference)
– Ensuring Data Objects are designed to provide long-term stability.
· Robust knowledge of data, systems and querying tools like SAS/SQL and proven ability to quickly learn new systems and data environments.
· Preferred knowledge across all key facets of Data Management (Data Warehousing, BI, Data Governance, Data Quality, Master/Reference Data Management, Data Privacy Management, Application side Data Management and External Data Assets Management etc.,)
· Preferred knowledge in HADOOP, Oracle, PostgreSQL & SAP HANA database technology platforms
· Preferred knowledge in interacting with Data Governance tools (Informatica AXON-EDC-DEQ)
Email : shaloo.r@itpeoplegulf.com
Mention subject line – “Data Modeler”
Please go through the JD before sharing profile.
To apply for this job email your details to shaloo.r@itpeoplegulf.com