Description

Key Skills: DB2, Databricks, MongoDB, Dimensional Modeling, Amazon Redshift, Mainframe, AWS, Star Schema, Snowflake Schema, NoSQL

Good to Have Skills: AI Augmentation/Vibe Coding knowledge, microservices architecture, real-time APIs, operational reporting, cloud-native migration experience.

Roles & Responsibilities:

• Translate complex, coupled Mainframe DB2 schemas into decoupled, domain-driven models optimized for AWS and Databricks.
• Analyze shared DB2 schemas to understand table locking, modification patterns, and batch dependencies.
• Design Target State conceptual, logical, and physical data models for the Unified Databricks & MongoDB Lakehouse.
• Design Slowly Changing Dimensions (SCD Type 1 & 2) for the Persistent Layer.
• Ensure data models support real-time APIs, microservices, and operational reporting requirements.

Experience Required: Experienced level position with expertise in dimensional modeling and cloud data warehouse structures

Key Skills

Education

Any Graduate