Snowflake Developer

This role is for one of our clientsIndustry: IT Services and IT ConsultingSeniority level: Mid-Senior levelMin Experience: 5+ years

Location: Pune, Maharashtra, India, Bengaluru, Karnataka, IndiaJobType: full-timeKey ResponsibilitiesShift- Flexibility to shift workingProject Type- L3 SupportWe may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information.

These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.Development Responsibilities Design and develop scalable data pipelines and modern data architectures using SnowflakeLead migration initiatives from legacy databases to SnowflakeBuild and optimize ELT frameworks using DBTDevelop and orchestrate workflows using Apache AirflowDesign and implement data models, including Star Schema and Snowflake SchemaDevelop ingestion pipelines for structured and semi-structured dataCreate reusable frameworks for data validation, reconciliation, auditing, and monitoringOptimize Snowflake objects, including:Virtual WarehousesClustering KeysMaterialized ViewsStreams & TasksDynamic TablesDevelop technical design documents and migration runbooksPerform code reviews and enforce engineering best practicesMigration Responsibilities Assess and migrate data from legacy platforms, including:OracleSQL ServerTeradataNetezzaDB2SAP HANAOn-Prem Data WarehousesPerform source system analysis and database rationalizationDesign migration strategies, including:Full Data LoadsIncremental LoadsCDC (Change Data Capture)Historical Data MigrationConduct data reconciliation and validation during migrationOptimize transformed workloads for Snowflake architectureExecute cutover planning and post-migration stabilizationGood to have: AMS / Production Support ResponsibilitiesProvide L3 support for Snowflake data platforms and pipelinesMonitor and manage production data workloadsTroubleshoot data failures, performance issues, and pipeline disruptionsPerform root cause analysis (RCA) and implement permanent fixesSupport incident, problem, change, and release management activitiesWork closely with business users and stakeholders to resolve production issuesEnsure adherence to SLA and operational support commitmentsParticipate in production releases and deployment activitiesMust-have skillsSnowflake, DBT, AirflowGood-to-have skillsInformatica, SQL, Datastage