Talend Developer

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

Duration: 12 months with possible extension

Employment Type: W2 only

Job Summary:

We are seeking a skilled Talend Developer with strong SQL and Test Data Management expertise to design, develop, and maintain data integration and testing solutions. The role involves building ETL pipelines, managing test data for QA and UAT environments, and supporting analytics and reporting needs. Experience with Databricks is a plus.

Key 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.

Required Skills & Qualifications:

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

Preferred Qualifications:

• Experience working with healthcare payers, providers, or managed care organizations.
• Knowledge of healthcare data models including claims, members, providers, eligibility, and encounters.
• Experience supporting QA/UAT testing through test data creation, masking, subsetting, and validation in healthcare environments.
• Exposure to healthcare data migration and modernization initiatives.