Oracle Technical Business Analyst

Net2Source (N2S); United States; Remote; USD 82,656 - 89,544; Full time

Job summary

A contracting firm seeks a Technical Business Analyst to support Oracle Cloud data integration processes. The ideal candidate should possess strong SQL and PL/SQL skills, experience with API and event-driven architectures, and financial domain knowledge. This remote role offers a long-term contract with competitive pay rates on W2 or C2C basis. Candidates will work in Agile teams to drive effective solutions through data migration, process mapping, and requirement specifications.

Qualifications

• Proven experience as a Business Analyst in technical delivery teams.
• Comfortable working directly with developers and business stakeholders.
• Hands-on experience with migration/conversion projects.

Responsibilities

• Elicit requirements, translate them into functional specs.
• Design secure integrations and manage connectivity.
• Build repeatable conversion runs and manage cutover activities.

Skills

SQL

PL/SQL

Oracle Cloud technologies

API integration

Event-driven architecture

Financial controls

GitHub

Tools

Oracle Integration Cloud (OIC)

Kafka

Job description

Overview

Job Title: Oracle Technical Business Analyst (Oracle Cloud, Data & Integration)

Job Location: Remote

Job Duration: Long-term Contract(12+ months)

Pay rate: $60/hr on W2 & $65/hr on C2C

Job Description:

Seeking a Technical Business Analyst with a strong engineering mindset and deep hands-on capability across SQL/PL/SQL, Oracle Cloud technologies, and modern integration patterns. This role bridges business (loan/lease accounting domain) and technology (data conversion/migration, APIs, event streaming) to deliver high-volume, reliable solutions with strong SDLC discipline and CI/CD practices.

Responsibilities

1) Core Business Analyst + Technical Execution

• Proven experience operating as a Business Analyst in technical delivery teams (Agile/Scrum preferred).
• Ability to elicit requirements, translate them into functional/technical specs, and drive traceability through implementation and testing.
• Strong skills in process mapping, data mapping, gap analysis, user stories/acceptance criteria, and stakeholder management.
• Comfortable working directly with developers, architects, QA, and business SMEs to resolve ambiguities and make delivery decisions.

2) Advanced SQL / PL/SQL (Hands-on)

• Extensive hands-on experience writing and optimizing complex SQL (joins, analytics/window functions, CTEs, performance tuning).
• Strong PL/SQL development: packages, procedures/functions, triggers (where appropriate), exception handling, bulk operations.
• Experience with query tuning, indexing strategy, execution plan analysis, and handling large datasets/high throughput workloads.
• Data quality and reconciliation skills (counts, balances, controls, audit trails).
• Working experience with Oracle Cloud ecosystem relevant to data/integration (e.g., Oracle Integration Cloud (OIC), OCI services, Oracle REST/Data Services (ORDS), Autonomous Database, object storage, scheduling/orchestration tools).
• Ability to design secure integrations, manage connectivity, and support operational monitoring/troubleshooting in cloud environments.
• Exposure to Oracle SaaS integration patterns is a plus (if applicable to your environment).

4) Migration / Conversion Experience

• Demonstrated delivery experience in data migration/conversion projects (legacy to Oracle/Cloud preferred).
• Ability to define mapping rules, transformation logic, validation controls, and reconciliation strategies.
• Experience building repeatable conversion runs, managing cutover activities, and supporting parallel runs.
• Familiarity with ETL/ELT approaches and handling source system anomalies.

5) API & Event-Driven Integration (High Volume)

• Experience with event-driven architecture using Kafka (or equivalent: Confluent, Pulsar, Kinesis, etc.) for high-volume transaction processing.
• Understanding of distributed systems concerns ordering, retries, deduplication, exactly-once/at-least-once semantics, back-pressure, monitoring.
• Ability to write or partner closely on integration code and define non-functional requirements (latency, throughput, reliability).

6) Accounting + Loan/Lease Domain Knowledge

• Solid exposure to accounting principles and financial controls (e.g., GL impacts, accruals, reconciliation, auditability).
• Domain experience in loan/lease lifecycle concepts (origination, servicing, amortization schedules, interest calculations, fees, delinquency, payoff, asset/lease accounting concepts).
• Ability to communicate with finance stakeholders and translate accounting requirements into data and system behavior.

7) Development Tooling & Modern SDLC

• Hands-on use of GitHub (branching strategies, pull requests, code reviews, issues).
• Experience with CI/CD pipelines (build/test/deploy automation; environment promotion; release controls).
• Comfortable developing and collaborating using VS Code; practical experience leveraging AI-assisted development tools to accelerate delivery while maintaining quality.
• Familiarity with testing practices: unit/integration testing concepts, data validation testing, and automation is a plus.

Nice-to-have

• Experience with Oracle performance tuning at scale and/or cloud cost optimization.
• Knowledge of security best practices (secrets management, OAuth2/JWT for APIs, least privilege access).
• Experience with observability tooling (logging, metrics, tracing) for APIs and Kafka pipelines.
• Prior work in regulated environments requiring audit trails and strong controls.