Talend ETL Developer | TDM & Healthcare Data

Covetus; United States; On-site; USD 120,000 - 150,000; Full time

Job summary

Covetus is seeking a Talend Developer in the United States equipped with strong SQL and Test Data Management to design, develop, and maintain ETL pipelines and test data for QA/UAT, with support for analytics and reporting. Databricks experience is a plus.

The role involves integrating data from databases, APIs, and flat files, ensuring data quality and security, and collaborating with QA, development, and business teams on test data requirements in a 12-month W2 engagement.

Qualifications

• Strong hands-on experience with Talend (Talend Data Integration / Talend Studio).
• Advanced SQL expertise, including query optimization and performance tuning.
• Solid experience with Test Data Management (TDM) concepts and practices.
• Experience working with relational databases (Oracle, SQL Server, PostgreSQL, MySQL).
• Strong understanding of ETL concepts, data warehousing, and data modeling.
• Experience in Healthcare domain with knowledge of EDI transactions, including 837 Claims, 834 Membership/Enrollment, and related healthcare data processing workflows.
• Hands-on experience processing, validating, transforming, and troubleshooting healthcare claim and enrollment files (837, 834) using ETL tools and SQL.
• Familiarity with HIPAA compliance, healthcare data privacy, and data quality standards.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, and maintain ETL workflows using Talend.
• Develop and optimize complex SQL queries for data extraction, transformation, and validation.
• Implement and manage Test Data Management (TDM) strategies to support QA, UAT, and regression testing.
• Create, refresh, mask, subset, and validate test data across multiple environments.
• Integrate data from various sources including databases, APIs, and flat files.
• Ensure data quality, integrity, security, and performance across data pipelines and test datasets.
• Troubleshoot and resolve data integration, test data, and performance issues.
• Collaborate with QA, development, and business teams to understand test data requirements.
• Support scheduling, deployment, and monitoring of Talend jobs.
• Document data flows, test data processes, and technical designs.

Skills

Talend

SQL

Test Data Management

ETL concepts

Data warehousing

Data modeling

HIPAA awareness

Analytical skills

Communication skills

Tools

Databricks

Talend Studio

Job description

Covetus is seeking a Talend Developer in the United States equipped with strong SQL and Test Data Management to design, develop, and maintain ETL pipelines and test data for QA/UAT, with support for analytics and reporting. Databricks experience is a plus.

The role involves integrating data from databases, APIs, and flat files, ensuring data quality and security, and collaborating with QA, development, and business teams on test data requirements in a 12-month W2 engagement.