Technical Lead (IN)

HCLTech

8–12 yrs Bengaluru, Chennai Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

Data ModelingDatabase DesignData Warehouse ModelingDimensional ModelingStar SchemaSnowflake SchemaERwin Data ModelerER DiagramsData DictionariesMetadata RepositoriesSource-to-Target MappingQuery OptimizationRDBMSNoSQLAWSAzureGCPSnowflakeRedshiftBigQueryDatabricks

Good to Have

SQLData AnalysisData MigrationData ModernizationInformaticaTalendDataStageSSISAzure Data FactoryLakehouse ArchitectureModern Data PlatformsOLTPOLAPData GovernanceData QualityMetadata ManagementData MeshModern Data Architecture

Highlights

  • Actively hiring

More Details

RoleTechnical Lead (IN)
DepartmentData Modeler
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting