← Back to jobs

Brillio Logo
Data Specialist

Brillio

 

Bangalore, Karnataka, India

Posted On: Just posted
Experience: 8+ years
Availability: Onsite
Openings: 1
Category: Data Specialist
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) and build Snowflake data warehouse solutions. You own the end-to-end data integration lifecycle, from source ingestion to analytics-ready reporting.

This role is on-site.

Responsibilities

  • Design and optimize IICS Cloud Data Integration (CDI) workflows, including complex mappings, taskflows, and reusable components.
  • Build and manage Snowflake databases, schemas, views, and stages, leveraging streams, tasks, and time travel features.
  • Write and optimize advanced SQL queries and stored procedures for high-performance data processing and reporting.
  • Implement data loading strategies such as incremental loads, CDC, and SCD Type 1/Type 2 to ensure data integrity.
  • Troubleshoot ETL failures, resolve data quality issues, and collaborate with cross-functional teams for production deployments.

Required Skills

  • Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI).
  • Expertise in Snowflake architecture, including warehouses, stages, streams, and zero-copy cloning.
  • Advanced SQL development and query optimization skills.
  • Proficiency in ETL/ELT development, parameterization, and error handling.
  • Experience with Python or scripting languages for automation.
  • Knowledge of CI/CD and DevOps practices for pipeline deployment.
  • Proficiency with version control tools such as Git.
  • 8+ years of experience in data engineering or related roles.

Preferred Skills

  • Experience with AWS or Azure cloud services (S3/Blob Storage) for data ingestion.
  • Experience with Jenkins or Azure DevOps for automation.
  • Domain experience in Life Sciences or Pharmaceutical industry.

Education

Bachelor's degree

Related Jobs

No related jobs found

← Back to jobs