Tata Consultancy Services

Oracle EBS (R12) Technical Consultant

Tata Consultancy Services • $100K — $120K *
Cleveland, OH 44130In-Person
Information Technology
Less than 5 years of experience
More than 3 months ago
Job Overview by Ladders

Qualifications

  • 5-7 years of hands-on experience with Oracle EBS R12 architecture.
  • Proficient in PL/SQL, SQL, and Unix shell scripting.
  • Experience with Oracle APIs and data migration tools.
  • Knowledge of Oracle Forms, Reports, Workflow, and OAF is preferred.
  • Experienced in ETL processes and managing large data volumes.

Responsibilities

  • Analyze data structures of legacy systems and develop conversion strategies.
  • Create staging tables and validation scripts for data migration.
  • Prepare comprehensive test cases for various testing phases.
  • Conduct unit, system integration, user acceptance, and cutover testing.
  • Perform data quality checks to ensure integrity during migration.
  • Collaborate with functional consultants to confirm data meets business rules.
  • Communicate progress, risks, and issues effectively with stakeholders.

Benefits

  • Discretionary annual incentive opportunities.
  • Comprehensive medical, dental, and vision coverage.
  • Generous family support including maternal and parental leave.
  • Convenient commuter benefits and training reimbursement.
  • Robust time-off policies including vacation and sick leave.
  • Access to legal assistance and 401K plan options.
Full Job Description
Must Have Technical/Functional Skills
• Strong experience in Oracle EBS R12 architecture.
• Expertise in PL/SQL, SQL, Unix shell scripting.
• Experience using Oracle APIs, open interfaces, and data migration tools.
• Knowledge of Oracle Forms, Reports, Workflow, and OAF (optional but preferred).
• Familiarity with ETL processes and large-volume data handling.
• Analyze legacy system data structures and define conversion strategy and mapping rules.
• Create staging tables, validation scripts, and automated data transformation routines.
• Prepare test cases for dry runs and reconciliation.
• Conduct unit, system integration, UAT, and cutover testing.
• Perform data quality checks before and after migration.
• Work with functional consultants to ensure converted data meets business rules.
• Prepare conversion design documents (MD50, MD70), mapping sheets, and validation scripts.
• Maintain conversion logs, error reports, and reconciliation sheets.
• Provide go live cutover support and post production troubleshooting.
• Work with cross-functional business teams to gather requirements.
• Coordinate with DBAs and infrastructure teams on performance tuning.
• Communicate progress, risks, and issues to project managers and stakeholders.
• Customize/debug: o Forms, Reports (BI Publisher / XML Publisher) o Oracle workflow & Concurrent programs

Generic Managerial Skills, If any
• Customer facing Role and interacting between various stakeholders, Vendors and offshore team

Base Salary Range : $100,000 to $120,000 Per Annum

TCS Employee Benefits Summary: Discretionary Annual Incentive. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. Family Support: Maternal & Parental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SV2 #LI-KUMARAN

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Tata Consultancy Services

  • Tata Consultancy Services
    Technical Lead -Oracle
    $100K — $130K *
    Cincinnati, OH 45238 (Hamilton County)
    Reposted Today
    Retail & Consumer Goods
    In-Person
  • Tata Consultancy Services
    Aftermarket Parts Consultant
    $120K — $140K *
    Detroit, MI 48228 (Wayne County)
    Today
    Technical Services
    In-Person
  • Tata Consultancy Services
    Multi Cloud Architect
    $94K — $120K *
    San Jose, CA 95123 (Santa Clara County)
    Today
    Enterprise Technology
    In-Person
  • Tata Consultancy Services
    Senior GCP Data Engineer
    $110K — $140K *
    Atlanta, GA 30349 (Fulton County)
    Reposted Today
    Information Technology
    In-Person
  • Tata Consultancy Services
    Engineer
    $100K — $125K *
    Pittsburgh, PA 15237 (Allegheny County)
    Today
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Oracle EBS (R12) Technical Consultant jobs:

NationwideCleveland, OH