Curran Daly & Associates
Published
March 15, 2019
Category
IT  
Job Type
Work Experience
SOLID understanding of data warehousing concpets; 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

Data Analyst (Night shift)   BGC, Taguig | Makati | Quezon City | Alabang, Philippines new
March 16, 2019
IT Service Management (ITSM) Lead   Pasig, Philippines new
March 15, 2019
Solutions Architect (Pasig - Day shift)   Pasig, Philippines new
March 15, 2019
Front-End Developer (UI/UX)   Alabang, Muntinlupa, Philippines new
March 13, 2019
Azure CloudOps Engineer   BGC, Makati, Philippines
March 12, 2019
Share This
Are you sure you want to delete this file?
/