Senior ETL Developer with Talend and Java experience to work with one of our major banking clients- 38991

Senior ETL Developer with Talend and Java experience to work with one of our major banking clients- 38991

Location Address: Hybrid - Scarborough - 3 days/week (Thursday is set the other 2 are flexible)

Subject to change: 3-4 days onsite may be required based on business needs

Contract Duration: approx. 10 months - Jan to Oct 31, 2026 (Possibility of extension & conversion to FTE)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group: Client Engineering - Commerce Engineering - handle retail customer demographic data book of record for Bank

Project: Developer required for upcoming FY26 projects - software currency migration for a key ETL application within the organization

Typical Day in Role:

• Involved in end-to-end ETL/ELT architectures using Talend (Studio, TAC, Data Integration, Real-Time Big Data, Data Quality).
• Select integration patterns (batch, micro-batch, streaming) aligned to business SLAs and system constraints.
• Establish standards for metadata management, lineage, error handling, and reusability.

Hands-on Development

• Build robust Talend jobs, components, mappings, and data pipelines for ingestion, transformation, cleansing, and delivery.
• Develop custom Talend components and routines using Java 8/11 for advanced transformations and framework extensions.
• Work with SQL for validation, transformation logic, and performance tuning.

Data Quality & Validation

• Implement data quality rules, profiling, exception handling, and reconciliation frameworks.
• Design automated validation suites and sampling strategies for high-stakes data consumption.

Performance & Reliability

• Tune jobs and SQL for scale (partitioning, parallelization, pushdown optimization, caching).
• Optimize schedules, dependencies, and resource utilization within TAC.
• Establish SLIs/SLOs and monitor pipeline health via logs, metrics, and alerts.

DevOps & Automation

• Integrate Talend with Git and CI/CD tools (e.g., Jenkins, Azure DevOps) for versioning, build, test, and deployment automation.
• Promote repeatable deployments across dev/test/prod with environment configs and secrets management.

Migration & Modernization

• Lead conversion of legacy ETL platforms to Talend, including mapping old jobs, rationalizing logic, and decommissioning.
• Support cloud integration initiatives and real-time processing adoption.

Collaboration & Leadership

• Partner with data architects, DBAs, application teams, and business stakeholders.
• Mentor developers, review code/designs, and contribute to best practices and documentation.

Tools & Technologies:

Talend: Studio, TAC, DI, Real-Time Big Data Platform, Data Quality

Databases: SQL Server, DB2

Languages: Java 8/11, SQL

Streaming/Integration: REST, Kafka; monitoring via Splunk

DevOps: Git, Jenkins, Azure DevOps (pipelines, artifacts), environment configs

Cloud (preferred): Azure/GCP services for storage, compute, integration

Candidate Requirements/Must Have Skills:

1) 10+ years of relevant working experience in ETL development, architecture, and data integration

2) 8+ years of hands-on Talend development experience: Talend Studio, Talend Administration Center (TAC), Talend Data Integration, Talend Real-Time Big Data Platform and Talend Data Quality

3) 5+ years of Java (Java 8/11) for Talend customizations and job-level logic

4) Strong expertise across ETL concepts, data warehousing, and integration patterns

5) Hands on experience building Talend ETL/ELT jobs, components, mapping and data pipelines

6) Advanced SQL for data validation transformation and performance tuning (Oracle, SQL, Server, DB2, Teradata)

Nice-To-Have Skills:

1) Proven ETL Migration experience, including conversion of legacy ETL platforms into Talend

2) API and streaming data integration experience, including REST APIs, Kafka, Splunk

3) CI/CD integration for Talend jobs (GIT, Jenkins, Azure, DevOps, etc.)

4) Experience with cloud platforms and cloud integration

5) Big data and real time processing

6) Financial industry experience

Education:

Bachelor’s degree in Computer Science, Engineering, or related field; equivalent experience considered.

Best VS. Average Candidate:

Ideal candidate will have a good fit with the team above the technical skillset sought, ability to work in a fast-paced environment, communication; technical: strong experience with Talend; need to be able to hit the ground running

Candidate Review & Selection - Interview Process

1 round - MS Teams Video Interview - 1 hour - technical panel interview with HM, 2-3 other team members - potential technical assessment included, TBD

Please be camera ready - Video ON

Hiring Manager’s availability to interview: Week of Dec 19th for interviews, will go into first week of Jan as needed