Home  |  Contact  |  About Us
Register  |  Sign In        

Oracle ETL Developer

col-narrow-left   

Location:

Johannesburg, Gauteng 

Suburb:

Sandton

Salary:

Market Related

Posted:

10-10-2018
col-narrow-right   

Job Type:

Permanent, Contract

Job Level:

Skilled

Employment Equity:

South African Citizens Only
col-wide   

Job Description:

PBT Group has a requirement for experienced ETL Developers with strong Oracle PL/SQL experience. Financial industry experience would be a huge advantage.

REQUIRED SKILLS:
  • In-depth knowledge of Oracle PL/SQL as an ETL tool.
  • Experience with Informatica would be a major advantage.
  • Intimate knowledge of source systems as well as a basic understanding of dimensional models.
  • Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models.
  • A sound knowledge of the programming language used to write the data staging programs or ETL tool.
  • A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool.
  • A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.
  • Pride of work, thoroughness and attention to detail.

REQUIRED QUALIFICATIONS / TRAINING:
  • Course on the ETL / related toolset.
  • Relevant data warehouse and BI solution training is essential.
  • B.Sc. or related degree is advantageous.
  • 2+ years programming experience.

DUTIES:
  • Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.
  • Conduct planning, analysis and design activities in conjunction with other development specialists.
  • Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.
  • Participate in estimation of tasks and assist in the development of project plans.
  • Code or makes modifications to programs of high complexity, according to specifications.
  • Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.
  • Conduct walkthroughs and quality review of deliverables.
  • Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
  • Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.
  • Participate in the formulation of standards to support the data acquisition development process.
  • Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.
  • Ensure compliance with established policies, standards and methodologies.

Job Category:

Business Intelligence, Data Warehouse, Database Developer, IT Consultant
Company Info
PBT Group
Johannesburg, GP, South Africa

Please register to view contact info


Company Profile



Company Info


PBT Group
Johannesburg, GP, South Africa

Please register to view contact info


Oracle ETL Developer

col-narrow-left   

Location:

Johannesburg, Gauteng 

Suburb:

Sandton

Salary:

Market Related

Posted:

10-10-2018
col-narrow-right   

Job Type:

Permanent, Contract

Job Level:

Skilled

Employment Equity:

South African Citizens Only
col-wide   

Job Description:

PBT Group has a requirement for experienced ETL Developers with strong Oracle PL/SQL experience. Financial industry experience would be a huge advantage.

REQUIRED SKILLS:
  • In-depth knowledge of Oracle PL/SQL as an ETL tool.
  • Experience with Informatica would be a major advantage.
  • Intimate knowledge of source systems as well as a basic understanding of dimensional models.
  • Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models.
  • A sound knowledge of the programming language used to write the data staging programs or ETL tool.
  • A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool.
  • A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.
  • Pride of work, thoroughness and attention to detail.

REQUIRED QUALIFICATIONS / TRAINING:
  • Course on the ETL / related toolset.
  • Relevant data warehouse and BI solution training is essential.
  • B.Sc. or related degree is advantageous.
  • 2+ years programming experience.

DUTIES:
  • Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.
  • Conduct planning, analysis and design activities in conjunction with other development specialists.
  • Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.
  • Participate in estimation of tasks and assist in the development of project plans.
  • Code or makes modifications to programs of high complexity, according to specifications.
  • Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.
  • Conduct walkthroughs and quality review of deliverables.
  • Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
  • Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.
  • Participate in the formulation of standards to support the data acquisition development process.
  • Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.
  • Ensure compliance with established policies, standards and methodologies.

Job Category:

Business Intelligence, Data Warehouse, Database Developer, IT Consultant
We are the #1 job site for IT Jobs in South Africa. The CompuJobs job site is your all in one it recruitment solution. Whether you are a candidate seeking a new IT job or a recruiter looking to hire IT staff, we are here to help you achieve your objectives. CompuJobs has been serving the information technology employment sector in South Africa since 2007. Job seekers please register to submit your CV and apply to jobs. Employers and recruitment agencies please check out the Employer Pricing page for available job posting and recruitment services. This is South Africa's information technology recruitment and career website. Your IT job search starts here. Let's get working!

PayFast

CompuJobs IT Job Portal - Your #1 resource for IT jobs in South Africa.

Copyright © 2018 CompuJobs | All Rights Reserved