Oracle TCA- Techno-Functional Consultant

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

Oracle EBS R12
Oracle TCA
AR
OM
CRM
Customer Master data architecture
hierarchies and lifecycle
SQL
PL/SQL
Oracle APIs
Data conversion tools
Data migration
Data cleansing
User Acceptance Testing (UAT)

Job Details

Job Title: Oracle TCA- Techno-Functional Consultant

Job Type: Contract

Location: Mentor, OH(Day 1 Onsite)

Duration: Contract

Start Date: Immediate

About US At Vilwaa (, we are focused towards delivering IT services and solutions in Data Engineering, Cloud Infrastructure solutions , Digital Application Development, (IoT) - Internet of Things.

Title: Oracle TCA- Techno-Functional Consultant

Location: Mentor, OH(Day 1 Onsite)

Job Summary:

We are looking for a skilled Oracle Techno-Functional Consultant with expertise in Customer Master Data Design using Oracle Trading Community Architecture (TCA). We are integrating two Oracle EBS instances. The candidate will play a key role in designing and implementing robust, scalable Customer Master interface. The candidate will also design and implement Customer Master data migration between the two systems. This role requires close collaboration with business teams, solution architects, and developers to ensure data integrity, consistency, and usability across Oracle EBS applications.

Key Responsibilities:

  • Prepare technical design document for Customer interface between the two Oracle EBS instances.
  • Prepare technical design document for Customer data migration from one Oracle EBS instance to the master EBS instance.
  • Work with technical team to develop and test the Customer Master interface.
  • Work with technical team to develop and test the Customer Master migration scripts and process.
  • Develop and manage data migration strategies, including mapping, transformation, and validation.
  • Work with technical teams to develop APIs, custom solutions, and reports related to Customer Master.
  • Support User Acceptance Testing (UAT) and provide training and documentation to business users.
  • Troubleshoot and resolve customer data-related issues promptly.

Required Skills & Experience:

  • 6+ years of experience with Oracle EBS R12 applications in a techno-functional role.
  • Strong functional knowledge of Oracle TCA and related modules (AR, OM, CRM). This includes Customer account and party relationships.
  • Deep understanding of Customer Master data architecture, hierarchies, and lifecycle.
  • Proficiency in SQL, PL/SQL, Oracle APIs, and data conversion tools.
  • Hands-on experience with data migration, data cleansing, and third-party data integration.
  • Strong communication and stakeholder management skills.
  • Work with project manager to provide regular status and updates to project timeline.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.