Snowflake + Informatica

Experience : 6-10yrs

Work location : Chennai and Bangalore

Work Mode : Hybrid

Notice Period : Imm - 30 days

Professional Summary

Experienced Data Integration and Data Warehouse professional with 8+ years of overall IT experience, including 5+ years of hands-on expertise in Informatica Intelligent Cloud Services (IICS) and Snowflake. Proven track record in designing, developing, and optimizing scalable ETL/ELT pipelines, cloud-based data integrations, and enterprise data migration solutions.

Strong expertise in implementing Snowflake data warehouse solutions, developing complex SQL queries, stored procedures, and UDFs, and integrating Snowflake with multiple enterprise applications and third-party systems. Extensive experience in Informatica IICS involving mappings, taskflows, workflows, scheduling, monitoring, and advanced transformations such as Aggregator, Lookup, Joiner, and Expression.

Skilled in migrating legacy Oracle PL/SQL and Informatica PowerCenter workloads to cloud-based IICS solutions. Experienced in building high-performance data pipelines, ensuring data quality, governance, integrity, security, and reliability throughout the data lifecycle. Familiar with cloud platforms including AWS, Azure, and GCP, along with storage services such as Amazon S3.

Key Skills

• Informatica Intelligent Cloud Services (IICS)

• Snowflake Data Warehouse

• ETL / ELT Development

• Data Integration & Data Migration

• Oracle PL/SQL

• Informatica PowerCenter Migration

• Snowflake SQL, Stored Procedures, UDFs

• Taskflows, Mappings, Workflows

• Advanced IICS Transformations:

• Aggregator

• Lookup

• Joiner

• Expression

• Data Quality & Data Governance

• Performance Tuning & Optimization

• Cloud Platforms: AWS, Azure, GCP

• Amazon S3

• Data Pipeline Development

• Job Scheduling & Monitoring

• Enterprise Application Integration

This profile aligns well with a Senior IICS Developer, Snowflake Developer, Data Integration Engineer, or ETL Lead role.