Ab Initio Data Engineer

PBT Group, leading Data Specialists, has an opening for an experienced Ab Initio ETL Developer in Johannesburg.

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.

SKILLS REQUIRED:

- A sound knowledge of Ab Initio (2+ years’ experience).

- ExpressIT experience would be highly beneficial

- Strong ETL experience

- Strong SQL experience

- Banking Industry experience

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

- Relevant data warehouse and BI solution training is preferred.

- B.Sc. or related degree is advantageous.

Qualifications/ Certification:

- A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent