Description
If you cannot be on PeopleSourcer's payroll as a w-2 employee, please do not respond to this position.
Primary responsibility is the development of ETL processes:
- Technologies required: SSIS, MS SQL Server 2008, Oracle (Perferred)
- SSIS Advanced component experience required (transformation objects in data flow)
- 4 years of advanced SSIS experience
- Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness
- Develop cross validation rules to ensure mapping accuracy
- Define Technical Approach documents (define calculated logic, process flow, etc.)
- Meet all defined requirements of the project
- Provide production support of existing ETL processes
- Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
- Provide regular project updates to Information Analysts and management as needed
- Communicate issues, risks, and concerns proactively to management
- Document ETL process thoroughly to allow peers to assist with support as needed
- Self-sufficient and strong communication skills (must be able to work with external groups/departments)
- Must be skilled with MS Office applications
- Data Warehousing experience preferred