Requirement
- Design & Develop BIRT Actuate eSpreadsheet (BI Tool) reports with Oracle PL/SQL as backend.
- Work on Performance Tuning of Sql queries.
- Work with Procedures, Packages, Triggers using Oracle Tools like TOAD, Pl/SQL, SQL*Plus, MariaDB.
- Planning and coding of new module or enhancements.
- Involve in backend SQL coding.
- Involve in data migration activity to migrate data from one source to application which involves PL/SQL concepts.
Requirements:
- Minimum of 5 years of experience in IT field.
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- Experience in using Toad for developing procedures, packages in Pl/SQL.
- Experience in backend SQL coding.
- Experience in developing backend datamart / datawarehouse applications
- Experience in Python programming Python used for loading files to tables and manipulation of data. Python, s Pyspark,
- Experience in UNIX and writing Shell Scripts for Oracle Development.
- Experience in ETL using shell scripting.
- Expertise in Manual, Performance and Functional Testing of reports.
- Prepared High Level Documents (HLDs) and Low level Documents (LLDs).
