Oracle PL/SQL Developer

Oracle PL/SQL Developer | 5+ Years | Bangalore | Hybrid | SOW 2024 - 2462

Job Title: Oracle PL/SQL Developer

Experience: 5+ Years (relevant 5 years of exp)

Job Type: Hybrid Mode (3 days a week)

Location: Bangalore

Time Zone: IST time

Project Name: -

Client: Bosch

End Client: Bosch (Internal project)

Mandatory Skills:

• Oracle P/SQL.
• Oracle SQL, PLSQL, package, views, materialized views, functions, procedures and DBMS Jobs.
  
• Data Analytics and Data Engineering Applications.
  
• Knowledge in DevOps.
• Experience on working on Cross Domain Data models.
  
• Experience in working in Agile methodology.



Good to have skills:

• Power BI
• Oracle APEX
  
• Knowledge on Extract Transform & Load (ETL) Tools
  
• Knowledge on Azure Synapse
  



Job Description:

• Minimum 5+ years of experience in Oracle PL/SQL

• Minimum 2 life cycle implementations projects

• Conduct code reviews and participate in technical design

• Analyze complex business problems, track down required information, document requirements, and develop technical solutions

• Establish and enforce quality, security, and compliance requirements

• Develop business applications using Oracle, PL/SQL

• Lead and participate in highly complex projects with customers, managers and end-users

• Resolves complex hardware/software compatibility and interface design considerations

• Designs, develops, codes, tests, and debugs complex new software products, or makes significant enhancements to existing items

• Leads, analyzes, designs, develops, and implements modules under limited supervision performs additional duties as assigned

• Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.

• Must be a good team player and lead wherever possible.

• Should be capable of doing Unit testing and support end users/customer during UAT.

• Ability to understand complex issues and facilitate resolution.

• Excellent skills in developing solution using Oracle SQL, PLSQL, package, views, materialized views, functions, procedures and DBMS Jobs.

• Excellent written, verbal and presentation communication skills

• Should have exposure to work in Agile methodology and documentation the solution in confluence.

• Nice to have knowledge on Extract Transform & Load (ETL) Tools

• Experience in understanding business requirement and creating design, data model to get the desired end objective.

• Must be good in Data Analysis and can troubleshoot any issues in query performance.

• Ability to co-ordinate and discuss with Architecture team on review and getting approval of all the solution design.

• Knowledge on Power BI and Oracle Apex would be an added advantage.

• Experience on working on Cross Domain Data models.

• Must possess knowledge on using SourceCode version tool, i.e. GIT, and should know about deployment process.



Skill Set Matrix:

------------------------------------------------------------------------
Skills                   | Year of experience | Remarks | Expertise
------------------------------------------------------------------------
Oracle PL/SQL  - 5+   - Mandatory         - Expert
PowerBI             - 2     - Good to have     - Intermediate
Oracle Apex      - 2     - Good to have     - Intermediate
ETL Tools          - 2     - Good to have     - Intermediate
------------------------------------------------------------------------