JD3 - 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

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 Requirements 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, t. File, tREST, tJSON, t. Map, t. Filter. Row, t. Join, t. Aggregate. Row).
• Implement CDC (watermark/timestamp keys) and SCD Type 1/Type 2 for dimensions using t. Map + 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, On. Subjob. Ok/On. Component. Ok 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, t. Map, 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.