Zensar Technologies—DE&A - Core - Cloud Data Engineering - Snowflake Developer

Job description

Description: We are seeking a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. The ideal candidate should have strong expertise in data warehousing, ETL/ELT development, SQL optimization, cloud technologies, and data integration. Requirements: - 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. 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. Qualifications - 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. - Snowflake Certification is a plus: - SnowPro Core Certification - SnowPro Advanced Certifications Experience Level - 6+ years of IT experience - 4+ years of Snowflake and Data Engineering experience Nice to Have - 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 Responsibilities: - 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.