Lead Data Engineer - R01565207

Brillio; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Brillio is seeking a skilled Data Engineer specializing in Informatica IICS and Snowflake in the Healthcare/Life Sciences sector. Your role involves designing and optimizing scalable data pipelines, ensuring data quality and compliance, and collaborating with business stakeholders.

Candidates should have 4–8 years of Data Engineering experience, strong SQL skills, and familiarity with data warehousing concepts. The position supports career growth in a rapidly evolving domain with competitive compensation.

Qualifications

• Experience with Informatica Intelligent Cloud Services (IICS) and Snowflake.
• Strong hands-on experience in ETL/ELT pipeline development.
• Familiarity with healthcare data and compliance requirements.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using IICS.
• Build scalable data models and transformations in Snowflake.
• Optimize performance of Snowflake instances.

Skills

ETL Fundamentals

SQL

Python

Data Warehousing

Snowflake

Informatica IICS

PLSQL

API Handling

Education

4–8+ years of experience in Data Engineering

Tools

AWS

Azure

Job description

Consultant

Primary 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

Specialization

• ETL Specialization: Senior Data Engineer

Job requirements

• 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 and 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 modelling)
  – 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 optimisation
  – 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