Talend ETL Developer - Data Transformation

Seeking Talend ETL Developers to build and support data integration and transformation pipelines for healthcare payer regulatory and platform initiatives. The resource will map, cleanse, transform, validate, and load data between source and target systems, potentially including claims, eligibility, pharmacy-vendor, and related healthcare datasets., The project supports regulatory and platform changes across healthcare payer systems. Approximately 60% of the work is expected to involve claims, eligibility, TriZetto FACETS, and platform integrations; the remaining work may cover pharmacy-vendor data, clinical assessments, member engagement, and portal updates. Java is expected to be involved in approximately 70-80% of the overall work., Design, develop, test, deploy, and support ETL jobs using Talend Studio and related Talend components.

Translate source-to-target mapping specifications and business rules into reliable data transformations.

Extract data from databases, files, APIs, and other source systems and load it into target platforms.

Build transformations for healthcare data while preserving data quality, completeness, and referential integrity.

Use SQL to analyze source data, validate transformations, reconcile counts, and investigate data issues.

Implement error handling, logging, restartability, auditability, and exception management for ETL jobs.

Monitor scheduled/batch jobs, troubleshoot failures, and optimize performance for data volumes and processing windows.

Create and maintain technical documentation, mapping specifications, test evidence, and operational procedures.

Coordinate with Java developers, QA, business analysts, and platform teams to support integrated releases.

Hands-on development experience with Talend ETL tools, especially Talend Studio.

Strong SQL skills and experience with relational databases.

Experience building data extraction, transformation, validation, and loading workflows.

Knowledge of source-to-target mapping, data profiling, data cleansing, and reconciliation.

Experience with ETL job scheduling, logging, error handling, and production troubleshooting.

Ability to understand business rules and convert them into reliable data transformation logic.

Strong testing, documentation, and cross-team collaboration skills.

Preferred Qualifications

Healthcare payer data experience involving claims, eligibility, membership, pharmacy, or provider data.

Experience with large-volume batch processing, incremental loads, and performance tuning.

Exposure to APIs, flat files, cloud data platforms, CI/CD, or automated ETL deployment., * Talend ETL tools, especially Talend Studio.: 5 years (Required)

• SQL with relational databases: 4 years (Required)
• building data extraction, transformation, validation: 4 years (Required)
• Data Transformation : 3 years (Required)
• TriZetto FACETS, Facets: 1 year (Preferred)