DE&A - Core - Cloud Data Engineering - Snowflake Developer

Qualifications

• Strong experience with Snowflake Data Cloud.
• Advanced SQL programming and query optimization.
• Experience with ETL/ELT development.
• Knowledge of Data Warehousing concepts and dimensional modeling.
• Experience with cloud platforms:
• AWS
• Azure
• Google Cloud Platform (GCP)
• Hands-on experience with:
• Snowpipe
• Streams & Tasks
• Dynamic Tables
• Materialized Views
• Cloning & Time Travel
• Stored Procedures
• User Defined Functions (UDFs)
• Experience with Python, Shell Scripting, or Java.
• Familiarity with dbt, Airflow, Azure Data Factory, Informatica, or Matillion.
• Bachelor's or master's degree in computer science, Information Technology, Engineering, or related field.
• 3+ years of experience in Data Engineering/Data Warehousing.
• 2+ years of hands-on Snowflake development experience.
• SnowPro Core Certification
• SnowPro Advanced Certifications
• Level
• 6+ years of IT experience
• 4+ years of Snowflake and Data Engineering experience
• Experience Level

Preferred Skills

• Performance tuning and cost optimization in Snowflake.
• Data Lake integration.
• BI tools knowledge (Power BI, Tableau, Looker).
• Git, CI/CD, and Agile methodologies.
• Experience with migration from on-premise data warehouses to Snowflake.
• Exposure to Data Mesh/Data Fabric architecture.
• Knowledge of Data Governance and Master Data Management (MDM).
• Experience working in Banking, Retail, Healthcare, Manufacturing, or Telecom domains.
• Key Competencies
• Analytical and problem-solving skills
• Communication and stakeholder management
• Performance optimization mindset
• Attention to detail
• Team collaboration and ownership

Qualifications

• Snowflake Certification is a plus:

Experience Level

Key Competencies

Responsibilities

• Azure Data Factory (ADF),dbt – primary skill
• Snowflake
• Oracle ERP or other ERP experience
• PL/SQL,ETL
• Design, develop, and maintain data pipelines using Snowflake.
• Build and optimize Snowflake databases, schemas, tables, views, and stored procedures.
• Develop ELT/ETL workflows using tools such as Informatica, Matillion, Talend, ADF, Airflow, or dbt.
• Implement data modeling techniques including Star Schema and Snowflake Schema.
• Develop and optimize complex SQL queries for data transformation and reporting.
• Integrate data from various sources including relational databases, APIs, cloud storage, and third-party applications.
• Monitor and troubleshoot Snowflake performance issues.
• Implement data security, governance, and access controls using Snowflake RBAC.
• Collaborate with Data Engineers, Business Analysts, Architects, and Stakeholders to understand business requirements.
• Ensure data quality, integrity, and compliance with organizational standards.
• Support CI/CD implementation and DevOps practices for data engineering projects.