Snowflake Data Engineer-4-8Y-PWC SDC

Snowflake + IICS (CAI+CDI)

Position: Snowflake + IICS (CAI+CDI)

Experience Required: 4-8 Years

Work Mode: Hybrid

Professional and Educational Background

Must Have Skills:

1) Snowflake

2) IICS Informatica Intelligent Cloud Services

3) CAI Cloud Application Integration AND CDI Cloud Data Integration

4) Python

• Strong hands-on experience with Snowflake Cloud Data Warehouse including data modeling, optimization, and query tuning.
• Expertise in Informatica Intelligent Cloud Services (IICS) especially Cloud Application Integration (CAI) and Cloud Data Integration (CDI) for data ingestion, transformation, orchestration, and integration tasks.
• Experience with API integration and middleware solutions using Informatica CAI.
• Proficient in Python programming to support automation, data processing, and advanced data transformations.
• Experience building and maintaining ETL/ELT pipelines integrating Snowflake with diverse sources via IICS.
• Strong SQL skills and expertise with Snowflake utilities like SnowSQL, SnowPipe, and managing data sharing.
• Experience developing and optimizing ETL/ELT pipelines, data ingestion workflows, and data transformation within cloud platforms.
• Effective communication skills to work within Agile teams and engage with business and technical stakeholders.
• Collaborate with data architects and business analysts to translate business requirements into technical specifications and design.
• Manage Snowflake data objects including tables, views, stages, streams, and tasks with focus on performance and cost optimization.
• Should be aware of deploying Snowflake features such as data sharing, events and lake-house patterns
• Should have experience with data security and data access controls and design
• Good to have AWS, Azure or GCP data storage and management technologies such as S3, Blob/ADLS and Google Cloud Storage
• Should have clear understanding of DW Lifecycle and contributed in preparing technical design documents and test plans
• Mentor junior developers and support knowledge sharing within the team.
• Good analytical & problem-solving skills
• Good communication and presentation skills

dhamma.b.bhawsagar@pwc.com

MB 8459621589