Integration Specialist

The RoleThe key function of the API Integration Specialist is to use APIs, for client implementations for Smartvm API and apexportal Solutions software applications. We are seeking an experienced individual with knowledge of data driven APIs and business knowledge. This person will possess implementations with software-as-a-service and on-premises solutions.

This position is in our apexportal Solutions department, which implements and consulting services for apexportal to our clients. The candidate should work to become an expert on apexportal Solutions functionality and implementation procedures. The

Work:Assist clients in designing and configuring interfaces between their ERP systems and smartvm, apexportal and lead the testing of ERP integrations which includes reconciling data between client's ERP system(s) and apexportal. Lead integration and onboarding efforts with internal teams and customers. Assist clients in designing and developing interfaces between their ERP systems, apexportal and lead the testing of ERP integrations which includes reconciling data between client's ERP system(s) and apexportal.

Support existing internal/client facing APIs specific to the client's requirements which include design/re-design and developing microservices, API proxies, SSIS packages, setting up nightly batch jobs using SQL Server Management Studio and C#. Lead working sessions with developers from the client end to help in the integration process which requires expertise in business knowledge. Develop various stored procedures, triggers, reusable functions using Microsoft SQL server.

Designing interactive graphs to track multiple APIs usage and analysis using Azure, PowerBI.Responsible for the overall security of systems they will be administering including protecting client data and reporting situations which may provide unintentional elevated access. The employee will regularly review corporate policies and will enforce the policies documented in the Apex Corporate Security Standards. Present functional overview and functional requirements to clients when planning implementations and upgrades.

Setup of technical environment and serve as the technical expert for hosted clients. Solve complex business and application problems independently and serve as a primary contact for our SmartVM application. Develop, Implement, and enhance high impact business process improvement projects.

Continuous delivery and quality check of data via the APIs or application interface 24x7. Troubleshoot network, database, and software problems for our client implementations. Conduct training for designated clients.

Work with Infrastructure personnel to resolve client integration issues. Communicate/coordinate with Client Value Team as well as Audit team to support clients. Involve in other in-house Research & Development project of apexportal Solutions

The Must-Haves:Hands on experience in SQL Server. Strong database fundamentals and expertise.

Strong knowledge in REST, SOAP APIs, interfaces and data delivery via APIs. Hands on experience in Postman, Debugging Tools, for developing SOAP or REST IntegrationsKnowledge of standard API/Web Service authentication/authorization practices (OAuth)Knowledge of CSV, XML, and JSON file formats. Knowledge of data related applications and best practices for review of data quality.

Strong SQL skills - ability to create complex Stored Procedures, indexes, views and jobs. Data definition, data manipulation, data control, and transactional controlAdministration, including creating and restoring SQL backupsGood knowledge on SSIS - Developing and deploying SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems. Ability to create and maintain Mockups, BRD, FRD and Wireframes using various applications like Visio, Excel, Microsoft Project, Adobe.

Windows networking, including IIS and Windows security admin. Working knowledge of API management tools such as Apigee, Azure or other industry standard tools. Experience in version control tools like TFS, CVS, SVN, GIT to manage and control software development.

Working knowledge of HTTP, FTP, secure FTP, and PGP.Good working knowledge of Microsoft Office (Excel and Outlook). Ability to juggle multiple projects and adapt according to the changes in projects. Experience working with Agile Development methodologies.

Required Experience:Bachelor's degree in Computer Science or related discipline with 2 years' related experience or Master's Degree in Computer Science, Information Sciences or related discipline with 1 year of related experience preferred.2 years of experience as an implementation specialist, data analyst, or in a similar role with exposure to Data Warehousing concepts and exposure to multi system APIs.1 years IT background including multiple API (REST/SOAP) Development and Integration with both software-as-a-service and on-premise solutions.2 years of SQL.1 years SSIS.Excellent written, verbal, and presentation skills. Customer-facing experience with large customers preferred. Experience working with cross functional teams and business units to define application and system configuration standard.

Over the years, we've discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call "The apex Way". Read more about

The apex Way -