Lead Data Engineer - R01565207

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

Job summary

Brillio in Bengaluru, India, is seeking an experienced Data Engineer skilled in Informatica IICS and Snowflake to design and optimize data pipelines for Healthcare & Life Sciences datasets, including claims, patient data, and CRM.

You will build scalable data models, ensure data quality, collaborate with stakeholders, and implement CI/CD practices to support production deployments.

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

Data Engineering

SQL

Tools

Informatica IICS

Snowflake

AWS

Azure

APIs/JSON/XML

Job description

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.