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