Lead Consultant(Development)
Teknik, data och digitalt · Data, AI och analys · Data engineering
I korthet
Ansvarsområden
- Design, develop, and maintain data solutions using Snowflake and dbt.
- Build and optimize ELT/ETL pipelines for data ingestion and transformation.
- Develop reusable and modular dbt models, tests, macros, and documentation.
- Design and implement dimensional and analytical data models.
- Write and optimize complex SQL queries for performance and scalability.
- Implement data quality checks, testing, monitoring, and troubleshooting.
- Work with structured and semi-structured data within Snowflake.
- Perform Snowflake performance tuning and query optimization.
- Collaborate with business analysts, architects, BI teams, and upstream/downstream application teams.
- Support deployment and version control processes using Git and CI/CD practices.
- Troubleshoot data pipeline, transformation, and production issues.
- Follow data engineering standards, security practices, and development best practices.
Krav
- Strong hands-on experience with Snowflake.
- Strong working experience with dbt (Data Build Tool).
- Advanced knowledge of SQL.
- Good understanding of data warehousing, dimensional modeling, and ELT/ETL concepts.
- Experience developing scalable data transformation pipelines.
- Experience with Git/version control and CI/CD.
- Knowledge of Snowflake concepts such as warehouses, databases, schemas, stages, and performance optimization.
- Strong debugging, analytical, and problem-solving skills.
- 5+ years of overall Data Engineering / Data Warehousing experience.
- 2+ years of hands-on Snowflake and dbt experience preferred.
Önskade kvalifikationer
- Experience with Python for data engineering or automation.
- Exposure to cloud platforms such as Azure, AWS, or GCP.
- Experience with orchestration/integration tools such as Airflow, Azure Data Factory, or similar technologies.
- Understanding of data governance, security, and data quality practices.
- dbt certification or Snowflake certification is an added advantage.
Färdigheter
HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, 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 2022 totaled $12.1 billion. To learn how we can supercharge progress for…
Företag
HCLTechPublicerade jobb
för 2 veckor sedan
Anställningstyp
Heltid
Arbetsform
På plats
Erfarenhetsnivå
Mellannivå
Platser
Noida, India
Sökande
Ansök tidigt
