Data Warehouse Developer

Tech Rakers
11 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Tech stack

ETL
Data Mart
Data Warehousing
Microsoft SQL Server
Oracle Applications
SQL Server Integration Services
Data Management

Job description

Sr. ETL developer in support of the new core system implementation.

  • Responsible for the entire flow of the data into the Data Warehouse and Provider expert guidance on the architecture & design of EDW
  • Develops and maintains in-depth understanding of SQL Server, Oracle & SSIS.
  • Understands Data Warehouse design concepts; should know Kimball methodology
  • Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW.
  • Provides support for all Master Data Management (MDM) aspects involved in the development of the EDW.
  • Responsible for the transition of documentation, security, development and testing of all procedures in the EDW.
  • Responsible to train new staff on ETL architecture, ETL standards and ETL documentation.
  • Responsible for the coordination of the production, development and sandbox environments.

Requirements

7+ years of SQL Server development experience 3+ years of ETL/SSIS experience Must have Data Warehouse development experience Must have experience creating data marts

Sr Data Warehouse Developer to support the implementation of Jiva by ZeOmega. They are a MS SQL Server environment; they use SSIS for ETL. PHC is redesigning their data warehouse to support the new core/claims system., 7-10 years of SSIS and SQL Server development experience

Apply for this position