Senior Consultant | Snowflake | Chennai | Engineering | Data Modernization & Migration (Chennai, IN)

Deloitte

5–8 yrs Chennai Full Time Work from office
Deloitte logo
Posted : today
Actively hiring

Job description

Join our dynamic Technology & Transformation practice, a hub for unlocking the full potential of vast data landscapes. We empower companies to manage diverse data sources and transform them into actionable intelligence for informed decision-making.

Our expertise spans business intelligence, data management, performance management, and cutting-edge analytics, including big data, cloud, cognitive, and machine learning technologies. This role focuses on Data Modernization & Migration within our Engineering domain.

Responsibilities

Design, develop, and maintain robust data pipelines and data warehouse solutions utilizing Snowflake. Craft and optimize complex SQL queries, stored procedures, views, and tasks. Implement ELT/ETL processes using industry-leading tools like Informatica, Matillion, DBT, or Azure Data Factory. Build and maintain scalable Snowflake data models, including Star and Snowflake Schema designs.

Enhance Snowflake performance through strategic clustering, partitioning, query tuning, and warehouse sizing. Implement comprehensive data security, governance, role-based access control (RBAC), and data masking policies. Develop sophisticated data integration solutions for both structured and semi-structured data formats (JSON, XML, Avro, Parquet).

Collaborate closely with business analysts, architects, and fellow data engineers to translate requirements into scalable solutions. Monitor and troubleshoot data loads, workflows, and production issues, ensuring adherence to data quality, security, and compliance standards. Actively participate in code reviews, release management, and deployment processes. Create detailed technical documentation and facilitate knowledge transfer activities.

Qualifications

We are seeking a seasoned Snowflake Developer with 5 to 8 years of hands-on experience in Data Warehousing, ETL/ELT development, and cloud-based data platforms. The ideal candidate will possess deep expertise in Snowflake, SQL, data modeling, and cloud technologies.

Key qualifications include a strong understanding of designing, developing, and optimizing scalable data solutions that effectively support business analytics and reporting needs. A Bachelor's or Master's degree in a relevant field such as B.Tech, M.Tech, B.E., M.E., B.Sc., M.Sc., B.Com, M.Com, MBA, PGDM, BCA, or MCA is required.

Essential Skills

SnowflakeSQLData WarehousingETLELTData ModelingCloud TechnologiesData PipelinesStored ProceduresViewsTasksInformaticaMatillionDBTAzure Data FactoryStar SchemaSnowflake SchemaPerformance OptimizationClusteringPartitioningQuery TuningWarehouse SizingData SecurityGovernanceRole-Based Access Control (RBAC)Data MaskingData IntegrationJSONXMLAvroParquetCode ReviewsRelease ManagementDeployment ProcessesTechnical DocumentationKnowledge Transfer

Highlights

  • Actively hiring

More Details

RoleSenior Consultant | Snowflake | Chennai | Engineering | Data Modernization & Migration (Chennai, IN)
DepartmentEngineering
Employment TypeFull Time, Work from office

About the Company

Deloitte logo

Deloitte

IT Consulting

Senior Consultant | Snowflake | Chennai | Engineering | Data Modernization & Migration (Chennai, IN) at Deloitte | SkillMX | SkillMX