Oracle PL/SQL,Modeling

PradeepIT Consulting Services Pvt Ltd; Bengaluru; On-site; INR 900,000 - 1,200,000; Full time

Job summary

A leading consulting firm is seeking a skilled Oracle PL/SQL Developer in Bengaluru with over 5 years of experience. The role requires expertise in developing solutions and implementing data interfaces. Candidates should have excellent communication skills and experience working in Agile projects. If you have knowledge of Power BI and Oracle Apex, we want to hear from you.

Qualifications

• Minimum 5+ years of experience in Oracle PL/SQL.
• Minimum 2 life cycle implementations projects.
• Excellent communicator (written and verbal).
• Knowledge on Power BI and Oracle Apex - 2+ years.

Responsibilities

• Develop solutions using Oracle SQL, PL/SQL, and procedures.
• Design and implement data interfaces and ETL processes.
• Document solutions in Confluence.

Skills

Oracle PL/SQL

RDBMS programming

Data Vault 2.0

Oracle SQL

Agile methodology

ETL processes

GIT

Job description

Overview

Minimum 5+ years of experience in Oracle PL/SQL. Minimum 2 life cycle implementations projects. Experience of working on at least 2 end-to-end project. Excellent communicator (written and verbal, formal and informal).

Knowledge on Power BI and Oracle Apex- 2+Years

Technical Skills

• Experience in RDBMS programming (Oracle) (addition MSSQL nice to have)
• Experience in data modelling & Data Vault 2.0 (Nice to have)
• Excellent skills in developing solutions using Oracle SQL, PLSQL, package, views, materialized views, functions, procedures and DBMS Jobs
• Proficient in Oracle Data Dictionary objects, including tables, views, synonyms, sequences, and user-defined types
• Exposure to work in Agile methodology and documentation of the solution in Confluence
• Experience in designing and implementing data interfaces and exchange mechanisms, including ETL processes and file transfer protocols (e.g., SFTP/FTP)
• Must possess knowledge on using SourceCode version tool, i.e. GIT, and should know about deployment process
• Ability to multi-task under pressure and work independently with minimal supervision

Additional soft skills: Flexible and proactive/self-motivated working style with strong personal ownership of problem resolution