Data Modeler

Job Details Need local profiles Hybrid role : 3 days onsite from client location.
Below is the JD for the Data Modeler:

Experience in any one of data modeling tool (currently client 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.
Demonstrated ability to understand, produce, and extend large and complex data models for operational and dimensional reporting data stores.
Knowledge of best practices and design principles building performance efficient models.
Ability to effectively present complex technical information to non-technical audiences and to senior decision-makers.
Experience coordinating information requirements of multiple departments, including assessment of usefulness, reliability, and cleanliness of data from several sources.
Strong SDLC knowledge, with excellent process and application system documentation skills.
Excellent presentation, communication skills.