IN-Sr Associate_ Snowflake Data Engineer_ D&A_ Advisory_ Pune

Job Description & Summary: A career within…. A career within Data and Analytics services will provide you with the opportunity to help organizations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organizational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organizations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.  

Responsibilities: 

•  Design, develop, and maintain ETL/ELT pipelines using Snowflake and cloud services.  

• Build and optimize Snowflake databases, schemas, tables, views, stages, file formats, streams, tasks, and stored procedures.  

• Implement data ingestion frameworks using Snowpipe, COPY INTO, CDC, Streams, and Tasks.  

• Develop transformation logic using SQL, DBT, and Python.  

• Perform data migration from legacy platforms (Oracle, SQL Server, etc.) to Snowflake.  

• Design and maintain Bronze, Silver, and Gold data layers.  

• Implement security controls including RBAC, row-level security, masking policies, and governance standards.  

• Optimize Snowflake warehouse performance, query execution, clustering, and cost utilization.  

• Support reporting and analytics platforms such as Power BI and Tableau.  

• Perform source-to-target validation, data reconciliation, and data quality checks.  

• Collaborate with business stakeholders, Data Analysts, and BI teams to deliver analytics-ready datasets. 

Mandatory skill sets: 

• Advanced SQL  

• Data Warehousing Concepts  

• SCD Type 1 & Type 2  

• Data Modeling  

• ETL/ELT Development  

• Data Migration 

Preferred skill sets: 

• Knowledge of real-time data ingestion and CDC.  

• Experience with DBT and Airflow orchestration. 

Years of experience required: 

4-8 

Education Details 

B.Tech / M.Tech / MBA / MCA