1. Design, build and deploy effective data migration packages utilizing SQL Server Integration Services (SSIS).
2. Write stored procedures, triggers and user defined functions using Microsoft SQL Server/T-SQL to extract, transform and load legacy data.
3. Build Business Intelligence solutions in a collaborative, agile development environment.
4. Write application code using .NET C# and Microsoft SQL with the ability to create both desktop and web based interfaces.
5. Integrate SSIS packages with D365 CRM (Customer Service) or D365 Finance (formerly AX) to load the transformed data into the new application.
6. Create automated release packages and ensure data migration solutions are added to the department’s source control system as per ministry standards.
7. Use discretion and make sound decisions while working with a minimal amount of direction while being pro-active in keeping their management informed of project related issues.
8. Communicate project status and issues to the program and client management.
9. Respectfully question ideas and share a point of view with others in support of the business requirements and needs.
10. Utilize an agile methodology such as Kanban, Scrum, or SAFe to organize workload and to short iterations with rapid feedback loops.
11. Lead troubleshooting and root cause analysis activities when transforming the legacy data.
12. Produce technical documentation and reference materials.
13. Produce database ERD diagrams and systems design manuals.
14. Perform unit and integration testing.
15. Participate in release and iteration plans.
16. Perform additional responsibilities as required by the Project Manager
Any Gradute