Python Snowflake DE_5+ years_Rotational shift_Pune

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 modern 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.