Oracle Technical Business Analyst

Net2Source (N2S) is seeking a Technical Business Analyst with a strong engineering mindset and hands-on capability in Oracle Cloud technologies. The role focuses on bridging business and technology to deliver reliable solutions in the loan/lease accounting domain, emphasizing data conversion and integration.

Responsibilities:

• 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
• 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
• 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
• Experience designing and/or implementing REST APIs (specs, payload design, versioning, idempotency, error handling)
• 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)
• 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
• 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

Requirements:

• 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
• 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
• 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
• Experience designing and/or implementing REST APIs (specs, payload design, versioning, idempotency, error handling)
• 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)
• 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
• 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
• 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