Senior Data Engineer, Borivali

Job Description We are seeking a Senior Data Engineer (Snowflake&Matillion) with deep Snowflake expertise to support and enhance our cloud data platform. This role demands advanced SQL proficiency , hands-on experience with Snowflake data warehousing , and strong capability in building, optimizing, and maintaining ELT pipelines using Matillion . The ideal candidate must be comfortable handling intermediate to complex data transformations independently , optimizing performance at scale, and driving best practices across the data layer.Core Technical Responsibilities Advanced SQL Development Design and implement complex SQL transformations using: CTEs, subqueries, window functions, analytical functions Query refactoring for performance and readability Optimize SQL for large-volume datasets and high-concurrency workloadsPerform query performance tuning and troubleshooting in Snowflake Review and refactor existing SQL logic to improve efficiency and maintainability Snowflake Data Engineering Develop and manage Snowflake objects , including: Schemas, tables (transient, temporary), views, materialized views Stages, file formats, internal/external storage integrationsImplement and optimize: Snowflake virtual warehouses (size, auto-suspend/resume, cost optimization) Clustering and micro-partition awareness Matillion ELT Development Design, develop, and maintain Matillion pipelines for ELT workflows Implement parameterized, reusable, and scalable job designsManage job dependencies, orchestration, and error handling Optimize ELT workflows for performance and reliability in Snowflake Data Modeling&Architecture Design and support dimensional and analytical data models (fact/dimension structures) Handle intermediate to advanced transformation logic Ensure data quality, consistency, and accuracy across layers Collaborate with downstream consumers (BI, reporting, analytics teams) Required Skills&Experience Must-Have 8+ years of hands-on SQL development with proven advanced-level capability Strong experience with Snowflake in production environments Strong experience using Matillion for ELT development Deep understanding of: Data warehousing concepts ELT vs ETL patterns Performance tuning and optimizationAbility to work independently on complex tasks with minimal supervision Strong debugging, problem-solving, and analytical skills Good-to-Have Experience with cloud platforms (AWS / Azure / GCP) Exposure to CI/CD for data pipelines Experience mentoring or reviewing code for junior developersFamiliarity with data governance, auditing, or data quality frameworks