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

· Very positive hands-on knowledge/experience with complex SQL queries

· Knowledge on Dimensional Modeling

· Additional skills - Experience in Snowflake Data Cloud

· Min 10+ years of Total experience with minimum 8-10 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.

· Strong communication and stakeholder managem

📌 Sr. Tech Lead (Chennai)
🏢 TalentOla
📍 Chennai