Developer (Data Warehousing)
Ntice Sourcing Solutions
Cape Town, Western Cape, ZA
5d ago
source : Careers24

An established financial services provider based in *Cape Town* is looking for an intermediate to *senior level Developer (Data Warehousing)* that has extensive experience in relational and dimensional database structure and design.

  • Qualifications : A completed degree or diploma in information science or related technical discipline.* Knowledge of financial concepts and terms* Financial Services industry experience advantageous*
  • Requirements :

    5-8 years SQL experience (stored procedures, UDF's, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc.

    is essential* Experience with data integration, validation, and reconciliation (SSIS or similar)* Knowledge of reporting technologies (SSRS, PowerBI or similar)* Experience with creating and maintaining cubes (SSAS) would be advantageous* Expert experience with relational and dimensional database structures* Experience working in AWS Cloud implementation would be an advantage* Exposure to PostgreSQL would be an advantage*Responsibilities : Work as part of a larger IT team using the Scrum methodology* Interact with business users, Business Analysts, and other developers to understand user requirements* Develop integration solutions using T-SQL and other vendor integration tools* ETL development to load Data warehouse* Maintain existing SSRS report definitions to present the data* Support existing integration and reporting solutions in the production environment by analysing problems reported by users and track down their cause through debugging techniques and discussion with other team members* Testing and deployment of new development

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form