Data Specialist - R01565207

Brillio 2; Bengaluru; On-site; INR 1,600,000 - 2,100,000; Full time

Job summary

Brillio is seeking an experienced Data Engineer with strong expertise in Informatica IICS and Snowflake to design, build, and optimize scalable data pipelines for healthcare and life sciences data. You will implement ingestion from diverse sources, optimize Snowflake performance, ensure data quality and compliance, and collaborate with stakeholders to translate requirements into robust data solutions.

This role requires 4–8+ years in data engineering, hands-on IICS, Snowflake, SQL, and cloud

Qualifications

• 4–8+ years of experience in Data Engineering.
• Strong hands-on experience with Informatica IICS (CAI/CDI/MDM preferred).
• Strong Snowflake experience (SQL, performance tuning, data modeling).
• Advanced SQL and data transformation expertise.
• Experience with cloud platforms (AWS/Azure preferred).
• Understanding of data warehousing concepts (SCD, Star/Snowflake schema).
• Experience handling large datasets and performance optimization.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using IICS.
• Build scalable data models and transformations in Snowflake.
• Implement data ingestion from structured and semi-structured sources (S3, APIs, flat files, etc.).
• Optimize Snowflake performance (clustering, micro-partitions, query tuning).
• Work with HLS datasets (claims, patient data, CRM, commercial sales, specialty pharmacy, etc.).
• Ensure data quality, governance, and compliance (HIPAA/GxP awareness preferred).
• Collaborate with business stakeholders for requirement gathering and solution design.
• Support production deployments, troubleshooting, and performance tuning.
• Implement CI/CD and version control best practices.

Skills

ETL Fundamentals

SQL

SQL (Basic + Advanced)

Alation

Talend

Python

Data Warehousing

IICS

Modern Data Platform Fundamentals

Data Modelling Fundamentals

PLSQL

T-SQL

Stored Procedures

Tools

Snowflake

Informatica IICS

Alation

Talend

Job description

Consultant

• ETL Fundamentals, SQL, SQL (Basic + Advanced), Alation, Talend, Python, Data Warehousing, IICS, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures


• ETL Specialization: Senior Data Engineer


• 
  

  Job Title: Data Engineer – IICS & Snowflake (Healthcare / Life Sciences) Role Summary

  
  

  We are seeking an experienced Data Engineer with strong expertise in Informatica Intelligent Cloud Services (IICS) and Snowflake, along with domain knowledge in Healthcare & Life Sciences (HLS). The ideal candidate will design, build, and optimize scalable data pipelines supporting commercial, patient, clinical, or real-world data use cases.

  
  

  Key Responsibilities

  
  
  
  
  • Design, develop, and maintain ETL/ELT pipelines using IICS
  
  
  • Build scalable data models and transformations in Snowflake
  
  
  • Implement data ingestion from structured and semi-structured sources (S3, APIs, flat files, etc.)
  
  
  • Optimize Snowflake performance (clustering, micro-partitions, query tuning)
  
  
  • Work with HLS datasets (claims, patient data, CRM, commercial sales, specialty pharmacy, etc.)
  
  
  • Ensure data quality, governance, and compliance (HIPAA/GxP awareness preferred)
  
  
  • Collaborate with business stakeholders for requirement gathering and solution design
  
  
  • Support production deployments, troubleshooting, and performance tuning
  
  
  • Implement CI/CD and version control best practices
  
  
  
  

  Required Skills Technical:

  
  
  
  
  • 4–8+ years of experience in Data Engineering
  
  
  • Strong hands-on experience with Informatica IICS (CAI/CDI/MDM preferred)
  
  
  • Strong Snowflake experience (SQL, performance tuning, data modeling)
  
  
  • Advanced SQL and data transformation expertise
  
  
  • Experience with cloud platforms (AWS/Azure preferred)
  
  
  • Understanding of data warehousing concepts (SCD, Star/Snowflake schema)
  
  
  • Experience handling large datasets and performance optimization
  
  
  • Familiarity with APIs, JSON, XML, and semi-structured data
  
  
  • Domain (HLS): Experience working in Healthcare or Life Sciences domain
  
  
  • Understanding of: Claims data (Komodo, IQVIA, Symphony, etc.)
  
  
  • Specialty pharmacy / Patient Support Programs (PSP)
  
  
  • CRM (Veeva/SFDC)
  
  
  • Commercial sales analytics
  
  
  • Regulatory/compliance requirements