Design, build, and maintain ETL/ELT pipelines using Informatica IICS and Snowflake. Implement data ingestion from structured and semi-structured sources, optimize Snowflake performance, ensure data quality and compliance for healthcare/life sciences datasets, collaborate with stakeholders, and support production deployments with CI/CD and troubleshooting.
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
Brillio Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Digital Media • Information Technology • News + Entertainment
Design, develop, and execute ETL test strategies and automated validation for data ingestion, transformation, and loading. Validate data quality, perform reconciliation and lineage checks, develop SQL/Python validation scripts, monitor ETL workflows, collaborate with engineering and product teams, participate in code reviews and defect triage, and support data migrations and platform upgrades.
Top Skills:
AirflowAPIsAutomation Test FrameworkCi/CdData LakesData WarehousesDatabricksDbtETLJavaPythonSnowflakeSQL
Digital Media • Information Technology • News + Entertainment
Design, develop, test and integrate software and web applications. Produce technical documentation, train operations staff, mentor junior engineers, collaborate with QA, present architectural choices, and support software releases while applying project management and independent judgment.
Digital Media • Information Technology • News + Entertainment
Design, build, and optimize scalable data pipelines and platforms (Snowflake, Databricks, Spark). Ensure data quality, lineage, and observability. Mentor junior engineers, lead cross-team initiatives, implement CI/CD, and improve internal data engineering tools and architectures.
Top Skills:
AirflowSparkAWSAws S3AzureCi/CdDatabricksDbtGCPIcebergPythonSnowflakeSQL
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
