n

Primary Skills
IICS,Snowflake,SQL

Job requirements

Experience Range:

With at least 3 to 5 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 productive 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 II

📌 Senior Data Engineer (Bengaluru)
🏢 Brillio
📍 Bengaluru