n

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:
1. Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration processes
2. Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and parameterization
3. Develop complex mappings, mapping tasks, taskflows, and reusable components for effective data movement and transformation
4. Build and maintain Snowflake data warehouse solutions, including databases, schemas, tables, views, and stages to support business analytics
5. Write and optimize advanced SQL queries and Snowflake stored procedures to enable high-performance data processing and reporting
6. 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
7. Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity
8. Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations
9. Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions and support production deployments.
Required Skills:
1. Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI)
2. Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning
3. Advanced SQL development and query optimization
4. Proficiency in ETL/ELT development and data warehousing concepts
5. Experience developing mappings, mapping tasks, and taskflows in IICS
6. Implementati

📌 Data Specialist (Bengaluru)
🏢 Brillio
📍 Bengaluru