Oracle PL/SQL,Modeling

Mandatory Experience:

• Minimum 5+ years of experience in Oracle PL/SQL.
• Minimum 2 life cycle implementation projects.

Technical Skills:

• RDBMS Programming:
• Experience in Oracle RDBMS programming (MSSQL experience is a plus).
• Data Modelling:
• Experience in Data Vault 2.0 (Nice to have).
• End-to-End Project Experience:
• Worked on at least 2 end-to-end projects.
• Oracle SQL & PL/SQL Development:
• Expertise in developing solutions using Oracle SQL, PL/SQL, packages, views, materialized views, functions, procedures, and DBMS Jobs.
• Oracle Data Dictionary Objects:
• Proficient in working with Oracle Data Dictionary objects, including tables, views, synonyms, sequences, and user-defined types.
• Agile Methodology:
• Exposure to working in Agile methodology and documenting solutions in Confluence.
• Data Interfaces & ETL Processes:
• Experience in designing and implementing data interfaces and exchange mechanisms, including ETL processes and file transfer protocols (e.g., SFTP/FTP).
• Source Code Versioning:
• Knowledge of using SourceCode versioning tools like GIT and familiarity with the deployment process.
• Power BI & Oracle Apex:
• Knowledge of Power BI and Oracle Apex (2+ years).

Soft Skills:

• Communication Skills:
• Excellent written and verbal communication skills (formal and informal).
• Proactive & Self-Motivated:
• Flexible and proactive working style with strong personal ownership of problem resolution.
• Multitasking & Independence:
• Ability to multi-task under pressure and work independently with minimal supervision.