Functional Consultant – Talend to Databricks Migration
Domain
Retail / Grocery
Experience
8+ years of experience in Data/ETL Functional Consulting, Business Analysis, Data Migration, or Data Modernization, with strong experience in Talend-based data environments
Role Overview
We are looking for an experienced Functional Consultant to support a large-scale Talend-to-Databricks migration program for a leading Retail/Grocery client.
The Functional Consultant will act as the bridge between business stakeholders, data architects, Talend SMEs, Databricks engineering teams, QA teams, and offshore delivery teams.
The role will focus on understanding existing Talend data processes, documenting business rules and data flows, gathering requirements, supporting migration assessment, defining functional mappings, validating migrated data, and ensuring that the Databricks solution meets business requirements.
The ideal candidate should have strong experience working with enterprise data/ETL programs, preferably with Talend, and a good understanding of Retail/Grocery business processes and data domains.
Key Responsibilities: Business & Functional Analysis
Business & Functional Analysis
- Engage with business stakeholders to understand business processes, data requirements, and reporting needs.
- Analyze existing data processes and understand how Talend supports critical business functions.
- Document functional requirements, business rules, data definitions, and process flows.
- Identify current-state pain points, data-quality issues, manual processes, and business dependencies.
- Translate business requirements into clear functional specifications for technical teams.
- Facilitate workshops with business users, SMEs, architects, and engineering teams.
Talend Migration Assessment
- Analyze existing Talend jobs, workflows, mappings, schedules, dependencies, and interfaces from a functional perspective.
- Understand the business purpose and downstream consumers of Talend jobs.
- Identify critical Talend processes that need to be migrated to Databricks.
- Classify migration workloads based on business criticality, complexity, dependencies, frequency, and data volume.
- Identify jobs that can be retired, consolidated, redesigned, or migrated as-is.
- Document functional dependencies between Talend jobs and upstream/downstream applications.
- Support creation and prioritization of migration waves.
Functional Mapping & Transformation Rules
- Review existing Talend transformation logic and translate it into understandable business/functional rules.
- Prepare source-to-target mapping documents.
- Define field-level mappings, transformation rules, default values, derivations, filters, joins, aggregations, and business validations.
- Identify data elements requiring special treatment during migration.
- Validate that existing Talend business logic is correctly understood before implementation in Databricks.
- Work with Databricks developers to clarify functional requirements and transformation logic.
Data Validation & Reconciliation
- Define functional validation criteria for migrated data.
- Develop and execute data reconciliation scenarios between Talend/legacy and Databricks.
- Validate record counts, key business metrics, aggregations, data completeness, and transformation results.
- Investigate data mismatches and coordinate with technical teams for resolution.
- Support SIT, UAT, regression testing, and production validation.
- Ensure business-critical reports and downstream processes continue to produce expected results after migration.
Retail / Grocery Domain: Strong understanding of Retail/Grocery business processes is preferred.