PLSQL Developer

2 months ago

Bloomfield, United States Tek Leaders Inc Full time

Title: PL/SQL Developer

Duration: 6 Months (Contract to Hire)

Location: Bloomfield CT

Responsibilities:

  • Should have experience working with large volumes like millions of rows and able to write complex queries and perform tuning.
  • Should be able to create a materialized view to refresh data from one database to another database on a daily/hourly basis.
  • Should have knowledge of create a data model for holding an online exam with normalization.
  • Should be able to create an oracle scheduler job to run a certain PL/SQL block with frequency of required time interval.
  • Should be able to find out a table size and find out for a given table where the data is being stored.
  • Experience in handling Oracle XML/JSON/CLOB data
  • Also having experience Python is an additional benefit for this role.

PL/SQL,Python,XML,JSON,CLOB,Performance Tuning

  • ODI Developer

    4 weeks ago

    Bloomfield, United States Diverse Lynx Full time

    Role: ODI Developer Location; Bloomfield, CT- Hybrid job (3 days onsite 2 days remote) Experience: 6-8 Year Duration: 12+ Months contract Role Description: DWH support experience using ODI.? Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization,...