Oracle PLSQL Developer

Job Title: Oracle PL/SQL Developer

Experience: 5 Years (relevant 5 years of exp)

Job Type: Hybrid Mode (3 days a week)

Location: Bangalore / Coimbatore / Hyderabad

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 endusers

• 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 coordinate 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

Remote Work :

No