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
SeniorJob 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