3 Plsql Packages Jobs

You will be responsible for developing/enhancing objects in Oracle Data Integrator (ODI), RPD, and OACS Reports & Analyses. Your role will involve providing end-to-end solution architecture for integrating Oracle ERP and SCM Cloud applications using ODI and OACS. You will be tasked with ODI ELT Data Load Scheduling, Monitoring, and Troubleshooting, as well as applying data fixes. Furthermore, you will need to coordinate with the onshore team by setting day-to-day execution targets. Your expertise will be crucial in integration architecture design, solutions selection, implementation, and continuous technical improvement. Collaboration with a cross-functional team to resolve issues and guide team members to successful delivery will also be part of your responsibilities. To qualify for this role, you must have at least 5 years of demonstrable hands-on development experience using standard SDLC and/or Agile methodologies in an ODI/OACS/PLSQL developer role. Additionally, you should have 5+ years of experience in extracting data from Oracle ERP/SCM. Proficiency in developing ETL processes, such as ETL control tables, error logging, auditing, data quality, etc., and implementing reusability, parameterization, workflow design, is essential. Expertise in the Oracle ODI 12c toolset, Oracle PL/SQL, RPD, OACS, BICC, BI Publisher, as well as knowledge of data modeling and ETL design, are required. You should be able to integrate ODI with multiple sources and targets and have experience in error recycling/management using ODI. Strong knowledge of database objects development (SQL/PLSQL) and ELT/ETL concepts, design, and coding is expected. Moreover, expert knowledge of OBIEE/OAC RPD design and BI analytics reports design is necessary. Familiarity with BI Apps will be an advantage. Experience in creating PL/SQL packages, procedures, functions, triggers, views, materialized views, and exception handling for retrieving, manipulating, checking, and migrating complex datasets in Oracle is crucial. Your role will also involve devising partitioning and indexing strategies for optimal performance, leading support & development projects, and possessing good verbal and written communication skills in English. Strong interpersonal, analytical, and problem-solving abilities are essential. Any certifications in ODI or OACS will be a plus. Good knowledge of Oracle database and development experience in database applications, along with traits such as creativity, personal drive, influencing and negotiating skills, and problem-solving capabilities, are desired attributes for this role.,

A Senior Consultant at OpenSymmetry is responsible for configuring and troubleshooting performance management solutions to meet client's business and technical needs. You will serve as the primary technical contact, managing the relationship between OpenSymmetry and clients in India and the APAC region. The role involves supporting and troubleshooting solutions in a live production environment, participating in the software implementation lifecycle, and mentoring junior team members. As a Senior Consultant, you will play a key role in investigating issues, conducting root cause analysis, and resolving defects for a diverse clientele. This position offers a rewarding career path with opportunities for client interaction, mentorship, and leadership development. Working alongside experts in the field, you will collaborate as part of a dynamic team at OpenSymmetry. Job Objectives: - Configure SAP Callidus platform and translate business requirements into workflow processes - Design user interfaces and understand compensation rules and attribute mapping - Utilize hands-on experience in Callidus Commissions, SQL, and database table design - Take ownership of specific project deliverables across different phases - Provide timely responses to customer requests and effectively communicate with clients and project teams - Apply knowledge of the software development lifecycle and contribute to requirements and design documentation - Conduct configuration per design specifications and offer support during testing phases - Solve complex problems and share expertise on incentive compensation and other relevant practices with colleagues Requirements: - Bachelor's degree or equivalent work experience - 4+ years of experience in configuring Callidus/SAP Commissions - Proficiency in Java, JavaScript, Groovy scripting, and Callidus Workflow Framework - Experience in creating workflows, forms, APIs, and custom email notifications - Expertise in SQL, PL/SQL procedures, and packages - Previous consulting or support experience - Advanced skills in Excel and spreadsheet software - Excellent communication skills in writing, listening, and speaking Benefits: Join us at OpenSymmetry and enjoy: - Engaging company culture and values - Opportunities for professional growth and development - Competitive salary, social security benefits, and insurance coverage - Access to indoor games, a fully equipped gym, and flexible work schedule for work-life balance If you are an experienced consultant looking for a challenging and fulfilling career, apply today and embark on an exciting journey with OpenSymmetry!,

Enphase Energy is a global energy technology company and a leading provider of solar, battery, and electric vehicle charging products. Founded in 2006, Enphase has revolutionized the solar industry with its innovative microinverter technology, which efficiently converts sunlight into a safe, reliable, and scalable energy source. The Enphase Energy System empowers individuals to generate, utilize, store, and even sell their own power. With approximately 68 million products deployed in over 145 countries, Enphase stands as one of the fastest-growing and most innovative clean energy companies globally. At Enphase, we are dedicated to designing, developing, and manufacturing next-generation energy technologies. Our work environment is dynamic, engaging, and filled with exciting new projects. If you are passionate about driving a more sustainable future, now is the ideal time to become part of the Enphase team. The role of an Oracle Technical Developer (OIC) at Enphase involves supporting existing custom solutions and processes developed in PaaS/SaaS environments. As a candidate, you will collaborate with multiple applications and business units to deliver projects and objects efficiently. This position falls under the IT ERP team and reports to the Integration Lead. Key Responsibilities: - Proficiently develop solutions using Oracle PaaS products, including VBCS and OIC for integrations - Demonstrate expert knowledge in Oracle JET and other JavaScript frameworks - Understand Oracle Cloud Infrastructure (OCI) architecture - Ensure data security in Oracle Cloud SaaS and OCI application integrations - Familiarity with Oracle ERP and SCM functionalities and processes - Utilize Oracle Cloud ERP and SCM APIs/web services effectively - Extensive experience with SOAP/REST Web services, XML, WSDL, XSLT, and XSD - Ability to enhance, debug, and develop SQL and PL/SQL BI reports related to Oracle Financial and SCM modules - Proficiency in building PL/SQL packages in ATP DB/DBCS environments - Follow the full lifecycle SDLC process, including technical design, build, and unit testing for complex requirements - Perform performance tuning, testing, and diagnosis of OIC integrations - Experience with deployment and release management processes in OIC - Strong technical problem-solving skills and the ability to work independently or in a team-oriented setting - Excellent communication skills and the ability to deliver high-quality work Requirements: - A full-time Bachelor's degree with 5-8 years of relevant experience - Minimum 7 CGPA is mandatory - Proficiency in Oracle Integration Cloud (OIC), Oracle BIP with SQL and PL/SQL, Oracle Cloud PaaS Visual Builder (VBCS), Oracle PL/SQL in ATP DB, and Oracle ERP Fusion - Strong analytical, problem-solving, and quantitative skills - Proactive, highly motivated, and adaptable - Excellent oral, written, and interpersonal communication skills - Hybrid working mode from the Bangalore office Join Enphase and contribute to shaping a sustainable future through innovative energy technologies!,