SQL BI Developer

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.

Degree Requirement: Bachelor’s Degree in Computer Science, Computer information systems, Information technology or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.