PlSQL 1227940

2 weeks ago

Mumbai, Maharashtra, India Sage IT India Full time
Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling. Create database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer, toad.

  • Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file format.
  • Experience to establish connectivity to MFT server to load/unload files. Troubleshoot issue with file receive/send.
  • Extensive experience in trouble shooting, Query Optimization and performance tuning use of explain plans.
  • Experience in using the features Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic SQL and Oracle RAC.
  • Experience to write scheduler jobs and Troubleshoot issue if any failures.
  • Write complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Ability to work independently and as part of a team, deliver under pressure and tight deadlines.
  • Experience in writing shell script for data integration and configuration. Ability to enhance/modify script for data loading. Troubleshoot issue related to MFT connectivity, load data to database etc.
  • Developers should have experience with basic web technologies, such as html, xml, CSS, Java script.
  • Good to have skills

  • PlSQL 1227940

    2 months ago

    Mumbai, India Sage IT India Full time

    Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling. Create database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer, toad. - Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file...