Oracle Cloud Conversion Sr Developer

Role overview This role focuses on designing and executing the technical solutions that move legacy data into Oracle Cloud for federal clients. The work spans data conversion strategy, complex SQL and PL/SQL development, validation, and ownership of load cycles from mock runs through production cutover. It is a senior individual-contributor position with mentorship responsibilities, partnering closely with functional consultants, business analysts, and client stakeholders to ensure data integrity throughout the migration lifecycle.

Responsibilities - Lead the technical design of data conversion strategies and produce detailed source-to-target mapping documents for complex data objects. - Develop, test, and optimize complex SQL queries, PL/SQL packages, and ETL processes that transform and cleanse legacy data into Oracle Cloud-compatible formats using FBDI and HDL. - Own the execution of data load cycles, including mocks, dress rehearsals, and production cutover, ensuring all technical dependencies are met. - Troubleshoot and resolve complex technical issues, data errors, and performance bottlenecks during conversion, serving as the final point of technical escalation. - Design and implement robust data validation and reconciliation processes, including scripts and reports that confirm accuracy and completeness post-load. - Mentor junior developers, conduct code reviews, and establish technical best practices for the team. - Collaborate with functional leads, business analysts, and client SMEs to interpret requirements, define transformation logic, and support data cleansing.

Requirements - 3–5 years of hands-on experience in data conversion or migration for Oracle Fusion Cloud across ERP, SCM, or HCM. - Expert-level proficiency in SQL and PL/SQL for complex extraction, transformation, and validation. - Proven experience leading technical data conversion activities through multiple full project lifecycles. - Hands-on experience with Oracle Cloud data loading tools, including FBDI and HDL. - Strong understanding of ETL principles and the full data migration lifecycle, from analysis through post-go-live support. - U.S. citizenship is required.

Nice to have - Experience with Oracle Integration Cloud (OIC) or enterprise ETL tools such as Informatica. - Background in federal, regulated, or public sector environments. - Skills in performance tuning of SQL and data loading processes. - Client-facing or consulting experience with strong communication and leadership skills.

Benefits and work setup - Posted base pay range of $106,300–$206,200 USD, with compensation varying by location, role, skill set, and experience. - Wide variety of benefits available, with detailed information provided during the hiring process. - Equal employment opportunity employer with affirmative-action commitments to veterans and individuals with disabilities.