JD7 - Consultant - Talend

Kivitronicsconsulting; Chennai District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Kivitronicsconsulting seeks a client-facing data engineering consultant to lead discovery, design, and delivery of Talend-based data platforms. You will own end-to-end engineering across ingestion, transformation, modelling, governance, quality, deployment, and operations.

Responsibilities include architecture, documentation, and mentoring, with a focus on secure, scalable solutions and strong collaboration with stakeholders to ensure reliable, cost-efficient delivery.

Qualifications

• Bachelor's degree in computer science, information technology, or equivalent.
• 4+ years delivering Talend-based data engineering in consulting environments.
• Proficiency in SQL, Python, data modeling, and cloud security basics.

Responsibilities

• Lead discovery and design of Talend-based data platforms.
• Architect secure, scalable, cost-optimized data pipelines.
• Prepare HLD/LLD, dataflow diagrams, and runbooks.
• Governance and compliance (GDPR, SOC 2) across solutions.
• Drive reliability, monitoring, incident handling, and post-mortems.
• Mentor junior engineers and ensure quality documentation.

Skills

SQL

Python

Talend

Data Modeling

Cloud Security

ETL Design

Stakeholder Liaison

Education

Bachelor’s degree in CS/IT

Talend Certification

Tools

Talend Cloud Admin (TMC)

Talend Data Catalogue

Azure DevOps/GitHub Actions

Job description

Balamurugan Nagar,Keelkattalai, India | Posted on 01/10/2026

Client-facing consultant who leadsdiscovery, solution design, and delivery of data platforms using the Talend ecosystem.Owns end-to-end engineering across ingestion, transformation, modelling,governance, quality, deployment, and operations. Partners with stakeholders todefine outcomes, document solutions, estimate work, and ensure reliable,cost-efficient delivery.

Duties and responsibilities ofposition:

General areas of responsibilityrelate to:

• Lead/Co-lead requirements workshops; translatebusiness needs into technical user stories and Talend architecture.
• Design secure, scalable, and cost-optimizedTalend-based solutions (cloud or hybrid).
• Prepare solution design artifacts (HLD/LLD, dataflow diagrams, mapping specs, runbooks).
• Ensure compliance and governance (GDPR, HIPAA,SOC 2 as applicable) and enterprise standards.
• Drive production reliability: monitoring,incident handling, post-mortems, and continuous improvement.
• Mentor junior engineers; uphold documentationquality and delivery discipline

Requirements

Specific areas ofresponsibility include but is not limited to:

• Architect and implement parameterized,metadata-driven Talend Jobs and Joblets for batch and incremental ingestionfrom databases, files, and APIs (components such as tDBInput/tDBOutput,tFileInputDelimited, tREST, tJSON, tMap, tJoin, tAggregateRow, tFilterRow).
• Implement CDC (watermark/timestamp, changetables/logs) and SCD Type 1 & Type 2 with surrogate keys, effective/expirydates, and current-record flags.
• Standardize contexts, repository metadata,naming conventions, and folder structures for maintainability.
• Optimize performance (lookup caches, bulkloaders, parallelization, commit strategies, memory tuning) and designresilient orchestration using OnSubjobOk/OnComponentOk routes and errorhandling.
• Configure Talend Management Console:environments (dev/test/prod), workspaces, roles/permissions, and single sign-onif applicable.
• Manage Cloud/Remote Engines and Runtimes;schedule tasks, configure parameters, and administer logs/notifications.
• Integrate with Git for version control;implement CI/CD for Talend artifacts via Azure DevOps/GitHub Actions(build/promote/rollback).
• Monitor executions, set up alerts/retries, andmaintain deployment lifecycle across environments.
• Curate business glossaries, technical metadata,classifications, and stewardship assignments.
• Register sources/datasets and enable end-to-endlineage (source transformation target).
• Apply policies/roles, tagging, approvals;publish catalogue assets for BI and data consumers.
• Keep catalogue documentation in sync withreleases, track change history and ownership.
• Profile data for completeness, uniqueness,pattern conformance, and outliers; define DQ rules and thresholds.
• Embed DQ checks into pipelines (fail/flagroutes, exception tables, remediation workflows).
• Publish DQ dashboards and KPIs (accuracy,timeliness, freshness); drive continuous improvement with stakeholders.
• Design star/snowflake dimensional models,conformed dimensions, and fact tables aligned to business KPIs.
• Select storage engines and formats appropriateto target platforms (e.g., Azure SQL, Synapse, Snowflake, Databricks Delta), includingpartitioning/indexing/distribution strategies.
• Produce mapping specs, data dictionaries, andmaintain semantic consistency for downstream BI.
• Enforce RBAC across Talend Cloud (TMC); securesecrets via contexts, encrypted stores, or vault integrations.
• Apply encryption in transit/at rest, masking,and row/column-level security in downstream stores.
• Document policies, access reviews, and audittrails; support compliance reporting and data retention.
• Version Talend projects with Git; adoptbranching strategies (feature/release/hotfix).
• Automate build/deploy/promote using TMC APIs orpipelines (Azure DevOps/GitHub Actions).
• Parameterize environments via contexts andvariables; maintain release notes, rollback, and DR procedures.
• Set up monitoring and alerts for task failures,SLA breaches, and data freshness; analyse logs to perform root causeanalysis.
• Optimize runtime costs (engine sizing,scheduling windows, parallelization, caching) and manage lifecycle policies forstorage.

Other duties

• Lead solution walkthroughs; articulatetrade-offs (Talend vs. native cloud services, batch vs. micro batch, CDCoptions).
• Build POCs (SCD2, CDC, DQ, Catalogue lineage) tovalidate approaches and de-risk delivery.
• Create effort estimates, risks, assumptions, andRACI; manage stakeholder expectations and change requests.
• Present progress to business audiences; simplifycomplex technical topics and capture decisions/actions.
• Develop metrics and reports for seniormanagement on cloud performance, security posture, and incident management.
• Troubleshoot and resolve issues related to cloudservices, network connectivity, and automation workkflows.

Qualifications

• Bachelor’s degree in computer science,Information Technology, or a related field; or equivalent professionalexperience.
• Minimum of 4+ years of experience in deliveringTalend-based data engineering solutions in consulting/client-facingenvironments.
• Proficiency in
• o SQL(joins, window functions, aggregates, basic indexing/tuning)
• o Python(scripts/utilities; custom steps, API integrations; PySpark exposure is a plus)
• Hands-on experience in data modeling, indexing,and query performance tuning.
• Hands-on with:
• o TalendCloud Admin (TMC): environments, roles, engines/runtimes, scheduling,monitoring.
• o TalendData Catalogue: glossaries, lineage, classifications, stewardship workflows.
• Working knowledge of firewalls, network andserver security, SSL certificates and security best practices.
• o TalendData Integration Certified Developer
• o TalendAPI Services Certified Developer
• Experience with Microsoft 365 administration(e.g., Exchange, SharePoint, OneDrive, Teams).
• Experience with backup, disaster recovery, andbusiness continuity planning.
• Strong understanding of cloud security risks,including data breaches, malware, and social engineering.
• Excellent collaboration skills for working withcross-functional teams and providing leadership in cloud security projects.
• Experience working in a team, able to lead,prioritize and execute tasks in a high-pressure environment and provide or makesound decisions in emergencies.