Responsibilities:
- Designing the Technical Addendum for high level data migrations as per the client requirement.
- Designing, developing, and supporting Operational Data sources, Data warehouses or data marts.
- Developing Microsoft Bl stack mainly in T-SQL, SSRS.
- Follow Microsoft SQL and database best practices to improve the operational reporting environment while focusing on resolving problems raised by team members, stakeholders and end users.
- Designing, developing and supporting Operational Data sources, Data warehouses or data marts
- Create new and modify existing SSRS reports for operational reporting.
- Update records in SSMS on daily-basis for various databases.
- Create various stored procedures required for inserting the data into various SQL task transformations.
- Create SSIS packages for migrating the data from source to destination.
- Create data flow tasks in the SSIS packages have internal migrations that are done using various transformations.
- Check-in & Check-out of the data after every modification done for the SSIS package using SVN Report.
- Run and unit testing the SSIS packages.
Work location is 66 Middlesex Avenue, Suite #309 Iselin, NJ 08830 with required travel to client locations throughout USA.
Please mail resumes to e-mail to contact@zettalogix.com