IN-Senior Associate_Snowflake Developer_Data & Analytics_Advisory_PAN India

*Why PWC

about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. "

Responsibilities: 

• Knowledge of SQL language and cloud-based technologies 

• Data warehousing concepts, data modeling, metadata management 

• Data lakes, multi-dimensional models, data dictionaries 

• Migration to AWS or Azure Snowflake platform 

• Performance tuning and setting up resource monitors 

• Snowflake modeling – roles, databases, schemas 

• SQL performance measuring, query tuning, and database tuning 

• ETL tools with cloud-driven skills 

• Integration with third-party tools 

• Ability to build analytical solutions and models 

• Coding in languages like Python 

• Hadoop, Spark, and other warehousing tools 

• Managing sets of XML, JSON, and CSV from disparate sources 

• Snowflake warehousing, architecture, processing, administration 

• Data ingestion into Snowflake 

• Enterprise-level technical exposure to Snowflake applications 

• Proven track record of data migration and optimization within Snowflake 

• Ability to translate business needs into technical specifications 

• Design and implement scalable and efficient data storage solutions using Snowflake. 

• Write, optimize, and troubleshoot SQL queries within the Snowflake environment. 

• Integrate Snowflake with various data sources and third-party tools. 

• Ensure data security and compliance with industry standards. 

• Collaborate with cross-functional teams to meet data-driven business objectives. 

• Stay updated with the latest Snowflake features and best practices. 

• Proficient in SQL and familiar with ETL processes 

• Experience with data modeling and cloud computing environments 

• Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning 

• Understanding of data compliance and security best practices 

• Experience in performance tuning and cost optimization in a cloud data platform 

• Familiarity with BI tools integration, such as Tableau. 

Mandatory skill sets: 

Snowflake, DBT & SQL 

Preferred skill sets: 

Snowflake, DBT & SQL 

Years of experience required: 

3-10 Years 

Education qualification: 

BE, B.Tech, MCA, M.Tech