Senior Test Specialist (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking an experienced Data Engineer or Data Modeler with robust SQL, Teradata, and Data Modeling expertise. This role involves architecting scalable data models, developing advanced SQL solutions, and supporting enterprise data warehousing and analytics platforms.

Focus areas include designing comprehensive data models, crafting complex SQL logic, and optimizing performance on Teradata. You will translate business needs into effective data structures and contribute to critical data initiatives.

Responsibilities

Key responsibilities encompass designing and maintaining conceptual, logical, and physical data models. You will develop intricate SQL queries, stored procedures, and data transformation logic, alongside optimizing Teradata solutions for tables, indexes, and partitions.

Translate business requirements into technical data designs, perform data analysis, and collaborate with cross-functional teams. Troubleshooting complex data issues and providing technical guidance to junior members are also integral parts of this role.

Qualifications

Essential qualifications include strong SQL proficiency, encompassing complex joins, subqueries, analytical functions, and query optimization. Significant experience with Teradata Database and Teradata SQL is required.

A solid grasp of Data Modeling principles, including conceptual, logical, physical, dimensional modeling (star/snowflake schemas), normalization, and denormalization, is crucial. Experience in Teradata performance tuning and a good understanding of Data Warehousing and ETL/ELT concepts are also necessary.

Essential Skills

SQLTeradataData ModelingConceptual Data ModelLogical Data ModelPhysical Data ModelDimensional ModelingStar SchemaSnowflake SchemaNormalizationDenormalizationTeradata Performance TuningIndexingStatisticsPartitioningExplain Plan AnalysisData WarehousingETLELTData MappingData LineageData Quality

Good to Have

ERwinER/Studio

Highlights

  • Actively hiring

More Details

RoleSenior Test Specialist (IN)
DepartmentData Engineering
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Test Specialist (IN) at HCLTech | SkillMX | SkillMX