Senior Data Engineer

Jobtailor; Chennai District; On-site; INR 1,500,000 - 2,700,000; Full time

Job summary

Jobtailor is seeking a Data Engineer to design, develop, and maintain ETL/ELT pipelines using Informatica IICS and to build scalable Snowflake data models.

You will ingest data from structured and semi-structured sources, optimize performance, ensure data quality and governance, and collaborate with stakeholders while adopting CI/CD practices. Based in Chennai, this role focuses on healthcare data domains.

Qualifications

• 4–8+ years of experience in Data Engineering.
• 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).
• Healthcare/Life Sciences domain experience preferred.
• Familiarity with APIs, JSON, XML, and semi-structured data.
• Regulatory/compliance awareness in data management.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using IICS.
• Build scalable data models and transformations in Snowflake.
• Ingest data from structured and semi-structured sources (S3, APIs, flat files).
• Optimize Snowflake performance (clustering, micro-partitions, tuning).
• Ensure data quality, governance, and HIPAA/GxP awareness.
• Collaborate with stakeholders for requirements and solution design.
• Support deployments, troubleshooting, and performance improvements.
• Implement CI/CD and version control best practices.

Skills

Advanced SQL

Data transformation

Data modeling

Performance tuning

Collaboration

Tools

Informatica IICS

Snowflake

Cloud platforms (AWS/Azure)

Job description

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

Requirements

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

ATS Optimization Keywords

• ETL
• ELT
• Informatica IICS
• Snowflake
• SQL
• data transformation
• data modeling
• performance tuning
• data warehousing
• CI/CD

Soft Skills

• collaboration
• requirement gathering
• solution design
• troubleshooting
• performance optimization