18 Nov
|
HCLTech
|
Chennai
Job Summary
"Task Description: Data Engineer / Software Engineer with strong hands-on experience in Snowflake, Teradata, SQL, ETL/ELT, and Stored Procedures.
Experience:
5–10 years of experience in Data Engineering / Software Engineering, with strong enterprise data warehouse development and production support experience.
Key Responsibilities:
- Develop and maintain complex Snowflake and Teradata Stored Procedures.
- Design and develop data pipelines and ETL/ELT processes.
- Develop complex SQL, views, tables, and transformation logic.
- Build staging, integration, target, and presentation data layers.
- Implement incremental loads, reload logic, reconciliation, and data-quality checks.
- Optimize Snowflake queries, warehouses, and credit consumption.
- Work with Azure Data Factory (ADF), SFTP, and Python as required.
- Develop data models including fact, dimension, and aggregate tables.
- Support Power BI/Cognos reporting requirements.
- Troubleshoot production issues and perform root-cause analysis.
- Follow software engineering practices including Git, testing, code reviews, and deployment.
Required Skills:
- Strong Snowflake Stored Procedure development
- Strong Teradata Stored Procedure / SQL development
- Advanced SQL
- Snowflake & Teradata
- ETL/ELT
- Data Modeling
- Performance Tuning
- Python
- Azure Data Factory"
Key Responsibilities
"Task Description: Data Engineer / Software Engineer with strong hands-on experience in Snowflake, Teradata, SQL, ETL/ELT,
and Stored Procedures.
Experience:
5–10 years of experience in Data Engineering / Software Engineering, with strong enterprise data warehouse development and production support experience.
Key Responsibilities:
- Develop and maintain complex Snowflake and Teradata Stored Procedures.
- Design and develop data pipelines and ETL/ELT processes.
- Develop complex SQL, views, tables, and transformation logic.
- Build staging, integration, target, and presentation data layers.
- Implement incremental loads, reload logic, reconciliation, and data-quality checks.
- Optimize Snowflake queries, warehouses, and credit consumption.
- Work with Azure Data Factory (ADF), SFTP, and Python as required.
- Develop data models including fact, dimension, and aggregate tables.
- Support Power BI/Cognos reporting requirements.
- Troubleshoot production issues and perform root-cause analysis.
- Follow software engineering practices including Git, testing, code reviews, and deployment.
Required Skills:
- Solid Snowflake Stored Procedure development
- Strong Teradata Stored Procedure / SQL development
- Advanced SQL
- Snowflake & Teradata
- ETL/ELT
- Data Modeling
- Performance Tuning
- Python
- Azure Data Factory"
Skill Requirements
Must Have Skill
Azure Data Factory (ADF),Data Modelling,ETL Tool - Others,Snowflake,SQL Proficiency,Teradata
Good to Have Skill
Other Requirements
📌 Senior Technical Lead (Chennai)
🏢 HCLTech
📍 Chennai