ESaaS - Oracle - Technical - PL/SQL Development

Job Description A senior-level PL/SQL Expert specializing in the Order-to-Cash (O2C) cycle and Oracle APIs. You will design, optimize, and maintain the backend core database architecture supporting Oracle Order Management, Service Contracts, and Oracle iStore. Your main focus will be writing high-performance code and building clean API integrations to handle complex transaction volumes.

Responsibilities Backend Development: Write, optimize, and maintain advanced PL/SQL packages, stored procedures, triggers, and functions within Oracle EBS R12.

• API Integration: Extensively utilize and customize Oracle Standard Public APIs (e.g., Order Import API, Pricing API, Customer API) to integrate custom web applications and iStore with backend modules.
• O2C Lifecycle Support: Own the technical processing of the complete Order-to-Cash cycle, ensuring data integrity from online order capture down to invoicing and service contract generation.
• Data Modeling & TCA: Work deeply with Oracle’s Trading Community Architecture (TCA) schema to manage and manipulate party, account, and relationship data.
• Performance Tuning: Conduct code reviews and perform rigorous SQL/PL/SQL tuning (using TKPROF, Explain Plan) to maximize system throughput.

Qualifications Mandatory Experience: Proven track record in Order-to-Cash (O2C) processing and extensive experience developing/consuming Oracle EBS Core APIs.

• Core Technical Skills: Expert-level PL/SQL, advanced SQL, database design, and performance tuning tools.
• Module Expertise: Deep database-level knowledge of Oracle R12 Order Management (OM), Service Contracts, Accounts Receivable (AR), and TCA.
• Experience: 8+ years of core Oracle PL/SQL development experience in a high-volume enterprise environment.

About Us At Zensar, we’re “experience-led everything” . We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures . Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus . Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.