Lead Data Engineer - R01565207 at Brillio (Bengaluru, India)
Brillio· Bengaluru, India·
Role details
Work type
Hybrid
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
Why work at Brillio
- Culture: Rated 4.0/5.0 on Glassdoor (2,264 reviews) and 4.0/5.0 on LinkedIn; 80% would recommend to a friend; Great Place to Work® certified in the USA.
- Work environment: Engineers get meaningful ownership within clear guardrails – autonomy to make architecture and trade-off calls on their workstreams.
- Learning & growth: Brillio Academy, hackathons, personalized career development framework; exposure to cutting-edge GenAI and agentic AI projects.
- Remote / hybrid / office: Not explicitly stated, but global delivery locations suggest a mix of on-site and remote (roles posted across multiple countries).
- Benefits: “BYou” wellness program built on four pillars of wellness – personal and professional well-being and development.
- Interview process: Focus on software fundamentals, LLMs, RAG, agents, evaluation, and a design or debugging exercise; candidates should be ready to walk through a real system they shipped.