Staff Software Engineer

Responsibilities:

• Design, build, and maintain reporting solutions in Oracle Fusion.
• Design, develop, and deploy reporting solutions in Oracle Fusion Cloud.
• Preferably have worked on supply chain, supplier, GL, AP financials, and modules.
• Translate complex business and technical requirements into robust reporting solutions, working with technical and business teams.
• Diagnose and resolve complex production issues through root-cause analysis and system optimization.
• Drive technology and process improvements by evaluating emerging tools and best practices.
• Ensure adherence to enterprise architecture, security, compliance, and performance standards.
• Maintain technical documentation, user guides, and solution specifications.

Requirements:

• Experience with design and development/maintenance of reporting solutions using BI Publisher (BIP), OTBI, and Oracle Analytics Cloud (OAC).
• Experience with writing complex SQL and tuning queries.
• Strong data analysis and troubleshooting skills.
• Support SIT/UAT testing, reconciliation, and report validation.
• Assist with go-live reporting activities.
• Extensive experience in creating stored procedures, functions, packages, triggers, and other database objects using SQL and PL/SQL.
• Design, develop, and support orchestration of large-scale OIC integrations (e. g., app-driven, scheduled, and file-based) across Oracle Fusion and 3rd party systems.
• Build and maintain integrations using OIC Adapters, including REST, SOAP, FTP, ERP cloud, and database.
• Develop complex data mappings and transformations in XSLT for large payloads.
• Robust error handling, reprocessing strategies, and secure integrations using appropriate security models.
• AI Skills (Mandatory): Proficiency in leveraging AI tools for daily engineering tasks to enhance productivity, optimize effort, and ensure cost-aware AI assistance.

Nice to Have:

• Experience with GitHub.
• Familiarity with enterprise data warehousing databases such as BigQuery.
• Experience with developing AI agents in Oracle