Technical Lead (IN)

HCL TechnologiesIN

Posted 2 days agoStill open, checked 4h ago

About the job

Job Summary

Job Title - Data Modeler

Experience - 8-12 Years

Relevant Experience - 5+ Years

Location – Bengaluru and Chennai

Key Responsibilities

• Create and maintain ER diagrams, data dictionaries, metadata repositories, and mapping documents.

• Work closely with Business Analysts, Data Architects, ETL Developers, and Project Teams to gather and analyze data requirements.

• Design dimensional models including Star Schema and Snowflake Schema for analytics and reporting solutions.

• Support ETL development teams by defining source-to-target mappings and validating transformation logic.

• Ensure compliance with data governance standards, naming conventions, and best practices.

Mandatory Skills

• Strong hands-on experience in Data Modeling and Database Design.

• Strong experience in Data Warehouse Modeling, Dimensional Modeling, Star Schema, and Snowflake Schema design.

• Experience with ERwin Data Modeler or equivalent data modeling tools.

• Experience in creating ER Diagrams, Data Dictionaries, Metadata Repositories and Source-to-Target Mapping documents.

• Experience in optimizing data models for query performance for large-volume transactional/data warehouse environments.

• Good knowledge of RDBMS/NoSql database platforms and cloud planform such as:

o Oracle/SQL Server/PostgreSQL

o AWS/Azure/GCP

• Experience with modern data warehouse platforms:

o Snowflake/Redshift/BigQuery/Databricks

Preferred Skills

• Strong SQL and data analysis skills.

• Experience in data migration and modernization projects.

• Knowledge of ETL tools such as Informatica, Talend, DataStage, SSIS, or Azure Data Factory.

• Understanding of Lakehouse Architecture and Modern Data Platforms.

• Experience with OLTP and OLAP environments.

• Exposure to Data Governance, Data Quality, and Metadata Management solutions.

Nice to Have

• Exposure to data migration and cloud modernization projects.

• Understanding of Data Mesh, Lakehouse, and Modern Data Architecture concepts.

Key Responsibilities

Create and maintain ER diagrams, data dictionaries, metadata repositories, and mapping documents.

• Work closely with Business Analysts, Data Architects, ETL Developers, and Project Teams to gather and analyze data requirements.

• Design dimensional models including Star Schema and Snowflake Schema for analytics and reporting solutions.

• Support ETL development teams by defining source-to-target mappings and validating transformation logic.

• Ensure compliance with data governance standards, naming conventions, and best practices.

Skill Requirements

• Strong hands-on experience in Data Modeling and Database Design.

• Strong experience in Data Warehouse Modeling, Dimensional Modeling, Star Schema, and Snowflake Schema design.

• Experience with ERwin Data Modeler or equivalent data modeling tools.

• Experience in creating ER Diagrams, Data Dictionaries, Metadata Repositories and Source-to-Target Mapping documents.

• Experience in optimizing data models for query performance for large-volume transactional/data warehouse environments.

• Good knowledge of RDBMS/NoSql database platforms and cloud planform such as:

o Oracle/SQL Server/PostgreSQL

o AWS/Azure/GCP

• Experience with modern data warehouse platforms:

o Snowflake/Redshift/BigQuery/Databricks

Other Requirements

• Strong SQL and data analysis skills.

• Experience in data migration and modernization projects.

• Knowledge of ETL tools such as Informatica, Talend, DataStage, SSIS, or Azure Data Factory.

• Understanding of Lakehouse Architecture and Modern Data Platforms.

• Experience with OLTP and OLAP environments.

• Exposure to Data Governance, Data Quality, and Metadata Management solutions.