Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
Optimum Solutions
  Company Profile
About Optimum

Optimum Solutions, is a full spectrum Software Solutions and Services Company.
Software services from Optimum are designed to deliver Enterprise Client-Server/
Multi-tier and Web based solutions across the entire value chain, spanning
on-site consulting services to turnkey software projects. Our technical expertise
and our delivery methodology, ensure our clients a customized solution that helps
drive their business profitability & productivity, with minimum time-to-market.

Managed by a core team of professionals previously from global and multinational
companies, Optimum is backed by extensive experience of these individuals spanning
areas such as IT consulting, Software Project Execution & Management, Quality
Management Systems, Marketing/Business Development and Human resources.
We have developed into a rapidly growing, highly competitive and responsive firm
with strong management, technical and financial resources and commitment to fully
serve its clients.

Quick Facts

Started in March 1997
A dedicated team of over 1000 professionals world wide
Servicing over 50 clients worldwide
Cumulative Annual Growth Rate (CAGR) of 40% over the last five years
Operations in Singapore, India, Thailand and USA.

  Job Details 

PL/SQL, Oracle Streams, ETL

Posted On:  7/5/2021 1:49:57 AM

PL/SQL, Oracle Streams, ETL

No. of vacancies:  1
Qualifications:  Bachelor's degree
Essential Skills: 
Not specified
Minimum Total Experience:  6
Job Tenure:  Full-time Only
Salary Offered:  Negotiable
Job Location:  Singapore Singapore Singapore

  Job Description
Functional Responsibilities:

* Feed analysis – Interact with business users and source system IT teams to define, agree, and document incoming data feed specifications.
* Data modeling – Interact with business users and middleware team to conform data sources into facts and dimensions of the star-schema data model. Conduct peer design reviews.
* ETL design – Design processes that transform and load data sources into fact and dimension tables according to best practices. Conduct peer design reviews.
* Development– Implement database and ETL programs according to design and coding standards. Conduct peer code reviews.
* Testing – Plan, execute, and document testing of database and ETL programs.
* User Support – Interact with end users in a support role to fulfill requests or resolve issues.
* Production Support – Provide off-hour and weekend support of application batch processes on a rotational, on-call basis.

Required Skills:

* Oracle 10g PL/SQL programming
* UNIX shell programming
* Database indexing and partitioning
* TKPROF analysis
* Multi-terabyte data warehousing
* Type 2 Slowly Changing Dimensions

Desired Skills:

* Near Real Time ETL
* Active / Volatile Data Warehousing
* Change Data Capture
* Oracle Streams
* Informatica 8.5 or later

Work experience/background:

5 to 10 years of application development experience, preferably in a large corporation with a demonstrated ability to navigate large, complex organizations to get work done.

  Contact Information
Reference Name (If Any): 

Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us