HCLTech•49m ago
Indeed
Senior Technical Specialist
Chennai, Tamil Nadu
Senior Level
Full Job Description
Role Overview
The Senior Technical Specialist will lead the design of scalable ELT pipelines on Snowflake while maintaining legacy MS SQL Server environments. You'll build Python-based automation frameworks to orchestrate data ingestion and transformation, ensuring high performance through rigorous query optimization.
Key Responsibilities & Skills
- Data Architecture: Design robust dimensional (star/snowflake), Data Vault models on Snowflake with full lineage tracking using DBT for modular development, testing, and documentation.
- Migrations & Optimization: Lead the migration of legacy SQL Server workloads to Snowflake, including warehouse sizing, clustering, resource monitoring, and cost management strategies.
- Pipeline Orchestration: Develop Python scripts using Airflow/Airbyte for complex data ingestion workflows across distributed systems.
- Certifications & Governance: Implement CI/CD pipelines with Git version control while adhering to best practices in DBT macros and tests, ensuring compliance with strict security standards.
Company
HCLTech
HCLTech is a global technology company headquartered in India, offering enterprise software solutions and services across cloud computing, cybersecurity, mobility, digital commerce, IoT, data analytic...
Chennai, Tamil Nadu
Posted on Indeed
Practice this interview
A voice mock interview for Senior Technical Specialist at HCLTech, with questions from this job description and your resume, and a scored report afterwards.
Set up interview