Senior Test Specialist
India
Apply now
Job Description
Senior Test Specialist
Bengaluru, Karnataka

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.

Other Requirements
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, 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 2026 totaled $14.8 billion.