What are the responsibilities and job description for the SQL BI Developer position at IT Trailblazers, LLC?
Job Details
Note : We are looking for resources who can join our W2 only , no third-party , no C2c resumes.
Job Title : SQL BI Developer
Duration: 6 month contract
Location: Fairfield ,CA ( LOCALS are strongly preferred )
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
Client 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. - 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.
