Senior Oracle Techno-Functional Lead (Data & Integrations)

Solution IT Inc. is looking for a Senior Oracle Techno-Functional Lead (Data & Integrations) for one of its clients Dallas TX / Atlanta GA / Remote

Job Title: Senior Oracle Techno-Functional Lead (Data & Integrations)

Summary

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.

Required Skills

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).

3) Oracle Cloud Tools & Technologies (Hands-on)

• 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 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).

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.

Preferred / 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.

Work Site: Dallas TX / Atlanta GA / Remote

Duration: 6 months

Expected Start Date: Immediate - 2 weeks

Number of Positions: 01

Please send your responses back to

About Solution IT

Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston Massachusetts.