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.
Title:
PL/SQL, Oracle Streams, ETL
Posted On:
7/5/2021 1:49:57 AM
Designation:
PL/SQL, Oracle Streams, ETL
No. of vacancies:
1
Qualifications:
Bachelor's degree
Minimum Total Experience:
6
Job Tenure:
Full-time Only
Salary Offered:
Negotiable
Job Location:
Singapore
Singapore
Singapore
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.