JPC-22185 - PLSQL
Job Posted: May 14, 2024 | Total views: 1

Job Description:

• Job Description

   

  5-8+ years of experience in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance.

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

  • Strong experience to integrate data feeds to/from other applications using shell scripting and MFT servers.

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

  • Analyze application requirements and provide recommended design. Support code migration from development to staging environment.

  • 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

  • Written mod-PL/SQL that has been used to provide front end web user interface using http commands

About Company :
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.

We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.

Company Info: