Job Summary

We are looking for an experienced Senior Data Engineer / Data Modeler with strong expertise in SQL, Teradata, and Data Modeling. The candidate will be responsible for designing scalable data models, developing and optimizing complex SQL solutions, and supporting enterprise data warehouse and analytics platforms.

Key Responsibilities

Design and maintain conceptual, logical, and physical data models for enterprise data platforms.Develop complex SQL queries, stored procedures, views, and data transformation logic.Design and optimize solutions on Teradata, including tables, indexes, partitions, statistics, and workload considerations.Perform SQL and Teradata performance tuning, identifying query bottlenecks and improving processing efficiency.Translate business requirements into appropriate data structures and technical designs.Work with large datasets across data warehouse, reporting, and analytics environments.Define data relationships, entities, attributes, keys, and appropriate normalization/denormalization strategies.Perform data analysis, profiling, mapping, and source-to-target mapping.Collaborate with business analysts, architects, ETL developers, reporting teams,



and application teams.Conduct technical/design reviews and ensure compliance with data architecture and modeling standards.Troubleshoot complex data issues and support root-cause analysis.Provide technical guidance to junior team members and contribute to delivery planning and estimation.Maintain technical documentation covering data models, mappings, database designs, and implementation decisions.

Skill Requirements

Strong hands-on expertise in SQL, including complex joins, subqueries, analytical/window functions, aggregations, and query optimization.Strong experience with Teradata Database and Teradata SQL.Strong understanding of Data Modeling:

- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Dimensional Modeling
- Star and Snowflake schemas
- Normalization and denormalization

Experience with Teradata performance tuning, indexing, statistics, partitioning, and explain-plan analysis.Good understanding of Data Warehousing and ETL/ELT concepts.Experience in data mapping, data lineage, and data quality validation.Exposure to modeling tools such as ERwin, ER/Studio, or equivalent is desirable.

Must Have Skill

Data Modelling,MS SQL,Teradata

Valuable to Have Skill

Other Requirements

📌 Senior Test Specialist (Bengaluru)
🏢 HCLTech
📍 Bengaluru