Snowflake Data engineer

People Prime Worldwide; Kolkata Metropolitan Area; On-site; INR 900,000 - 1,500,000; Full time

Job summary

People Prime Worldwide is seeking a skilled Snowflake Data Engineer to design and optimize scalable data pipelines. You will implement complex SQL, build ETL/ELT workflows, and leverage cloud services across AWS/Azure/GCP for ingestion and processing.

The role requires strong Snowflake proficiency, advanced SQL, and experience with data warehousing concepts. Knowledge of Python is preferred and collaboration with analysts and stakeholders is essential.

Qualifications

• Strong hands-on experience with Snowflake.
• Advanced SQL and database concepts.
• Experience with ETL/ELT pipelines.
• Strong understanding of data warehousing and dimensional modeling.
• Experience with Python preferred.

Responsibilities

• Design and develop scalable data pipelines using Snowflake.
• Develop complex SQL queries, stored procedures, views, and data transformations.
• Build and maintain ETL/ELT pipelines using Informatica, Talend, Matillion or Azure Data Factory.
• Work with AWS/Azure/GCP cloud services for data ingestion and processing.
• Implement data modeling, data warehousing, and dimensional modeling.
• Optimize Snowflake queries, warehouses, and data-processing workloads.
• Ensure data quality, security, governance, and reliability.
• Collaborate with data analysts, architects, and business stakeholders.
• Troubleshoot production data issues and performance problems.

Skills

Snowflake

SQL

ETL/ELT

Data Warehousing

Dimensional Modeling

Python

AWS/GCP/Azure

Git

CI/CD

Problem Solving

Tools

Informatica

Talend

Matillion

Azure Data Factory

Job description

• Design and develop scalable data pipelines using Snowflake.
• Develop complex SQL queries, stored procedures, views, and data transformations.
• Build and maintain ETL/ELT pipelines using tools such as Informatica, Talend, Matillion, or Azure Data Factory.
• Work with AWS/Azure/GCP cloud services for data ingestion and processing.
• Implement data modeling, data warehousing, and dimensional modeling.
• Optimize Snowflake queries, warehouses, and data-processing workloads.
• Implement Snowflake features such as Streams, Tasks, Time Travel, Snowpipe, and Dynamic Tables.
• Ensure data quality, security, governance, and reliability.
• Collaborate with data analysts, architects, and business stakeholders.
• Troubleshoot production data issues and performance problems.

Required Skills

• Strong hands-on experience with Snowflake.
• Advanced SQL and database concepts.
• Experience with ETL/ELT pipelines.
• Strong understanding of data warehousing and dimensional modeling.

Experience With Python Preferred.

• Experience with AWS/Azure/GCP.
• Knowledge of Git and CI/CD.
• Strong analytical and problem-solving skills.