Experience : 6-10yrs

Work location : Chennai and Bangalore

Work Mode : Hybrid

Notice Period : Imm - 30 days

Qualified Summary

Experienced Data Integration and Data Warehouse skilled 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.

Robust 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.

📌 Snowflake + Informatica Bengaluru
🏢 Hexaware Technologies
📍 Bengaluru