Curran Daly & Associates
Published
February 12, 2019
Category
IT  
Job Type
Work Experience
3-5 years of experience in ETL/DWH development and support using SQL stack (SSIS, T-SQL, etc.)

Description

  • Data Warehouse ETL Specialist
    • Involved in data acquisition to extend the Enterprise Data Warehouse data coverage, ensuring data readily available for future initiatives
    • Involved in projects through model, design, build and test of Data warehouse interface, ETL and Data model services
    • Configure and maintain and improve EDW Reconciliation Framework
  • Data Quality Management
    • Work with Data Quality Manager to identify data quality issues and facilitate resolution at source
    • Setup monitor to detect relapse of data quality issues
    • Master Data and Reference data issue management
  • DWH Application Support
    • Support the Data Warehouse Operations Specialist, help out with urgent BAU tickets and minor enhancements
    • Involve in Continuous Improvement activities to ensure better DWH experience for end user
  • Environment Management
    • Prepare project environment(s), code deployment for development and test purposes.
    • Align Data Warehouse environment and source code management with the Strategic enterprise solution. This include database restore, TFS code merge and deploy from Dev, SIT and UAT branches.

Key Qualifications

Required
  • A degree in Bachelor of Computer Science or similar
  • Minimum of 5 years Microsoft SQL Server:
    • Best Practice SSIS ETL design and Build
    • TFS Source Code Management
    • Transact SQL
    • Stored Procedures
    • Database Tuning
  • Minimum of 4 years Data Warehousing:
    • Kimball Methodologies
    • Star Schema Design
    • Enterprise Data Warehouse
    • Strong skills in Confluence and Jira
Desirable
  • Microsoft SQL Server Certification
  • Kimball University qualifications
  • Data Vault 2.0 practitioner certified
  • Demonstrated knowledge of:
    • Financial subject area data modelling
    • Data Vault Methodologies
    • Agile Methodologies
    • Microsoft BI Stack (SSAS)
    • Financial Services Industry,  experience within a similar role
    • Cognos BI Stack
    • Code automation and BIML
    • SQL Server MDS and DQS
    • Database Administration
Apply
Please give us a link to your LinkedIn profile, if you have one.
Drop files here browse files ...

Related Jobs

DevOps Engineer (AWS/Azure/Google Cloud)   Makati / BGC, Philippines new
February 19, 2019
February 19, 2019
February 19, 2019
Android Developer   Ortigas, Pasig City, Philippines new
February 16, 2019
Test Manager   Makati City, Philippine, Philippines new
February 16, 2019
Share This
Are you sure you want to delete this file?
/