Brillio
Website:
brillio.com
Company:
https://www.linkedin.com/company/brillio
Seniority: Not Applicable
Industries: Artificial Intelligence
Job details:
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:
- 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 efficient 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)
Click on Apply to know more.
