Where is the Lead Data Engineer - R01565207 role at Brillio 2 located?

The Lead Data Engineer - R01565207 position at Brillio 2 is based in Bangalore, Karnataka, India. This is an on-site position.

What experience is required for the Lead Data Engineer - R01565207 role at Brillio 2?

The Lead Data Engineer - R01565207 position at Brillio 2 requires 4-8 yrs exp.

What skills are required for the Lead Data Engineer - R01565207 role at Brillio 2?

Key skills for the Lead Data Engineer - R01565207 position at Brillio 2 include: sql, python, snowflake, aws s3, ci/cd, aws, azure.

Lead Data Engineer - R01565207 — Brillio 2

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 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

Lead Data Engineer - R01565207