SSIS developer

Job Description

Job Title: SSIS developer
Client: UST
Location: Remote
Duration: 12 Months+

Job Summary:
UST Global® is looking for a SSIS Developer to build end to end business solutions and to work with one of the leading healthcare providers in US. The ideal candidate must possess excellent background in Service now technologies. The candidate must possess excellent written and verbal communication skills with the ability and collaborate effectively with domain and technical experts in the team

Responsibilities

As a SSIS Developer, you will

• • Hands-on experience developing ETL processed in MS SQL environment using SSIS, SQL & stored procedures
• Experience in utilizing MS SQL Server for DDL/DML/DCL, specifically as it relates to database design, implementation, efficiency and performance
• Hands-on SQL Programming experience required
• Ability to test scripts and review and document results
• Experience developing data models for database schemas, stored procedures, functions, views, triggers in OLTP and OLAP-based environments
• Experience with fundamental administrative performance and design capabilities including indexing, partitioning of data, creating and restoring backups, jobs, etc.
• Fundamental understanding and exposure to data management capabilities
• Experience in SSIS package scheduling using SQL server agent

Requirements

• ServiceNow experience administering the platform, monitoring performance, deploying applications, building out catalog items/workflows, and configuring integrations
• Experience writing and debugging JavaScript – Client/Server sides
• Experience writing and debugging Angular, HTML, AJAX, CSS and third-party controls
• Experience with REST/SOAP API development – Integration with third-party platforms – OOP, JSON, Payload/XML
• Experience with upgrades and clones
• ServiceNow Developer Certification
• Working knowledge how configuration management factors into the ITIL framework
• Previous working experience with ServiceNow CMDB
• Previous working experience on ACLs
• Knowledge of relational database concepts – SQL
• Knowledge of .NET, C# and a programming proficiency in C#, ASP.NET is a plus
• Good written and verbal communication skills
• Good analytical skills
• Good project management and time-management skills
• Good problem-solving skills
• Good team work – team player

Good to have:
• Exposure to Cloud integration technologies.
• Experience with C# and the .NET Framework
• Experience or knowledge of Microsoft Power BI
• Experience in technical implementations of business intelligence applications that deliver business decision making capabilities.
• Experience with Web-based applications, including knowledge of various operating systems and application servers
• Experience in the healthcare domain