Oracle EBS (R12) Technical Consultant jobs in United States
cer-icon
Apply on Employer Site
company-logo

Tata Consultancy Services · 11 hours ago

Oracle EBS (R12) Technical Consultant

positionCleveland, OH
timeFull-time
remoteOnsite
seniorityMid Level
money$100K/yr - $120K/yr

Tata Consultancy Services is seeking an Oracle EBS (R12) Technical Consultant. The role involves strong technical expertise in Oracle EBS architecture, PL/SQL, and data migration tools, along with responsibilities in data quality checks, testing, and working with cross-functional teams.

Business Information SystemsConsultingInformation TechnologyIT Management
check
H1B Sponsor Likelynote

Responsibilities

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:
Forms, Reports (BI Publisher / XML Publisher)
Oracle workflow & Concurrent programs
Customer facing Role and interacting between various stakeholders, Vendors and offshore team

Qualification

Oracle EBS R12 architecturePL/SQLSQLUnix shell scriptingOracle APIsData migration toolsOracle FormsOracle ReportsETL processesData quality checksCustomer facing roleCommunication skills

Required

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
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: Forms, Reports (BI Publisher / XML Publisher), Oracle workflow & Concurrent programs
BACHELOR OF COMPUTER SCIENCE

Preferred

Knowledge of Oracle Forms, Reports, Workflow, and OAF (optional but preferred)

Benefits

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.

Company

Tata Consultancy Services

twittertwittertwitter
Glassdoor3.8
company-logo
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
dateFounded in 1968
location
Mumbai, Maharashtra, IND
people-size10001+ employees
web-link
http://www.tcs.com

H1B Sponsorship

Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)

Funding

Current Stage
Public Company
Total Funding
unknown
2004-08-25IPO

Leadership Team

leader-logo
K. Krithivasan
Chief Executive Officer & Managing Director
linkedin
leader-logo
Aarthi Subramanian
President and Chief Operating Officer

Recent News

The Hindu
Nifty IT drops up to 6% on Anthropic tool launch
2026-02-05
Investing.com
Anthropic’s AI push raises analyst concerns over IT services revenues
2026-02-05
The Hindu
IT stocks slump; Infosys dives over 7%
2026-02-05
Company data provided by crunchbase