Data Engineer
Summary
Talend ETL Developer role supporting and enhancing enterprise data integration pipelines: building and maintaining Talend jobs, integrating databases, ERP systems, flat files, cloud storage, and APIs, optimizing Snowflake structures, and providing production support. Core stack: Talend, T-SQL/SnowSQL, SQL Server, Snowflake, Git.
Hiring: Talend ETL Developer
We are looking for a Talend ETL Developer to support, maintain, and enhance existing enterprise data integration solutions while contributing to ongoing development initiatives. The role involves working with enterprise data sources, databases, file-based integrations, cloud data platforms, and application interfaces to ensure reliable data processing and seamless data movement across systems.
Job Description
The selected candidate will collaborate with the existing development team and business stakeholders to understand requirements, maintain current integrations, implement enhancements, perform testing, and provide production support.
Key Responsibilities
- Develop, maintain, and enhance ETL jobs using Talend.
- Support existing data integration processes and implement changes based on business requirements.
- Design and build reliable, scalable, and complex ETL/ELT pipelines to process large data volumes.
- Integrate data from enterprise databases, ERP systems, flat files, cloud storage, and APIs.
- Design and optimize data structures, including tables, views, and stored procedures, within Snowflake.
- Perform data extraction, transformation, loading, validation, and reconciliation.
- Write and optimize SQL queries to analyze data, investigate discrepancies, and validate integration results.
- Support integrations involving ERP systems and downstream business applications.
- Monitor job executions, troubleshoot failures, investigate issues, and assist with root-cause analysis.
- Participate in development, unit testing, QA, deployment, and post-deployment validation.
- Manage job scheduling, configuration, error handling, and routine maintenance.
- Collaborate with Business Analysts, QA teams, developers, and other stakeholders to resolve issues and deliver business requirements.
- Maintain technical documentation and support knowledge transfer for existing processes.
- Follow established development practices, version control procedures, and release management processes.
- Provide timely production support to ensure the continuity and reliability of business-critical data flows.
Technical Skills
- Hands-on experience in Talend ETL development and data integration.
- Proficiency in T-SQL, SnowSQL, and SQL query development.
- Experience with SQL Server, SQL Server Management Studio (SSMS), and Snowflake.
- Knowledge of enterprise databases and ERP applications.
- Experience with file-based integrations, CSV files, SFTP, and secure data transfers.
- Familiarity with REST APIs and structured data formats such as JSON and XML.
- Understanding of Talend job scheduling, monitoring, error handling, and troubleshooting.
- Experience in data validation, reconciliation, and performance optimization.
- Familiarity with Git or other version control tools.
- Experience working across development, testing, QA, and production environments.
Preferred Experience
- Experience maintaining and supporting existing enterprise ETL processes.
- Exposure to retail, merchandising, inventory, product, vendor, store, or other operational data.
- Familiarity with cloud-based data integration and data warehousing solutions.
- Experience in production support, incident resolution, and controlled deployments.
- Ability to understand existing workflows, adapt to established business logic, and work independently following the initial knowledge-transfer period.
Desired Candidate Profile
The ideal candidate will have strong analytical and problem-solving skills, a practical understanding of ETL development, and the ability to collaborate effectively with technical teams and business stakeholders.
The candidate should be comfortable working with existing systems, maintaining established integrations, implementing routine enhancements, troubleshooting data issues, and supporting production operations.
The immediate priority is to ensure a smooth transition of existing responsibilities, followed by independent ownership of development, maintenance, enhancements, and production support activities.