HI,

Greetings for the day !!!

We at HCL are looking Snowflake Data Engineers

Location: Pune

Shifts: 2 PM - 1130 PM (Rotational Shifts)

If interested reach us on [email protected]

Provide us the details below:

Total years of exp:

Exp in Snowflake:

Exp in Python:

Exp in Cosmos/Claude:

Current CTC:

Expected CTC:

Notice Period:

Current location:

Preferred location:

Detailed Responsibilities

- Design, develop, and maintain data engineering and data science solutions using Snowflake, Python, and AI/Cloud platforms on AWS.
- Build and optimize Snowflake applications, utilizing Snowflake AI/Cortex platform features such as Cortex agents, search, and LLM, with a focus on context enrichment via Prompts or Retrieval-Augmented-Generation methods.
- Implement robust data modeling techniques and manage unstructured data sources from cloud-based data lakes (e.g., AWS S3).
- Develop, test, and deploy Python applications, including AWS Lambda functions, leveraging best practices in object-oriented programming, data structures (Pandas, DataFrames), and server-side concurrency/multithreading.
- Utilize up-to-date development tools (VS Code, Anaconda) and version control systems (Git, Bitbucket).
- Employ frameworks such as SQLAlchemy for object-relational mapping and ensure clean, maintainable engineering code.
- Deploy web applications and microservices on AWS using Docker containers or Kubernetes, integrating CI/CD pipelines for efficient delivery.
- Manage Snowflake account hierarchy models,



account-role-permissions, and facilitate secure internal data sharing.
- Collaborate with cross-functional teams to ensure timely, high-quality, and cost-effective delivery of assigned projects.
- Leverage Data Build Tool (DBT) and Apache Airflow for data pipeline orchestration, as needed.

Skill Requirements

Must Have:

- 47 years of hands-on experience in data engineering and data science projects, particularly using Snowflake and AI Cloud platforms on AWS.
- Strong proficiency in Python development, including experience with unit testing frameworks.
- In-depth knowledge of Snowflake, including Snowpipe, Snowpark, and AI/Cortex platform features.
- Experience with data modeling, data structures, and object-oriented programming.
- Proficiency in Oracle PL/SQL for data integration and processing.
- Experience with AWS cloud services and deploying serverless/cloud-native applications.
- Familiarity with version control (Git, Bitbucket) and modern development environments (VS Code, Anaconda).
- Understanding of deploying applications using Docker/Kubernetes and implementing CI/CD pipelines.

Good to Have:

- Experience with Apache Airflow and Data Build Tool (DBT) for workflow orchestration and data pipeline management.
- Exposure to large language models (LLMs) and context enrichment techniques.
- Knowledge of Snowflake account hierarchy and role-based access control.
- Prior experience in data sharing strategies within cloud data platforms.

📌 Python Snowflake DE_5+ years_Rotational shift_Pune (Pune)
🏢 HCLTech
📍 Pune