Data Modeler
- Role Overview Translate complex, coupled Mainframe DB2 schemas into decoupled, domain-driven models optimized for AWS and Databricks.
- Key Responsibilities
- 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.
- Required Skills
- Expertise in dimensional modeling (Star/Snowflake) and NoSQL document modeling (MongoDB).
- Familiarity with cloud data warehouse structures like Amazon Redshift.
- Understanding of Mainframe DB2 structures and migration to cloud-native formats.
- AI Augmentation/Vibe Coding knowledge required
Virtusa is a global product and platform engineering services company that makes experiences better with technology. We help organizations grow faster, more profitably, and more sustainably by reimagining enterprises through domain-driven solutions. We combine strategy, design, and engineering, backed by unmatched expertise at the intersection of industry, business, and technology to generate real-world business impact for clients.
Headquartered in Massachusetts with global delivery centers, Virtusa provides a broad range of services, solutions, and assets, including strategy and design, AI advisory and services, digital engineering, data and analytics, digital assurance, cloud and security, cx transformation and managed services across industries such as financial services, healthcare, communications, media, entertainment, travel, manufacturing, and technology.
