Data Modeler - Hybrid (Fulltime)

Experience in any one of data modeling tool (currently client is using SQL DBM)

Very good knowledge/experience in SQL

Knowledge on Dimensional Modeling

Additional skills - Experience in Snowflake Data Cloud

Min 10+ years of Total experience with minimum 5-6 years being Data Modeler or Data Architect.

Knowledge in both OLTP and OLAP Modelling.

Experience designing Data Marts and Data Warehouses on Enterprise Scale.

Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements.

Experience in ERWIN, SQL Database Modeler or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred.

Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity.

Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality.

Experience in Snowflake Data Cloud.

Additional experience in Oracle and SQL Server Databases preferred.

Experience in Informatica PowerCenter is a plus but not mandatory.

Work with business users on the requirement and build data model designs with scalable solution.