Bi oracle data

MAIN PURPOSE The BI Data Integration Developer is responsible for developing scalable and robust data solutions for integrating data from disparate sources into an Oracle 11g Data Warehouse and Analytical Platform that will support diverse reporting and analytical capabilities. KEY OUTCOMES Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. FUNCTIONAL COMPETENCIES In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Good written and verbal communication skills Disciplined in applying BI standards but open to suggestion and change MINIMUM QUALIFICATION Relevant 3 year tertiary or NQF aligned qualification. EXPERIENCE REQUIRED Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits SALARY: R360K - R420K p.a. LOCATION: Cape Town JOB TYPE: Contract (6 months)

Terms 6 month Contract Duties and Responsibilities Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. Competencies In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Disciplined in applying BI standards but open to suggestion and change Qualifications and Experience Relevant 3 year tertiary or NQF aligned qualification. Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits Please note: Only shortlisted candidates will be contacted. Send your updated CV to info@acsrecruitment.co.za or visit our website at www.acsrecruitment.co.za

Duties and Responsibilities Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. Competencies In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Good written and verbal communication skills Disciplined in applying BI standards but open to suggestion and change Qualifications and Experience Relevant 3 year tertiary or NQF aligned qualification. Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits Please note: Only shortlisted candidates will be contacted. Send your updated CV to info@acsrecruitment.co.za or visit our website at www.acsrecruitment.co.za

The BI Data Integration Developer is responsible for developing scalable and robust data solutions for integrating data from disparate sources into the Data Warehouse and Analytical Platform that will support diverse reporting and analytical capabilities. KEY OUTCOMES Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. FUNCTIONAL COMPETENCIES In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Good written and verbal communication skills Disciplined in applying BI standards but open to suggestion and change Analytical thinking and disciplined problem solving Meticulous and attention-to-detail focus Able to effectively participate in cross-team communication and cooperation Strong self-organisational skills for managing time and work effort Self-motivated with a can-do attitude Ability to work and act independently and as part of a team MINIMUM QUALIFICATION Relevant 3 year tertiary or NQF aligned qualification EXPERIENCE REQUIRED Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits

An exciting new career opportunity is available in Johannesburg for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. · Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: or fax to: , you can also contact Sharne on . Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

An exciting new career opportunity is available in Cape Town for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: it.jobs@hireresolve.co.za or fax to: 086 600 7977, you can also contact Sharne on 011 807 8064. Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

An exciting new career opportunity is available in Johannesburg for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: it.jobs(at)hireresolve.co.za or fax to: 086 600 7977, you can also contact Sharne on 011 807 8064 Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

Key Responsibilities Improve business performance or cost optimization through enterprise information solutions, such as master data management, metadata management, business intelligence, content management, data interoperability, analytics, data integration and related information infrastructure components. Focus on the high level information repositories and information flows that will meet the requirements of the business strategies and business processes. Provide guidance to BI Analyst and Engineers. Job Requirements A solid understanding of data architectural principles and patterns. A sound understanding of data fundamentals, including conceptual modelling, database design and database management. A sound understanding of data management principles including data quality assurance and data governance. Experience leading a team of analysts and data engineers. Experience in data analysis and business intelligence. Experience using source code control systems, development and testing tools. Experience implementing enterprise MDM and data integration technologies (Talend, Oracle MDM, Pentaho, etc.). Experience implementing data warehouses and data visualisation technologies. Experience working in an Agile software development environment. Clear, concise communication skills. An honours degree in Computer Science or Information Systems preferred. A desire to get things done. Job Specific Competencies Solution orientated approach. Good understanding of systems, information processing, data integrity and information reporting. Analysis and interpreting information for decision-making. Effective verbal and written communication skills. Ability to work effectively in a team. Good stress management and ability to work under pressure.

Minimum Requirements and Qualifications: Strong development experience, knowledge of OOP principals and other good practice patterns Experience with rational database management systems Experience with data query tools Experience with source code control systems Knowledge of Oracle Spatial or spatial concepts a plus Duties and Responsibilities: Develop and modify Oracle packages, stored procedures, functions and triggers and functions in PL/SQL which will be used by their systems applications. Create database tables, indexes, views, triggers and other objects in the development environment Participate in all phases of the Software Development process including design, development, testing deployment and maintenance. Maximize performance by analysing the execution plan and applying optimizers as needed. Resolve problems that arise with existing production applications to ensure the efficient and proper functioning of application components

Service Delivery Lead - Oracle BRM Start: March 2016 Type: Contract Duration: 16 months Location: Johannesburg Rate: Negotiable Accountable for End to End (E2E) watch over service performance and day to day service operations on Oracle BRM Billing Operations domain. Lead, plan, direct and control all activities related to Service Management and Technical Operations in the Billing Operations domain. Responsibilities: • Manage day to day billing operations, by delivering components of standard services from a defined service catalogue and RACI matrix • Verify service operations against stated Service Level Agreements (SLAs) and Operational Level Agreements (OLAs) • Provide and maintain a single source of consistent information on all Billing services delivered to the business • Support the definition, implementation, and continuous improvement of policies, processes and procedures that deliver consistent and reliable billing products and services to business and customers • Monitor, measure, report and review current performance of services and components in the billing environment • Ensure that proposed changes are controlled, monitored, and implemented with minimum disruption to the billing services being delivered • Manage “live” daily and month end bill runs • Align service capacity and availability to match current and future business needs • Serve as point of escalation, review and approval for key issues and decisions for Billing Operations • Supervise management activities associated with both current and potential suppliers of AO • Direct and approve where necessary the maintenance or improvement of technical support activities and service management processes • Create a culture of stability, availability and performance in Billing Operations Knowledge and experience preferred: • Mobile telephony experience • 5+ years’ experience in billing operations • Oracle Billing and Revenue Management (BRM) • Oracle BI Publisher (component of Oracle OBIEE) Educational and Certification requirements • Degree or diploma in Information Systems or similar • ITIL foundation certified or similar

Mandatory requirements in Software knowledge and skills: · Microsoft Windows forms programming in VB.Net Frameworks (1.1 -3.5) · Visual Studio 2010 · Team Foundation Server · Visual Source Safe 6.0 · DEV Express 7.2 Components · Oracle 1Og, 11g and XE Databases · Oracle PL/SQL · Toad or equivalent tool · Web Services (Create and Consume) · Microsoft Message Queue · Internet Information Server (liS) · Oracle Data Provider for.NET · WinDebug for memory profiling and optimisation Please review the link provided for further information on the role: http://www.pcrecruiter.net/pcrbin/regmenu.aspx?uid=dlk%20group.dlkgroup

Mandatory requirements in Software knowledge and skills: Microsoft Windows forms programming in VB.Net Frameworks (1.1 -3.5) Visual Studio 2010 Team Foundation Server Visual Source Safe 6.0 DEV Express 7.2 Components Oracle 1Og, 11g and XE Databases Oracle PL/SQL Toad or equivalent tool Web Services (Create and Consume) Microsoft Message Queue Internet Information Server (liS) Oracle Data Provider for.NET WinDebug for memory profiling and optimisation Responsibilities/ Duties: Quality assurance of the products developed in response to the User Requirement Document. This includes Application Testing to ensure that the application meets the requirement and is of suitable form fit and function; Provide technical assistance and direction to sub-ordinates; Provide training and skills transfer to permanent and contract staff as required; Perform Technical Assessments of proposed third party and in-house sofiware solutions Please review the link provided for further information on the role: https://www.pcrecruiter.net/pcrbin/pcrnf.asp?uid=odbc.dlkgroup

Requirements: Diploma/Degree in Computer Science or equivalent experience 7 years’ working in as a SQL / Oracle Database administrator 3 years Microsoft SQL Server Administration (including installation & configuration, Data Replication, DTS/SSIS, Log Shipping, clustering, DB Mirroring) 3 years Oracle database management. Duties: Maintaining a Microsoft SQL Server ORACLE(Database Administration and maintenance including ORACLE spatial components Database Administration through the following environments: development, Testing, QA, Pilot training, Production and Disaster recovery environments Managing Data Replication Disaster Recovery(Backup, Restore, Log-Shipping) Quality Assurance Systems Analyst and Developer Support Performance Tuning ication(Including Replication through firewalls and Replications To ORACLE) Integration, Analysis Services/DTS SQL Scheduled Jobs, SQL Server Clustering Data warehousing Troubleshooting, Debugging and problem solving skills, Database development quality assurance, Enterprise DataS project Modeling In depth knowledge of; Oracle SQL Server

  Plan, organize and manage your projects with increased efficiency using Microsoft Project Professional 2016. Stay on top of your tasks and project details with stellar organizational and monitoring features. Retrieve data and report with ease using tools that allow seamless access across different projects. Synchronize and share with your team for effective collaboration and better information flow, all with Microsoft Project Professional 2016. Download and verify directly on the official Microsoft website License for permanent lifetime use on 1PC.  This is not a subscription.  No monthly or annual recurring fees. GLOBAL License Keys – Valid for any Country/Territory/Region Worldwide Features: So-called heat maps – a feature that required the involvement of an implementation partner in the past – make it possible to significantly speed up decision-making processes in resource management. A new addition for the 2016 version of Project Client is the option of managing multiple time axes for a project and display them as bars that lie on top of each other. Cloud Service Microsoft Power BI provides users with additional flexibility for creating reports and management dashboards using data from Project Server/Online. System requirements Processor: 1 GHz or faster x86 or 64-bit processor Memory: 1 GB RAM (32 Bit) /2 GB RAM (64 Bit) Hard Disk: 3.0 GB of available disk space Operating System: Windows 7, Windows 8, Windows 8.1, Windows 10 with .NET 3.5 or greater NOT COMPATIBLE WITH MAC OR OFFICE 365