n

Primary SkillsIICS,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 parameterization and error handling in ETL pipelines
- Scheduling and automation of data integration workflows
- Design and management of incremental and full data loads including SCD and CDC patterns.

Preferred Skills

- Experience with AWS or Azure cloud services for data integration and storage
- Knowledge of AWS S3 or Azure Blob Storage for data ingestion
- Familiarity with CI/CD and DevOps practices for ETL pipeline deployment
- Proficiency in Python or scripting languages for automation
- Experience with version control and automation tools such as Git, Jenkins, or Azure DevOps 6. Domain experience in Life Sciences or Pharmaceutical industry

Desired Qualifications

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline
- Certification in Snowflake or Informatica Cloud Data Integration (preferred)
- Certification in AWS or Azure cloud platforms (preferred)

n

📌 Data Specialist890 (Bengaluru)
🏢 Brillio
📍 Bengaluru