Technical Lead (IN)
HCLTech
HCLTech
Seeking a skilled Data Modeler with 8-12 years of experience, including at least 5 years of relevant expertise, to join our team. This role involves designing and maintaining robust data models to support analytics and reporting solutions. You will collaborate with cross-functional teams to define data requirements and ensure adherence to data governance standards.
Key responsibilities include developing and managing ER diagrams, data dictionaries, and metadata repositories. You will also create comprehensive mapping documents and work closely with Business Analysts, Data Architects, and ETL Developers to gather and interpret data requirements. A core part of the role involves designing dimensional models, such as Star and Snowflake schemas, tailored for analytics and reporting. Additionally, you'll support ETL teams by defining source-to-target mappings and validating transformation logic, all while ensuring compliance with data governance, naming conventions, and best practices.
Ideal candidates possess strong hands-on experience in Data Modeling and Database Design, with a deep understanding of Data Warehouse and Dimensional Modeling techniques like Star and Snowflake schemas. Proficiency with data modeling tools like ERwin is essential. You should also have experience creating ER diagrams, data dictionaries, metadata repositories, and source-to-target mapping documents. Experience in optimizing data models for performance in large-volume environments is required. A good grasp of RDBMS/NoSQL database platforms (Oracle, SQL Server, PostgreSQL) and cloud platforms (AWS, Azure, GCP) is necessary, along with experience in modern data warehouse platforms such as Snowflake, Redshift, BigQuery, or Databricks.
HCLTech
IT Consulting