JD8 - Associate Consultant - Talend

Job purpose:

Support the design and development of data integration solutions using the Talend ecosystem. Work closely with senior consultants and clients to implement ETL/ELT pipelines, ensure data quality, and maintain governance standards. This role combines hands-on Talend development with basic consulting activities such as documentation and assisting in requirement discussions.

Duties and responsibilities of position:

General areas of responsibility relate to:

• Ensure the security, performance, and scalability of Azure cloud environments and data solutions.

• Lead the development and implementation of cybersecurity strategies, including security awareness training.

• Provide backup support for Microsoft 365 administration and ensure seamless integration with Azure environments.

• Collaborate with IT teams and business units to implement secure and scalable cloud solutions.

• Maintain compliance with industry standards such as PHIPPA, CIS, and NIST as required

• Provide after-hours support for Infrastructure related emergencies, regular and occasional weekend maintenance

Specific areas of responsibility include but are not limited to:

• Build parameterized Talend Jobs for batch and incremental ingestion from databases, files, and APIs (tDBInput/tDBOutput, tFile, tREST, tJSON, tMap, tFilterRow, tJoin, tAggregateRow).

• Implement CDC (watermark/timestamp keys) and SCD Type 1/Type 2 for dimensions using tMap + surrogate keys and validity dates.

• Design reusable Joblets, contexts, and metadata repositories; enforce naming standards and folder structures.

• Optimize Jobs for performance (lookup caching, bulk components, parallelization, commit strategies, OnSubjobOk/OnComponentOk orchestration).

• Configure Talend Management Console (TMC): environments (dev/test/prod), workspaces, roles, and permissions.

• Manage engines (Cloud/Remote) and Runtimes; schedule tasks, set execution parameters, and handle logs.

• Monitor executions, handle failures/retries, and maintain lifecycle (deploy, promote, rollback).

• Design star/snowflake dimensional models, conformed dimensions, and fact tables.

• Use appropriate storage tech (e.g., Azure SQL, Synapse, Snowflake, or on-prem DBs) with partitioning/indexing.

• Maintain data dictionaries and mapping specifications; align with BI/analytics needs.

• Apply RBAC across Talend Cloud (TMC), secure credentials via context variables/vaults.

• Enforce encryption in transit/at rest, masking, and role/row-level controls in target systems.

• Document policies and audit trails; support compliance reporting and access reviews.

• Set up alerts for failed tasks, SLA breaches, and data freshness; analyze logs for root causes.

• Optimize runtime costs (scheduling windows, engine sizing, caching strategies).

• Periodic usage reviews; recommend right-sizing and lifecycle policies.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field; or equivalent professional experience.

• Minimum of 2+ years of experience with hands-on Talend implementations (Studio + Cloud).

• Proficiency in

o SQL (joins, window functions, aggregates, basic tuning)

o Python (scripting/utilities; helpful for custom steps or API integration)

• Experience with:

o Talend Studio (Integration): Job design, Joblets, contexts, tMap, tREST/tJSON, CDC/SCD patterns.

o Talend Cloud Admin (TMC): environments, roles, engines, scheduling, monitoring.

• Familiarity with Git, CI/CD (Azure DevOps/GitHub), and security best practices.

• Hands-on experience in data modeling, indexing, and query performance tuning.

• Proficiency in vulnerability management across platforms (Windows, Linux, Network devices etc.)

• Working knowledge of firewalls, network and server security, SSL certificates and security best practices.

• Certifications (Preferred):

o Talend Data Integration Certified Developer

• Experience with Microsoft 365 administration (e.g., Exchange, SharePoint, OneDrive, Teams).

• Exposure to downstream analytics (e.g., Power BI, Tableau) and target data stores (Azure SQL/Synapse/Snowflake).

• Experience working in a team, able to lead, prioritize and execute tasks in a high-pressure environment and provide or make sound decisions in emergencies.