ETL Developer - Talend

Description

We are seeking a skilled ETL Developer with extensive experience in Talend to join our Core Suite Workers' Compensation team. The ideal candidate has a strong background in data integration, transformation, and migration, with a focus on optimizing data processes and ensuring data quality, while leveraging approved AI-augmented tools and SaaS/cloud data platforms.

Key Responsibilities

• ETL development: Design, develop, and maintain ETL processes using Talend to extract, transform, and load data from various sources into data warehouses and other systems.
• Data integration: Collaborate with data architects, business analysts, and other stakeholders to understand data requirements and develop integration solutions.
• Data quality: Ensure the accuracy, completeness, and integrity of data by implementing robust data validation and cleansing processes.
• Performance optimization: Optimize ETL workflows to improve performance and efficiency, including monitoring and troubleshooting ETL jobs.
• Documentation: Create and maintain detailed documentation for ETL processes, data flows, and data models.
• Collaboration: Work closely with cross-functional teams, including developers, QA engineers, and project managers, to deliver high-quality solutions on time.
• Compliance: Ensure ETL processes comply with company policies, industry standards, and regulatory requirements, particularly those relevant to workers' compensation data.
• Continuous improvement: Stay updated with the latest industry trends, tools, and best practices in ETL development and data integration, and apply them to enhance existing processes.

Must Have Skills & Qualifications

Experience & Background

• Minimum of 3-5 years of experience in ETL development, with at least 2 years of experience specifically using Talend.

Technical Skills

• Proficiency in Talend Data Integration, Talend Data Quality, and Talend Big Data.
• Strong SQL skills and experience with database technologies (e.g., SQL Server, Oracle, MySQL).
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues.

AI-Related Expectations

• Use approved AI/LLM tools to accelerate ETL job design, SQL and transformation logic drafting, and documentation.
• Leverage AI assistance for log analysis, root-causing job failures, and identifying data quality anomalies.
• Validate AI-generated code, mappings, and queries for correctness, performance, and data-handling compliance before use.
• Follow approved privacy, security, and responsible-AI guidelines, particularly when working with sensitive workers' compensation data.

SaaS & Cloud Awareness

• Understanding of environment-based ETL deployment and testing across Dev, QA, UAT, and Production-like setups.
• Awareness of SaaS delivery concepts such as configuration-driven change, release cadence, and integration dependencies.
• Basic familiarity with how cloud-hosted data platforms affect data movement, job scheduling, security, and cost.

Communication & Collaboration

• Excellent written and verbal communication skills, with the ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
• Ability to work independently as well as part of a collaborative team environment.

Education

• Bachelor's degree in Computer Science, Information Technology, or a related field.

Preferred / Good to Have

• Understanding of workers' compensation data and related processes.
• Talend certification(s) and other relevant data integration or ETL certifications.
• Experience with other ETL tools; experience with cloud platforms (e.g., AWS, Azure) is an added advantage.
• Familiarity with Agile methodologies and experience working in an Agile/Scrum environment.
• Strong attention to detail, organizational skills, and a proactive approach to problem-solving and process improvement.

Why Join Us:

• Work on business-critical workers' compensation data on the CoreSuite platform, building deep expertise in Talend-based data integration, data quality, and migration in a collaborative delivery environment.