Snowflake Developer

<h2>This role is for one of the Weekday's clients</h2><h2>Min Experience: 5+ years</h2><h2>Location: Pune, Maharashtra, India, Bengaluru, Karnataka, India</h2><h2>JobType: full-time</h2><h2>Key Responsibilities</h2><h2>Shift- Flexibility to shift working</h2><h2>Project Type- L3 Support</h2><h2>Requirements</h2><h2>Development Responsibilities</h2><ul>
<li>Design and develop scalable data pipelines and modern data architectures using Snowflake.</li>
<li>Lead migration initiatives from legacy databases to Snowflake.</li>
<li>Build and optimize ELT frameworks using DBT.</li>
<li>Develop and orchestrate workflows using Apache Airflow.</li>
<li>Design and implement data models, including Star Schema and Snowflake Schema.</li>
<li>Develop ingestion pipelines for structured and semi-structured data.</li>
<li>Create reusable frameworks for data validation, reconciliation, auditing, and monitoring.</li>
<li>Optimize Snowflake objects, including:</li>
<ul>
<li>Virtual Warehouses</li>
<li>Clustering Keys</li>
<li>Materialized Views</li>
<li>Streams &amp; Tasks</li>
<li>Dynamic Tables</li>
</ul>
<li>Develop technical design documents and migration runbooks.</li>
<li>Perform code reviews and enforce engineering best practices.</li>
</ul><h2>Migration Responsibilities</h2><ul>
<li>Assess and migrate data from legacy platforms, including:</li>
<ul>
<li>Oracle</li>
<li>SQL Server</li>
<li>Teradata</li>
<li>Netezza</li>
<li>DB2</li>
<li>SAP HANA</li>
<li>On-Prem Data Warehouses</li>
</ul>
<li>Perform source system analysis and database rationalization.</li>
<li>Design migration strategies, including:</li>
<ul>
<li>Full Data Loads</li>
<li>Incremental Loads</li>
<li>CDC (Change Data Capture)</li>
<li>Historical Data Migration</li>
</ul>
<li>Conduct data reconciliation and validation during migration.</li>
<li>Optimize transformed workloads for Snowflake architecture.</li>
<li>Execute cutover planning and post-migration stabilization.</li>
</ul><h2>Good to have:</h2><h2>AMS / Production Support Responsibilities</h2><ul>
<li>Provide L3 support for Snowflake data platforms and pipelines.</li>
<li>Monitor and manage production data workloads.</li>
<li>Troubleshoot data failures, performance issues, and pipeline disruptions.</li>
<li>Perform root cause analysis (RCA) and implement permanent fixes.</li>
<li>Support incident, problem, change, and release management activities.</li>
<li>Work closely with business users and stakeholders to resolve production issues.</li>
<li>Ensure adherence to SLA and operational support commitments.</li>
<li>Participate in production releases and deployment activities.</li>
</ul><h3>Must-have skills</h3><h2>Snowflake, DBT, Airflow</h2><h3>Good-to-have skills</h3><h2>Informatica, SQL, Datastage</h2>