The Dignify Solutions, LLC
Location: Houston,TX, USA
Date: 2024-12-16T19:28:18Z
Job Description:
- 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.