Senior Test Specialist

HCLTech; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

HCL Technologies Limited is seeking an experienced Senior Data Engineer / Data Modeler to design scalable data models and optimize SQL solutions across enterprise data warehouse and analytics platforms in Bengaluru. You will translate business requirements into efficient data structures, collaborate with ETL, reporting teams, and analysts, and guide junior members.

The role emphasizes hands-on SQL, Teradata proficiency, and robust data modeling across conceptual, logical, and physical layers to

Qualifications

• 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, Logical, Physical, Dimensional, Star/Snowflake, and normalization/denormalization.

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 Teradata solutions, including tables, indexes, partitions, statistics, and workload considerations.

Skills

SQL

Teradata

Data Modeling

Performance Tuning

Data Warehousing

ETL/ELT concepts

Data profiling

Tools

ERwin

ER/Studio

Job description

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.