Oracle PlSQL

2 weeks ago

Noida, India Iris software Full time

**JD**:
**SQL;**
- **Must be good in writing SQL queries and knowledge about Oracle data various dictionary and their significance.**:

- **Should have knowledge and hands-on (added) in performance tuning**:

- **Should have knowledge various Oracle database attributes**:

- **In depth knowledge and hands-on**:

- **Joins : INNER, LEFT, RIGHT, FULL, CARTESION join of two or more tables**:

- **Aggregate Functions : COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG**:

- **Analytic Function : LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER**:

- **View and Materialized Views : Basics of creating and maintaining views**:

- **Hierarchical queries : Data retrieval from table having hierarchical data**:

- **Oracle SYS tables : Basic knowledge on Oracle metadata tables**:

- **Privileges : How Role/Object level privileges works**:

- **Complex Queries : Nested queries, inline views, co-related subqueries**:

- **Data Types : Different types of oracle defined data types and their usage (especially CLOB, BLOB, LONG)**:

- **Table Partitioning : Basic knowledge on table & index partitioning**:

- **Oracle Functions : NVL, NVL2, DECODE, GREATEST, COLLESCE,**:
***

**PL/SQL;**
- **PL/SQL Objects : Create and maintain objects like procedures, functions, packages, types, triggers,**:

- **Recursion, Loops (FOR, WHILE DO), Nested blocks, conditional logic (IF, CASE statements)**:

- **Exception handling : Knowledge on how to manage run time oracle defined/user defined errors**:

- **Collection & Records : Ways of using collection and records in PL/SQL blocks**

**BULK operation : Knowledge on performing operations on bulk**

**Job Summary**:
**Role Based Competencies**:

- Tech - Requirement Management S/W- Tech - NFR- Tech - High level design- Tech - Code quality and coding standards- Beh - Result Orientation- Tech - Code Reviews- Tech - Build Management- Tech - Unit Testing- Beh - Information Seeking- Tech - Agile Methodology- Tech - Analytical \ Problem Solving- Beh - Communication- Beh - Customer Orientation- Beh - Collaboration**Mandatory Competencies**:

- Database - PL SQL**Good to Have Competencies**:

  • Oracle, SQL/plSQL

    2 weeks ago

    Noida Sector 16, Noida, Uttar Pradesh, India Neuheit Technologies Full time

    1. Analyze system requirements and prioritize tasks 2. Write clean, testable code using programming languages 3. Develop technical specifications and architecture including documentation - Review and refactor code 6. Proficiency in creating DB Design and building Oracle DB Objects\ 7. In-depth knowledge of SQL and PLSQL 9. SQL: Good exposure and...

  • Oracle Fusion ERP Expert-Finance

    2 days ago

    Noida, India Oracle Full time

    Job Description As a Support Engineer within Oracle Customer Success Services, you will troubleshoot and resolve complex techno-functional challenges related to Oracle Cloud Financials. Drawing on your extensive functional and technical expertise, you'll engage directly with customers to analyze problems, provide actionable advice, and ensure optimal...

  • D2K Developer

    3 weeks ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years...

  • D2K Developer

    3 weeks ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years...

  • D2K Developer

    3 weeks ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years...

  • D2K Developer

    2 days ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developerExperience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 DaysAbout the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years of...

  • D2K Developer

    2 weeks ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years...

  • D2K Developer

    3 weeks ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: - Oracle Forms and Reports - Oracle PLSQL Requirements: - Bachelor’s in any tech field - 1–4...

  • D2K Developer

    6 days ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: - Oracle Forms and Reports - Oracle PLSQL Requirements: - Bachelor's in any tech field - 1–4...

  • D2K Developer

    4 days ago

    Noida, India Eastern Software Solutions Full time

    Job Title: D2K developer Experience - 1-5 Years Job Location: Lotus Business Park, Noida 127 Work Mode: Onsite Working Days: 5.5 Days About the Role: We are seeking a D2K Developer having experience of oracle forms and reports, Oracle PLSQL etc. Responsibilities: Oracle Forms and Reports Oracle PLSQL Requirements: Bachelor’s in any tech field 1–4 years...