Theme

Language

Global EN
Sweden ENSV
India EN

Technical Lead

Technology, Data & Digital · Data, AI & Analytics · Data Engineering

In short

HCLTech is seeking a Data Modeler with 8-12 years of experience for roles in Bengaluru and Chennai. The position involves creating and maintaining data models, working with various teams, and ensuring compliance with data governance standards.

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.

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 platform such as: Oracle/SQL Server/PostgreSQL, AWS/Azure/GCP
  • Experience with modern data warehouse platforms: Snowflake/Redshift/BigQuery/Databricks.

Desired Qualifications

  • 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.
  • Exposure to data migration and cloud modernization projects.
  • Understanding of Data Mesh, Lakehouse, and Modern Data Architecture concepts.

Benefits

  • Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.

Skills

Data ModelingDatabase DesignData Warehouse ModelingDimensional ModelingStar SchemaSnowflake SchemaERwin Data ModelerER DiagramsData DictionariesMetadata RepositoriesSource-to-Target MappingSQLRDBMSNoSQLAWSAzureGCPSnowflakeRedshiftBigQueryDatabricksData AnalysisData MigrationInformaticaTalendDataStageSSISAzure Data FactoryLakehouse ArchitectureOLTPOLAPData GovernanceData QualityMetadata Management
#Data Modeler#Data Modeling#Database Design#Data Warehouse#Dimensional Modeling#Star Schema#Snowflake Schema#ERwin#ER Diagrams#Metadata#ETL#SQL#RDBMS#NoSQL#Cloud#AWS#Azure#GCP#Snowflake#Redshift#BigQuery#Databricks
HCLTech Logo

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

HCLTech Logo

Company

HCLTech

Job Posted

5 days ago

Employment Type

Full Time

Work mode

On Site

Experience Level

Mid-Senior

Locations

Chennai, India

Bengaluru, India

Applicants

Be an early applicant