What are the responsibilities and job description for the SQL Developer position at IT Trailblazers, LLC?
Job Details
Role: SQL Developer
Duration: 12 months
Location: Fairfield ,CA
Direct client
Required Skills:
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
Job Description
PHC is looking for a 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.
Link to platform:
- 7-10 years of SSIS and SQL Server development experience
- 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.
