Primary Skills
IICS,Snowflake,SQL

Job requirements

Experience Range:

With at least 5 to 8 years of experience designing, developing, and maintaining data integration and data warehouse solutions using IICS and Snowflake.

Key Responsibilities:
- Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration processes
- Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and parameterization
- Develop complex mappings, mapping tasks, taskflows, and reusable components for effective data movement and transformation
- Build and maintain Snowflake data warehouse solutions, including databases, schemas, tables, views, and stages to support business analytics
- Write and optimize advanced SQL queries and Snowflake stored procedures to enable high-performance data processing and reporting
- Implement data loading strategies from diverse source systems into Snowflake, including incremental loads, Change Data Capture (CDC),



and Slowly Changing Dimensions (SCD) Type 1/Type 2
- Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity
- Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations
- Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions and support production deployments.

Required Skills:
- Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI)
- Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning
- Advanced SQL development and query optimization
- Proficiency in ETL/ELT development and data warehousing concepts
- Experience developing mappings, mapping tasks, and taskflows in IICS
- Implementation of parameter

📌 Data Specialist (Bengaluru)
🏢 Brillio
📍 Bengaluru