Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness
Monitor and modify ongoing SSIS operations
Provide production support of existing ETL processes
Provide regular project updates to management and analysts as needed
Develop cross validation rules to ensure mapping accuracy
Communicate issues, risks, and concerns proactively to management
Document ETL process thoroughly to allow peers to assist with support as needed
Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
Requirements:
3+ years of MS-SQL databases, SSIS / SSRS development experience