Technical Lead
Technology, Data & Digital · Data, AI & Analytics · Data Engineering
In short
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
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…
Company
HCLTechJob Posted
4 days ago
Employment Type
Full Time
Work mode
On Site
Experience Level
Mid-Senior
Locations
Chennai, India
Bengaluru, India
Applicants
Be an early applicant
