Talend Senior ETL Developer - hybrid

US Tech Solutions - Boston, MA

Full-time

Hybrid - Boston, MA

Administrative and Support Services

About the position

US Tech Solutions is seeking a skilled ETL Developer with extensive experience in using the Talend ETL toolset to create and manage ETL jobs. The ideal candidate will be responsible for designing and implementing ETL processes that extract and transform data from various sources, including Snowflake, PostgreSQL, and SQL Server databases. This role requires a deep understanding of database design, as the developer will also be tasked with creating and developing database tables along with the necessary constraints based on project requirements. Collaboration is key in this position, as the ETL Developer will work closely with team members to understand the structures of source systems and the methods for data retrieval. The role also involves supporting the development of data transformation logic using ETL tools or scripting languages such as SQL, Bash, and Python. The developer will be responsible for cleaning, validating, and transforming data to ensure it meets the target schema and quality standards. Additionally, the ETL Developer will participate in executing data quality improvement plans and troubleshooting activities to maintain data integrity and process efficiency. This position is ideal for someone who thrives in a hybrid work environment and can manage competing priorities effectively. The successful candidate will have a strong background in health data organizations and be comfortable working with sensitive data, including PII and PHI, while adhering to HIPAA policies. Excellent communication skills, both verbal and written, are essential, along with the ability to document processes clearly and maintain organized work habits under tight deadlines.

Responsibilities

• Use the Talend ETL toolset to create new ETL jobs.
• Design and implement ETL for extracting and transforming data from diverse sources, such as: Snowflake, PostgreSQL, and SQL Server databases.
• Design and develop database tables necessary along with the necessary constraints as per the requirement.
• Collaborate with team members to understand source system structures and data retrieval methods/techniques, and tools within the organization.
• Support the development of data transformation logic using ETL tools or scripting languages like SQL, Bash, Python, etc.
• Clean, validate, and transform data to conform to target schema and quality standards.
• Work with the team to execute data quality improvement plans.
• Participate in troubleshooting activities to maintain data integrity and process efficiency.

Requirements

• Five years' experience using Talend Data Fabric in a professional environment.
• Demonstrable knowledge with the Talend Data Fabric tool, ESB, and MDM development tasks and processes, particularly creating ETL from Technical specifications and converting ETL from other third party ETL tools and frameworks.
• Five years' experience working for a health data organization performing ETL Development activities.
• Three years' experience with database, data warehouse, ETL, business intelligence, or software development.
• Experience in developing projects using Talend with Data Integration and Cloud Integration working with large datasets.
• Experience with cloud technologies (Azure/AWS) and Microsoft DevOps Git Repos.
• Experience with Snowflake, PostgreSQL, and SQL Server database technologies.
• Able to create/modify tables, stored procedures, functions, triggers, and other DB objects.
• Ability to work independently in a hybrid work environment.
• Working knowledge and understanding of HIPAA policies and working with PII and PHI sensitive data.
• Effective at managing competing priorities and can work independently with little or no supervision.
• Excellent communication skills: verbal and written, along with excellent documentation skills.
• Comfortable working under tight deadlines while maintaining well organized, detailed, and process-oriented work habits.