đź“Š Job Highlights
Experience
15 - 22 Years
Domain
Cloud Architecture
Domain Experience
8 Years
Authorization
India
đź’» Key Skills
data modellingdatabase architectureOracle DatabaseSQLdata warehousesdata platformsStar/Snowflake schemasdata integrationETL/ELTsource-to-target mappingdata governancemetadatadata lineageOCI data servicesAutonomous Data Warehouse Object Storage Data Integration Data Flow GoldenGate
Job Description
Key Responsibilities
Design Conceptual, Logical and Physical Data Models for enterprise applications and data platforms.
Analyse business requirements and translate them into appropriate data structures and models.
Design relational and dimensional models for:
Operational systems
Data warehouses
Data marts
Reporting and analytics
Customer 360
Regulatory reporting
Develop enterprise-wide data entities, attributes, relationships and business definitions.
Define primary keys, foreign keys, indexes, constraints and data relationships.
Design data models for Oracle Database, Autonomous Database and OCI-based data platforms.
Support data lake/lakehouse architecture using OCI services such as:
Object Storage
Autonomous Data Warehouse
Data Integration
Data Flow
GoldenGate
Streaming
Define data ingestion and transformation requirements.
Design source-to-target mappings and transformation rules.
Develop data dictionaries and metadata definitions.
Identify data duplication, inconsistencies and data-quality issues.
Define data lineage and traceability across source, transformation and target systems.
Work with data engineers to ensure physical implementation aligns with the logical model.
Work with application architects to ensure transactional data models support application requirements.
Support ETL/ELT and data migration design.
Define data partitioning, indexing and performance optimisation strategies.
Support master data and reference data design.
Ensure models comply with enterprise data governance, security, privacy and regulatory requirements.
Collaborate with business SMEs, data architects, application architects, developers and BI/analytics teams.
Required Skills
Strong experience in data modelling and database architecture.
Strong Oracle Database knowledge.
Experience with conceptual, logical and physical data modelling.
Strong SQL skills.
Experience designing enterprise data warehouses and/or data platforms.
Experience with dimensional modelling — Star/Snowflake schemas.
Note: This Requirement is either from the Multicloud4u or from its global partner. Please contact the recruiter directly for further information.
